Set Up Matillion OCF Connector

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Install the Matillion connector and configure a new Matillion data source to start using the connector.

Install the Connector

Alation Cloud Service

Note

On Alation Cloud Service instances, Alation Connector Manager is available by default.

Depending on your network configuration, you may need to use Alation Agent to connect to databases.

Connection via Alation Agent

  1. Ensure that Alation Agent is enabled on your Alation instance. If necessary, create a Support ticket with Alation for an Alation representative to enable the Alation Agent feature on your instance and to receive the Alation Agent installer.

  2. Install the Alation Agent.

  3. Install the connector on the Connectors Dashboard page using the steps in Manage Connectors.

Connection Without Agent

To install an OCF connector:

  1. Ensure that the OCF connector Zip file is available on your local machine.

  2. Install the connector on the Connectors Dashboard page using the steps in Manage Connectors.

Configure Matillion ELT Source

In Alation, add a new data source:

  1. Log in to Alation as a Server Admin.

  2. From the Catalog menu on the left-side navigation, select ELT Sources.

    Note

    This step is applicable for New User Experience only.

  3. Click Add ELT Sources.

  4. Enter details for title and description.

  5. Select the Matillion connector from the dropdown What Connection will this ELT Source have? and click on Add Source.

    Note

    Agent-based connectors will have the Agent name appended to the connector name.