Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Using the DAC's Data Warehouse Configurator Wizard >

Configuring the Informatica Repository (in Repository Server Administration Console)

---

Before configuring the Informatica Repository, do the following:

• Create the ODBC connection for the Siebel Data Warehouse.
  • If you are using a SQL Server database, create an ODBC connection for the Siebel transactional database (OLTP). This is required if the SQL Server is Unicode.
• Make sure the Informatica software has been installed.

To configure the Informatica Repository

1. Start the Informatica Repository Server service.
2. Start the Informatica Repository Server Administration Console.
3. Add a new server. It is recommended that you use the machine name where the Informatica Repository Server is installed.
4. Connect to the repository. The default password is Administrator.
5. Click Add Repository and add Siebel_DW_Rep to the Cache.
6. Enter the Database Type.
7. Enter the Repository Name as Siebel_DW_Rep.
8. Enter the Connect String Name. If you are using an MSSQL Server database, use SERVERNAME@DATABASENAME.
9. Enter the Code Page based on the operating system platform.
10. Enter a User and Password, and then click OK to save the information.
11. Select the repository, right-click and start the Informatica Repository Agent.

NOTE:  The Informatica repository tables need to be analyzed for better performance. This procedure must be done manually by the database administrator.

Bookshelf Home | Contents | Index | Search | PDF