Data Warehouse Center Application Integration Guide

SourceDataBase.tag

Use this template to define source databases, file systems, or files to import into the Data Warehouse Center. You can use this template to define a relational non-DB2 source database as well as a DB2 source database.

This template also defines the relationship between the following objects:

• The source databases
• The agent site to use for the source database
• The security group in which to define the source database

Tokens

Table 38 provides information about each token in the template.

Table 38. SourceDataBase.tag tokens

Token	Description	Allowed values
Entity parameters
*DatabaseName	The name of the database. The name must be unique within the warehouse control database. This token is required.	A text string, up to 80 bytes in length.
*DatabaseDescription	The short description of the database. This token is optional.	A text string, up to 254 bytes in length.
*DatabaseNotes	The long description of the database. This token is optional.	A text string, up to 32700 bytes in length.
*DatabaseContact	The person to contact for information about this database. This token is optional.	A text string, up to 64 bytes in length.
*DatabaseServerName	The name of the server on which the database resides. This token is required for Flat File LAN files. Otherwise, it is optional.	A text string, up to 64 bytes in length.
*DatabaseVersion	The version of the database.	A text string.
*DatabasePhysicalName	The physical database name of the database as defined to the database manager, as known to ODBC. This token is required.	A text string, up to 40 bytes in length.
*DatabaseType	The type of database family. This token is required.	One of the following values: ISV_IR_DB2Family DB2 Family ISV_IR_Oracle Oracle ISV_IR_Sybase Sybase ISV_IR_MSSQLServer Microsoft SQLServer ISV_IR_Informix Informix ISV_IR_GenericODBC Generic ODBC ISV_IR_FFLan Flat File LAN ISV_IR_VSAM VSAM ISV_IR_IMS IMS
*DatabaseTypeExtended	The type of AS/400 system or file. This token is required.	One of the following values: ISV_IR_DB2400CISC DB2 UDB for AS/400 for CISC ISV_IR_DB2400RISC DB2 UDB for AS/400 for RISC ISV_IR_FFLanLocalCmd Local flat file ISV_IR_FFLanFTPCopy Local flat file sent using FTP from a remote system
*DatabaseUserid	The user ID with which to access the database. This token is optional.	A text string, up to 36 bytes in length.
Relationship parameters
*SecurityGroup	The security group in which to create the source or target database. This token is required, and you must specify the default security group.	ISV_DEFAULTSECURITYGROUP for the default security group.
*AgentSite	The agent site to use for the source or target database. This token is required, but you can specify the default agent site.	A text string, up to 80 bytes in length. ISV_DEFAULTAGENTSITE for the default agent site.
*CurrentCheckPointID++	An index, starting with 0, that increases each time that it is substituted in a token. This token is required.	A numeric value.

Examples of values

Table 39 provides example values for each token to illustrate the kind of metadata you might provide for each token.

Table 39. Example values for SourceDataBase.tag tokens

Token	Example value
*DatabaseName	Finance Warehouse
*DatabaseDescription	This database contains financial information.
*DatabaseNotes	This is the warehouse where all geographies keep financial information.
*DatabaseContact	Valerie Zieman
*DatabaseServerName	CHI11W71
*DatabaseVersion	V6.1.0
*DatabasePhysicalName	FINANCE
*DatabaseType	ISV_IR_DB2Family
*DatabaseTypeExtended	ISV_DEFAULTVALUE
*DatabaseUserid	DB2ADMIN
*SecurityGroup	ISV_DEFAULTSECURITYGROUP
*AgentSite	My agent site
*CurrentCheckPointID++	5