On-Premises Oracle Linked Service

  • Article

 

Important

This topic provides the JSON format that is supported by the older versions of Azure PowerShell. If you are using the July 2015 Release version of Azure PowerShell or later, see On-Premises Oracle Linked Service for the latest JSON format. You can convert the JSON from old format to new format by using the tool: JSON Upgrade Tool

You create an On-premises Oracle linked service to link an on-premises Oracle database to an Azure data factory. This topic describes syntax for defining an on-premises Oracle linked service in a JSON file. When you use the Data Factory Editor in Azure Portal, the editor provides you a JSON template for defining a linked service that you can modify and deploy to create a linked service. To use the T:Microsoft.Azure.Commands.DataFactories.New-AzureDataFactoryLinkedService cmdlet to create a linked service, you will need to create a JSON file and use it with the cmdlet.

For the Azure Data Factory service to be able to connect to your on-premises Oracle database, you must install the following:

  • Data Management Gateway on the on-premises computer either on the same machine that hosts the database or on a separate machine to avoid competing for resources with the database. Data Management Gateway is a software that connects on-premises data sources to cloud services in a secure and managed way.See Enable your pipelines to work with on-premises data for detail about Data Management Gateway.

  • Oracle Data Access Components (ODAC) for Windows. It must be installed on the host machine where the gateway is installed.

When creating a dataset based on this linked service, you set the location type in the dataset JSON to: On-premises Oracle Database. When creating a pipeline, you set the source type to On-premises Oracle Database if you are using an on-premises Oracle database as a source in a copy operation. Using an Oracle database as a sink in a copy operation is not supported yet.

Properties

Property

Description

type

The type property should be set to: OnPremisesOracleLinkedService.

connectionString

Specify connection string information needed to connect to the on-premises Oracle database using basic authentication. The connection string must be in the Oracle Connect Descriptor format.

gatewayName

Name of the gateway that the Data Factory service should use to connect to the on-premises Oracle database.

Example

JSON for using basic authentication:

{
    "name": "LinkedServiceOracle",
    "properties": {
        "type": "OnPremisesOracleLinkedService",
        "ConnectionString": "data source=<data source>;User Id=<User Id>;Password=<Password>;",
        "gatewayName": "<gateway name>"
    }
}