Importing Database content to Hull with the SQL connectorUpdated 29/11/2019


How to install and configure the SQL connector

How to install the SQL connector

Once you have installed the SQL connector, fill-in the database credentials inside the Database connection section of the settings of the connectors: the type, the Hostname, the Port, the Database name, the Username and Password.

Screenshot 2019-11-28 at 16.26.44

How to configure the SQL connector

  1. Choose the type of objects that you want to import among users, accounts and events inside the Import type dropdown.
  2. Choose the sync interval inside the Sync Interval dropdown. It is counted in minutes and you can choose a value among the following ones: 30 min, 60 min, 180 min, 360 min, 720 min, 1440 min, 43800 min. By default, the interval is 180 min. This means that by default the SQL connector will fetch your database every 180 minutes to lookup for new values or new attributes and retrieve them inside Hull.

⚠️ Warning ⚠️: By default, Sync is not enabled so you need to activate the toggle button before step 3 3. Define if you want the SQL data coming from your database to overwrite the corresponding attributes inside Hull. If you enable that feature, you will have the following behavior: if an attribute is changed inside Salesforce for example and the change is ingested in Hull, this new value will soon be overwritten by the value from your database. 4. Sometimes, you don't want to perform queries on all your database because it holds large sets of data. So you might want to query data that has changed within x number of days: this is what we call incremental queries. You can adjust the number of days from which you want to query the changes in the dropdown called Incremental queries - start date (x days ago) . This number is counted in days.

![sql connector confguration](//images.ctfassets.net/nffxf5qv6v6n/3hhmUEJaEDhgTOJ2WSbjc4/3805f4e7273caca2cf5ccf6c43b9ad85/sql_connector_confguration.png

How to ingest data from a SQL database in Hull

Once you have finished configuring your SQL connector, the next step is to write the queries to your database. To do so, go to the Overview page of the SQL connector and click on the Query Editor button. Screenshot 2019-11-28 at 16.54.45

You will be redirected to an editor in which you will be able to write your queries in SQL:

Screenshot 2019-11-28 at 16.56.52

You have the editor where you can write the queries.

The Preview & Save queries paragraph will walk you through how to preview your results before saving them.

The Writing valid queries paragraph will give you tips on how to sure your queries are well ingested inside Hull.

The Incrementing Queries paragraph will give you tips on how to write valid queries.

⚠️ Warning ⚠️: - You will need one connector for each database that you want to import inside Hull - As mentioned in the editor, make sure that your queries expose an external_id or an email as a column otherwise the record will be ignored.

Security

The SQL importer runs on dedicated IP addresses which you can add to your firewall configuration.

The following list contains all IP addresses which are used by the SQL Importer:

104.196.29.23 104.196.1.116 104.196.0.228