ADF and Synapse: Create a Linked Service to the Oracle Fusion Data Source

Modified on Thu, 6 Aug at 10:46 AM

Before you start

BI Connector is installed on the Integration Runtime server and your license is activated. If not, start with installation of Server Edition.
You have a BI Connector Data Source set up. If not, select your choice here and set up your Data Source first.
The Self-hosted Integration Runtime is installed and running on the same server as BI Connector.
You have access to your Azure Data Factory or Synapse workspace.

Important — Using an Integration Runtime cluster with multiple nodes? ADF / Synapse can route a refresh request to any node at the time of refresh. Make sure the BI Connector Data Source (and Table, if applicable) is configured identically across all nodes in the cluster.

Steps

Step 1 — Open Linked Services

Step 2 — Create a new Linked Service

Click + New at the top left. In the search box, type ODBC, select ODBC from the results, and click Continue.

Step 3 — Name the Linked Service and select the Integration Runtime

Enter a name for the Linked Service. In the Connect via integration runtime field, select your Integration Runtime from the drop-down.

Step 4 — Enter the Connection string

In the Connection string box, enter your BI Connector Data Source name prefixed with dsn=. For example, if your Data Source name is Oracle Fusion PROD, enter:

dsn=Oracle Fusion PROD

Important — The Data Source name is case-sensitive. Make sure it matches exactly as it appears in BI Connector.

Tip — Quick way to copy the Data Source name: In the BI Connector application on the Integration Runtime server, click the copy icon next to the Data Source name to copy it without typos.

Step 5 — Set up authentication

Select Basic as the Authentication type from the drop-down. Enter your Username and Password.

Tip — Using JWT authentication? Select Basic as the Authentication type and use your Client secret as the password.

Step 6 — Test the connection

Click Test connection at the bottom right. If all details are correct, the test will complete successfully.

Step 7 — Save the Linked Service

Click Create. The Linked Service is now saved.

Step 8 — Publish the changes

Click Publish all. ADF / Synapse will validate the changes — once validation succeeds, the Publish button will be enabled. Click Publish to complete.

What would you like to do next?

Your next step	Go to
Create and run a pipeline in ADF or Azure Synapse	Steps to create and run an ADF / Synapse Pipeline