Bookshelf Home | Contents | Index | Search | PDF

Siebel Connector for PeopleSoft > Database Wizard > Example >

Setup Tools Configuration File

---

Once you have identified the external database and the tables, and created the appropriate external DB ODBC data source to connect to that database, you are almost ready to start creating the integration object. The integration object is created from Siebel Tools, and it needs to know where these external tables are.

These access parameters are set up in the Siebel Tools configuration file (tools.cfg). By default, you should see an empty [DBWizSubSys] section in the tools.cfg file.

So, the following section in the tools.cfg file should be changed to configure the connection to the target database:

[DBWizSubSys]

DBWizUserName = <database login>

DBWizPassword = <database password>

DBWizODBCWizDataSource = <data source name (as created above)>

DBWIZTableOwner = <database table owner>

Here are sample sections for the three supported platforms.

DB2

[ODBCWIZSubSys]

ExtDBUserName = db2admin

ExtDBPassword = db2admin

ExtDBODBCDataSource = SAMPLE

ExtDBTableOwner = db2admin

Oracle

[ODBCWIZSubSys]

ExtDBUserName = fsadmin

ExtDBPassword = fsadmin

ExtDBODBCDataSource = SQLOracle

ExtDBTableOwner = fsadmin

MS SQL Server

[ODBCWIZSubSys]

ExtDBUserName = SQLAdapter

ExtDBPassword = sqladapter

ExtDBODBCDataSource = SQLAdapter

ExtDBTableOwner = SQLAdapter

Just to show the variations in the values, the ODBC data sources we have created in the previous section have been named SAMPLE for DB/2, SQLOracle for Oracle, and SQLAdapter for MS SQL Server. You may choose a name that is appropriate for your integration project.

Bookshelf Home | Contents | Index | Search | PDF