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.
Import type
dropdown. 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
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.
You will be redirected to an editor in which you will be able to write your queries in SQL:
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.
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