Defining data sources for CI type and actual CI data

These data sources contain the details required to transmit data to the Maximo® 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 drop-down 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: If appropriate, click Test Connection to test the connection to the data source. Integration Composer displays a Test Connection dialog box, which indicates whether the test was successful. To respond to the dialog box, 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 box. 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 box. 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 box.
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 box. Resolve any errors and try defining the data source again. For error information, refer to the log files located in the log folder in your installation directory.