Get Fivetran Platform source information

Get the values of the connection properties that you need to configure from the Informatica administrator.

Note: You don't need to create a connection object for Fivetran Platform. You provide this information when you configure the catalog source.

The following table describes the properties that you need to configure:

Property	Description
Fivetran Input Mode	The connection mode to connect and collect Fivetran Platform metadata. - Repository. Choose this mode to extract Fivetran Platform metadata from connections created in Administrator. - Repository + API. Choose this mode to extract Fivetran Platform metadata from connection created in Administrator and the Base64- encoded API key. Note: For automatic connection assignments, the Repository+API mode is recommended.
Fivetran Repository Connection	Select the connection created in Administrator that points to a source that contains Fivetran Platform metadata. You can select one of the following connections: - Amazon Redshift v2 - Databricks - Google BigQuery - PostgreSQL - Snowflake Data Cloud - SQL Server
Fivetran Base64-encoded API key	Enter the Base64- encoded API key to securely authenticate and authorize Fivetran Platform API access. You can find the key is in the API Key tab in your Fivetran Platform profile.

Before you configure the Fivetran Repository Connection property, you need to create connections in Administrator to extract metadata from the data source.

Configure the following mandatory connection properties for connections in Administrator:

Amazon Redshift v2

Property	Description
JDBC URL	The JDBC URL to connect to the Amazon Redshift cluster. You can get the JDBC URL from your Amazon AWS Redshift cluster configuration page. Enter the JDBC URL in the following format: jdbc:redshift://<cluster_endpoint>:<port_number>/<database_name>, where the endpoint includes the Redshift cluster name and region. For example, jdbc:redshift://infa-rs-cluster.abc.us-west-2.redshift.amazonaws.com:5439/rsdb In the example, - infa-rs-qa-cluster is the name of the Redshift cluster. - us-west-2.redshift.amazonaws.com is the Redshift cluster endpoint, which is the US West (Oregon) region. - 5439 is the port number for the Redshift cluster. - rsdb is the specific database instance in the Redshift cluster to which you want to connect.

Property

Description

JDBC URL

The JDBC URL to connect to the Amazon Redshift cluster.

You can get the JDBC URL from your Amazon AWS Redshift cluster configuration page.

Enter the JDBC URL in the following format:

jdbc:redshift://<cluster_endpoint>:<port_number>/<database_name>, where the endpoint includes the Redshift cluster name and region.

For example, jdbc:redshift://infa-rs-cluster.abc.us-west-2.redshift.amazonaws.com:5439/rsdb

In the example,

- infa-rs-qa-cluster is the name of the Redshift cluster.
- us-west-2.redshift.amazonaws.com is the Redshift cluster endpoint, which is the US West (Oregon) region.
- 5439 is the port number for the Redshift cluster.
- rsdb is the specific database instance in the Redshift cluster to which you want to connect.

Databricks

Property	Description
Database	The name of the schema in Databricks. The name can contain only alphanumeric characters and hyphen (-). This property is optional for SQL warehouse, all-purpose cluster, and job cluster. If you do not specify a value, all databases available in the workspace are listed. The value you specify overrides the schema specified in the SQL Warehouse JDBC URL connection property. By default, all databases available in the workspace are listed.

Property

Description

Database

The name of the schema in Databricks.

The name can contain only alphanumeric characters and hyphen (-).

This property is optional for SQL warehouse, all-purpose cluster, and job cluster.

If you do not specify a value, all databases available in the workspace are listed. The value you specify overrides the schema specified in the SQL Warehouse JDBC URL connection property.

By default, all databases available in the workspace are listed.

Google BigQuery

Property	Description
Project ID	The project_id value from the Google service account key JSON file. If you have created multiple projects with the same service account, enter the ID of the project that contains the dataset that you want to connect to.
Dataset Name for Custom Query	When you define a custom query, specify a Google BigQuery dataset.

PostgreSQL

Property	Description
Database Name	The PostgreSQL database name.
Schema Name	The schema name. If you don't specify the schema name, all the schemas available in the database are listed when you import the source object in the data loader task.

Snowflake Data Cloud

Property	Description
Additional JDBC URL Parameters	The additional JDBC connection parameters. You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format: <param1>=<value>&<param2>=<value>&<param3>=<value>.... For example, you can pass the following database and schema values when you connect to Snowflake: db=mydb&schema=public When you add parameters, ensure that there is no space before and after the equal sign (=).

Property

Description

Additional JDBC URL Parameters

The additional JDBC connection parameters.

You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format:

<param1>=<value>&<param2>=<value>&<param3>=<value>....

For example, you can pass the following database and schema values when you connect to Snowflake:

db=mydb&schema=public

When you add parameters, ensure that there is no space before and after the equal sign (=).

SQL Server


Property	Description
Database Name	Database name for the Microsoft SQL Server target connection. Database name is case-sensitive if the database is case-sensitive. Maximum length is 100 characters. Database names can include alphanumeric and underscore characters.
Schema	The schema name to select tables during object selection in a mapping. When you select objects in a mapping, all schemas you have access to are displayed, and you can select tables from the available schemas.