Database Connectivity for Staging Tables

By Imran, Mohammad February 28, 2023 under LTMC

Database connectivity is required for staging tables. If this step is not completed then you cannot create a project with remote database connectivity. If you are not from Basis team then you may face access issues over database or other part of SAP. Better get help from Basis team for this step as they can navigate through easly.

Do the following things to complete the database connectivity

1. Run a t-code DBCO and create a new Database connection as below.

List of connections already created by another users.

Now create one more entry as below.

• DB Connection - Give a name of your own, this name will be used in LTMC project creation.
• DBMS - Choose a database from the dropdown.
• Enter Username and Password of that database. Password needs to be entered twice.
• Connection info - The host name of your database you used to connect with the database.

Once connection details are entered, save it and come back.

2. Run a t-code SM30 and open a table called DMC_C_WL_DBCO_OP as below.
• Create a new entry with the same name that you had entered in earlier step in DB Connection field

The DB Connection is created, now you are good to create a project.

Next thing to do is create a project and start data migration for certain objects - follow the steps here