Snowflake Connector Guide

Snowflake Connector Guide

Create an ODBC Connection

Create an ODBC Connection

You must create an ODBC connection to connect to Snowflake after you configure the ODBC connection.
Perform the following steps to create a Snowflake ODBC connection on the Connections page:
  1. In Administrator, click Connections.
    The Connections page appears.
  2. Click New Connection.
    The New Connection page appears. The following image shows the New Connection page:
  3. Configure the following connection details in the Connection Details section:
    Property Description
    Connection Name Name of the ODBC connection. For example, sf_odbc.
    Description Description of the connection.
    Type Type of the connection.
    Select the type of the connection as ODBC.
  4. Configure the following connection details in the ODBC Connection Properties section:
    Property Description
    Runtime Environment Runtime environment that contains the Secure Agent you can use to access the system.
    User Name Username to log in to the Snowflake database.
    Password Password to log in to the Snowflake database.
    Data Source Name Enter the name of the ODBC data source name that you created for the Snowflake database.
    Schema Name of the Snowflake schema.
    Code Page The code page of the database server or flat file defined in the connection.
    ODBC Subtype Enter the value of the ODBC Subtype field as Snowflake.
    Driver Manager for Linux The driver that the Snowflake ODBC driver manager sends database calls to.
The Snowflake ODBC connection is created successfully.


Updated November 07, 2019


Explore Informatica Network