WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Mapping tables for Classic federation

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:

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:

  1. 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.
  2. Create tables and views that client applications can issue SQL queries and updates against. See Mapping data for Classic federation.
  3. Optional: Modify your tables or views. See Viewing and modifying objects for Classic federation.
  4. Generate and run DDL to promote your tables, views, indexes, and stored procedures to a data server. See Generating DDL.
  5. 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.
Related concepts
Introduction to Classic Data Architect
Populating metadata catalogs
Viewing and modifying objects
Related tasks
Mapping tables and creating publications for Classic event publishing
Mapping tables for Classic replication
Adding or replacing columns in tables based on data definition files
Related reference
Column properties
Table properties
View properties


Feedback

Update icon Last updated: 2007-07-11