How to establish connection with snowflake Database in Spotfire Statistica?

How to establish connection with snowflake Database in Spotfire Statistica?

book

Article ID: KB0137459

calendar_today

Updated On:

Products Versions
Spotfire Data Science - Statistica 14.x

Description

All ODBC and OLE connections are supported.  

Environment

OS:  Windows

Resolution

  1. One must have a Snowflake database established or a trial of Snowflake is acceptable: 

    Create an account on the Snowflake Database by using the URL ( https://signup.snowflake.com/ )

  2. After creating an account on the Snowflake Database the setup will look as follows:

    image.png

  3. In Snowflake we can create a Database (for example: Statistica). Use query CREATE DATABASE database name;

  4. Likewise you can create tables and enter data in those tables.


    How to create a database connection in Statistica Enterprise :
  5. First, create a DSN for the Snowflake database connection.

    User: Put the Username that you used to create the Snowflake account.
    Password: The password that you used to create the Snowflake account.
    Server: Put the Snowflake server URL ( we can get this from Snowflake Account Details>>Account/Server URL)
    Database: Put the database name that you created on Snowflake.
    The rest of the information is optional as per your requirement.
    If everything is put properly, test the connection, and it should be successful.

    image.png

  6.  Create a Database Connection on Statistica Enterprise Manager.

    Right-click on Database connection>>new OLEDB Connection>> Select provider as Microsoft OLE DB Provider for ODBC Drivers. Enter all the details and then test the connection.

    image.png

Issue/Introduction

This article will help to understand the process of creating database connection on Snowflake database and then using the snowflake credentials to set the database connection on Statistica.

The first step is to download the ODBC driver (snowflake64_odbc-3.5.0.msi) for Snowflake from https://www.snowflake.com/en/developers/downloads/odbc/.