Creating a data source

This task describes how to create your own data source.

1. Expand Administration in the left navigation pane. Click Service Administration or Service Configuration.
2. Select Data in the Service Navigation drop-down menu.

   Data lists any data sources that have already been configured, in this case, the TBSMComponentRegistry data source that was installed with TBSM.

3. Click the Creat New Data Source button.

   The New Data Source tab opens in the Service Editor.

   Note: The Name field for rules, data sources, maintenance schedules, view definitions and other objects must not contain these special characters:

   " & < > \ / * ? | ( ) : ; $ ! %

   Names must not contain spaces. Otherwise, these objects may not be saved properly in the TBSM database. If the object does not save, remove any special characters or spaces from the name field.
4. Select the type of database you want from the SQL Type drop-down list.

   The fields shown depend on the type of SQL type selected.

   Table 1 describes the entries for an ObjectServer SQL Type:

   Table 1. Edit tab for data sources elements: ObjectServer selected

   Field	Description
   Data Source Name	A unique name for the data source. See important Warning below. Note: Do not under any circumstances name a data source of any type ObjectServer. Doing so will damage your application.
   Username	The user name required to access the database.
   Password	The password required to access the database.
   Primary Source:
   Host name	The name or IP address of the host system for the database.
   Port	The port number on the host system for the primary database.
   Failover Policy	If no backup data source is available, click Disabled. To fail over to a backup data source, click Failover. If you want the primary data source to take over when it becomes active again, click Failback.
   Backup Source (Optional):
   Host name	The name or IP address of the host system for the backup database.
   Port	The port number on the host system for the backup database.

   Table 2 describes the fields for the remaining SQL databases (not all fields apply to every type of database):

   Table 2. Edit tab for data source elements: SQL database selected

   Field	Description
   Data Source Name	A unique name for the data type.
   Username	The user name required to access the database.
   Password	The password required to access the database.
   Primary Source:
   Host name	The name or IP address of the host system for the database.
   Port	The port number on the host system for the database.
   SID (Applies to Oracle databases only)	Enter an Oracle service identifier. The default value is ORCL. For more information, see your Oracle documentation.
   Server	The server name where the database resides. (Informix only)
   Use Type 4 JDBC Driver (DB2 databases only)	When creating a DB2 data source in TBSM, the Use Type 4 JDBC Driver check box on the New Data Source window will be checked by default. If the check box is cleared, then the server attempts to establish connections to the DB2 database using a legacy driver which is no longer shipped or installed with the product. For more information, see the readme file located in $TBSM_HOME/contrib.
   Database (Not applicable for an Oracle database)	The name of the database you want to connect to.
   Failover Policy	If no backup data source is available, click Disabled. To fail over to a backup data source, click Failover. If you want the primary data source to take over when it becomes active again, click Failback.
   Backup Source (Optional)
   Host name	The name or IP address of the host system for the backup database.
   Port	The port number on the host system for the backup database.
   Use Custom URL (Applies to Oracle databases only	By clicking on "Yes", you can use customized URL to connect to oracle datasources, which allows for connection using service names. This is the same as using 'Customized URL' for connection settings in Impact GUI. If "No" is selected you must use SID for connection to an Oracle database. The default selection is "No".
   URL (Applies to Oracle databases only)	Description: This field is required if "Yes" is selected for Use Custom URL. The url prefix ""jdbc:oracle:thin:" is not required. Please see: http://www.ibm.com/support/knowledgecenter/SSSHYH_6.1.1.3/com.ibm.netcoolimpact.doc/user/rac_cluster_support.html?lang=en.
   SID (Applies to Oracle database only)	This field is required if "No" is selected for Use Custom URL. Enter an Oracle service identifier. The default value is ORCL. For more information, see your Oracle documentation.
   Server	The server name where the backup database resides.
   Database (Not applicable for an Oracle database)	The name of the backup database you want to connect to.

5. Verify that you have entered the correct information by clicking the Test Connection button. A window pops up, indicating whether database connection succeeded or failed.
6. Click Save.
   Note: If you create an Informix data source, restart the Data Server.