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.