Database Ingestion

Simon can connect to most standard databases. The general steps to setting up your connection are:

  1. Set up a Simon Data account with your database vendor.
  2. Authorize your database type in Simon with your credentials. (One set of credentials per integration vendor).
  3. Test and confirm security details.

📘

SQL dialects

We provide flexible support across most popular SQL dialects:

  • MySQL
  • PostgreSQL (including Redshift)
  • Microsoft SQL Server
  • BigQuery
  • Snowflake

Before you begin

  • Collect the following fields from your database so you're ready to authorize:

    • Host name
    • Port
    • Schema
    • User
    • Password
  • Confirm the tables, schemas, and database names that Simon needs access to. You'll need these when you set up our account with your vendor.

Set up a Simon Data account

More details on specific vendors are included on subsequent pages. Contact your account manager for support with Cloud-Base Microsoft SQL Server, MySQL, and PostGREs.

👍

Dedicated Simon Data account

Set up an account with your database vendor that's dedicated to Simon Data and provides read-only privileges.

Be sure to allow Simon connections from the following IP block:

  • 54.174.71.70
  • 54.165.60.44
  • 54.165.74.55
  • 52.7.12.28
  • 35.173.87.106
  • 54.152.155.89

Authorize in Simon

  1. After creating a Simon Data account on your database side, log on to Simon as an Admin.
  2. Expand Settings, then click Integrations.
  3. Select your database type then click Add.
  4. Follow the directions for each individual connection.

Test

  1. Click Test Connection. If your database connected successfully, this is indicated. If not, some suggestions for troubleshooting are displayed:

SSH tunneling

Simon can connect to your database over SSH. Please contact your account manager to configure this.

Change your database

If you need to edit your credentials or change your database ingestion methods, contact your account manager.


Did this page help you?