If you have problems connecting to the data source from Integration Services Console and have ruled out problems with the data source, database client, ODBC, and Integration Server, the problem likely originates in the Integration Services Console component.
To correct problems connecting to the data source from the console, investigate the following possible causes:
Is Integration Services Console installed? Are all required components installed?
The following components must be installed to have a functional Integration Services Console client:
Is the Integration Services Console configured properly?
Make sure the required environment variables are set. Run the Oracle's Hyperion Enterprise Performance Management System Configurator as described in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Are the Integration Server computer name, ODBC data source names, user names, and passwords specified correctly?
For the Integration Server computer name, verify that you are using the correct spelling and uppercase and lowercase letters for the server name. For OLAP Metadata Catalog and the data source, make sure you are using an ODBC data source name, which may be different from the data source database name.
See Correcting Data Source Problems.
Does the user account with which you are running Integration Services Console have permission to connect to the computer running Integration Server?
You must have a user account and appropriate access permissions on the server computer running Integration Server.
If you have Integration Server installed on more than one computer, have you specified the correct server name?
A particular Integration Server may not be set up to access the same OLAP Metadata Catalogs and data sources used by other servers.
Are you using adequate addressing to identify the Integration Server computer?
Depending on the size and configuration of the computer network, it may be necessary to use a fully-qualified host address to connect to a particular computer. For example, instead of the host name “cypress,” the complete host name “cypress.mydivision.mycompany.com” may be required. Alternatively, you might need to use the IP address number for the server computer; for example, 127.0.0.1.