Use Classic Data Architect to create relational tables and views
that map to data sources in supported non-relational database management systems.
With IBM® WebSphere® Classic
Federation Server for z/OS®, client applications can issue SQL queries against
these tables to access data in the non-relational databases. Client applications
can also issue INSERT, DELETE, and UPDATE requests against the tables to modify
the data in the non-relational databases.
Before you begin
You
must perform the following tasks on the data server where the query processor
will run:
- Create and initialize a metadata catalog.
- Set up the configuration file.
- Start the data server.
About this task
You
create the relational tables and views in a project in Classic Data Architect.
Then, you promote these objects to a data server.
Procedure
To create tables and views that you can use
to query and update data in non-relational databases:
- Configure Classic Data Architect by creating prerequisite objects,
creating connections to data servers, setting preferences, importing reference
files, and granting privileges. See Configuring Classic Data Architect.
- Create tables and views that client applications can issue SQL
queries and updates against. See Mapping data for Classic federation and Creating views on existing tables.
- Optional: Modify your tables or views. See Viewing and modifying objects.
- Generate and run DDL to promote your tables, views, indexes, and
stored procedures to a data server. See Generating DDL.
- Optional: If you choose not to run the DDL from Classic
Data Architect but from the metadata utility, export the DDL to a remote z/OS host. See Exporting SQL to remote z/OS hosts.