Transforming a logical data model into a physical data model

To be able to generate jobs, you must transform the logical data model into a physical data model. You must also create required tables in the database based on the physical data model.

1. Log in to InfoSphere® Data Architect.
2. Transform the logical data model into a physical data model.
   1. Right-click the logical data model that you have used to import metadata from SAP, and then select Transform to Physical Data Model.
   2. Select Create New model, and then click Next.
   3. Select IBM® DB2® as the target database, and then click Next.
   4. Verify the settings, click Next, and then click Finish.
3. Create an ODBC connection from the target database
   1. Identify an IBM DB2 database in your system landscape as a target database to hold SAP data.
   2. Create an ODBC connection from server to the database. The procedure to create an ODBC connection depends on the operating system. For more information, consult your system administrator.
4. Optional: Create a connection to the target database from InfoSphere Data Architect. You can skip this step if you want to run the DDL script manually.
   1. In the Data Source Explorer view, right-click Database Connection, and then click New.
   2. Follow the instructions in the New Connection wizard to create a connection.
5. Create an ODBC connection from the InfoSphere DataStage® Server to your target database.
6. Right-click the new physical data model file (.dbm file) and select Generate DDL.
7. Follow the instructions in the Generate DDL wizard to create a .sql file in the data design project.
8. Run the DDL script on the new connection.
   1. Right-click the .sql file in the SQL scripts folder of the data design project and select Run SQL.
   2. Select the database connection and finish the wizard.