Defining data sources for CI type and actual CI data

These data sources contain the details required to transmit data to the target database.

1. Sign in to Integration Composer.
2. Select Define New Data Source.
   The Data Source page is displayed in the Define a New Data Source window.
3. Select CCMDB75CIType and click Next.
4. In the Data Source field, type a name for the data source. The name must have at least two characters and is case-sensitive.
   For example, type CCMDB75CIType. Then click Next.
5. In the Connection Method list, select the access method for your database:

   Table 1. Connection methods for each database type

   Database	Connection method
   DB2®	IBM® Db2 JDBC Driver
   Oracle	Oracle JDBC Thin Driver
   SQL Server	i-net OPTA JDBC Driver for Microsoft SQL Server 7 / 2000 / 2005

6. Type in the connection parameters, as required.
   For example:

   Connection Method:

   IBM Db2 JDBC Driver

   Host Name:

   db.host.tiv.austin.ibm.com

   Host Port:

   1521

   Host SID:

   ctginst1

   User Name:

   maximo

   Password:

   ********

   Table Owner:

   maximo

7. Optional: Click Test Connection to test the connection to the data source.
   Integration Composer displays a Test Connection dialog, which indicates whether the test was successful. To respond to the dialog, select one of the following options:

   • If Integration Composer establishes a connection, it displays a confirmation message. Click OK. Integration Composer closes the Test Connection dialog. Go to step 8.
   • If Integration Composer cannot establish a connection, it displays an explanatory message. Click OK. Integration Composer closes the Test Connection dialog. Review the values for the connection parameters and retry the connection.

   Note: Test Connection verifies only the host name and port, without invoking underlying Integration Composer processes. Upon finishing, it is still possible to receive save errors that are unrelated to this connection information. (JDBC drivers that do not comply with JDBC 2.0 probably do not support this feature.)
8. On the Connection Information page, click Finish.
   Integration Composer displays a Save dialog.
9. Click OK.
   Integration Composer returns you to the main window.

   Note: If Integration Composer does not save the data source successfully, it displays one or more error messages. Click OK. Integration Composer closes the error message dialog. Resolve any errors and try defining the data source again. For error information, see the log files located in the log folder in your installation directory.