To correct problems using ODBC to connect to the data source, investigate the following possible causes:
Is the ODBC software installed? Are all required ODBC components installed?
On Windows systems, make sure the ODBC core components and any required drivers are installed. On UNIX systems, the Integration Services setup program installs the required ODBC core components if you choose to install the DataDirect ODBC drivers.
Is the ODBC driver compatible with the data source? Is the driver compatible with the operating system?
Verify that the ODBC driver you are using is supported by Integration Services by referring to the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html)>.
Are the data source server names, database names, user names, and passwords specified correctly in the ODBC data source?
Make sure you are using the correct names, including the exact spelling, uppercase or lowercase letters, and any required data source-specific identification syntax. On Windows systems, configure ODBC data sources by using ODBC Administrator. On UNIX systems, configure ODBC data sources by editing the odbc.ini file manually.
IBM DB2: On Windows systems, the IBM DB2 Client Configuration Assistant shows the ODBC DSN.
On UNIX systems, have you specified the full path and file name of the ODBC driver for the data source in the odbc.ini file? Does the ODBC driver actually exist in the specified directory? Can ivtestlib (32-bit) or ddtestlib (64-bit) load it?
Try copying the driver path and file name from the odbc.ini file and pasting it into an ls command. If the file is not listed when you execute the command, check the accuracy of the driver path and file name in the odbc.ini file.
Are any parameters missing in the ODBC data source configuration?
On Windows systems, make sure you have filled in all required parameters for the data source in ODBC Administrator. On UNIX systems, the Integration Services installation provides a sample odbc.ini file, which may not include data source parameters required for the data source that you are using. For information on required data source-specific ODBC driver parameters, see the ODBC documentation provided with Integration Services. For examples of odbc.ini file configurations for the supported data source platforms, see the Configuring Data Sources..
Can other applications connect to the data source by using ODBC?
If you can identify another application that is successfully using ODBC to connect to databases on the data source, analyze the configuration of the computer from which the connection is made and use it as a model for the computer connections you are trying to fix.
If the preceding checks do not enable you to correct the problems connecting from ODBC to the data source, try using ODBC tracing to isolate the problem. See Using ODBC Tracing.