Use the Warehouse Source page to add information about the new warehouse source that you are defining to the Data Warehouse Center.
Before you create the warehouse source, you must verify that the source exists and that you can connect to it using ODBC, or, if you are getting data from a file, that you can connect to the file source. You must define the resource as a system DSN for the appropriate ODBC driver for the resource.
Note for DataJoiner users: Because DataJoiner warehouse sources can consist of data from various sources such as Oracle databases, Oracle messages can be returned from the warehouse source. For information about these messages, consult the documentation for the warehouse source. You might want to document this type of information in the Notes field of this page so that other users understand why these messages are generated. In addition, it is a good idea to document the same information on the first page of the Step notebook, if you plan to create steps based on a DataJoiner warehouse source.
For more information about using DataJoiner as a warehouse source, see the Data Warehouse Center Administration Guide.
The Database page is displayed for database warehouse sources only.
Use this notebook page to provide database information for your warehouse source.
The Data Warehouse Center uses the agent site to connect to the source database on which the warehouse source is defined.
The Datasource name, Customize ODBC connect string, and ODBC connect string fields are applicable to non-DB2 Family warehouse sources only.
The Data Warehouse Center agents use the user ID and password to access the database during data extracts and when a table is created or dropped.
If your data source is a DB2 Common Server database, the user ID must have CONNECT privileges at the database level.
If your data source is an AS/400 database, you must type the user ID in uppercase letters.
For example, if you are using an AS/400 database, you must type the password in uppercase letters. For most databases, the password is case sensitive.
For ODBC warehouse sources that are included with the Data Warehouse Center, the Data Warehouse Center generates a connect string that contains the data source name, user ID, and password. If the string generated by the Data Warehouse Center does not work, select this check box to modify the string.
The Tables and Views page is displayed for database warehouse sources only.
Use the Tables and Views page to import or create definitions of tables to include in your warehouse source.
Use the Security page to select one or more warehouse groups for the warehouse source. Users in the warehouse group can then use this warehouse source as a source for their step.
For more information, see About Data Warehouse Center Security.
Use the Agent Sites page to specify which agent sites that have been defined to the Data Warehouse Center can access a warehouse source.
From this notebook page, you can select currently available agent sites from a list and add one or more agent sites that can access this warehouse source.
All warehouse sources that use the same agent site must specify the same connectivity information, such as the user ID and password for the site.
Some of the agent sites might not have access to the warehouse source, so verify that the site can connect to the warehouse source before you select the site.
Scroll to the right to view additional column information about the agent, such as host name and operating system type.
Scroll to the right to view additional column information about the agent site, such as host name and operating system type.
If your warehouse source is no longer available at the agent site, select the agent site and click <. The agent site moves from the Selected Agent Site list to the Available Agent Site list.
Use the Retry page to specify an interval after which the Data Warehouse Center will retry a data extract if the first extract fails. A default retry interval is automatically set for each warehouse source or warehouse target that you create. If you specify a new retry count and interval, it will become the default retry count and interval for any new step that you create.
The Data Warehouse Center retries data extracts when one of the following problems occurs:
A change is made to a step upon which the step that failed to run is dependent.
The Data Warehouse Center is unable to send a message to the agent daemon. This can occur when you attempt to run a step that uses an agent that is not running.
The Data Warehouse Center is unable to send a message to the agent. This can occur when the wrong host name is specified for the agent or when the connection to the agent is broken.
An error occurs while the Data Warehouse Center is receiving the start acknowledgment from the agent.
An error occurs while the Data Warehouse Center is receiving a message from the agent.
There is insufficient page file space for the agent.
The agent site is overloaded.
The Data Warehouse Center also retries data extracts when one of the following return codes is returned:
IWHO7902
IWHO7903
IWHO7904
IWHO7905
IWHO7906
IWHO7907
See the Data Warehouse Center Messages and Reason Codes online book for information about these return codes.
It is recommended that you use the default retry count and interval, but you can modify the retry count and interval to meet your requirements. The retry count and interval must be consistent with the schedule for the process. For example, you do not want to retry every 6 hours a process that is scheduled to run hourly.
The Files page is displayed for flat file warehouse sources only.
Use the Files page to add or delete a LAN file definition that you want to include in the warehouse source. You can also list existing LAN file definitions and modify a file definition.
