Connecting to an Oracle data source
To connect with Oracle data sources, you must perform the following tasks:
Install the proper Oracle client software on the server running the design.
Supply a connection string.
Define the appropriate environment variables.
Ensure that a listener process is running on the database host.
When configuring the Oracle client, you must configure the client’s locale setting to match the locale of the machine.