Connecting your data

How to integrate external data for automated updates

Connecting data to Querri from external sources can be as simple as a few clicks. Start by:

1. Go to your "Library" page and click "Connect Your Data"

2. Select the integration you want to configure

3. If you're the first person in your organization to configure the integration, you'll need to click "Add Instance"

4. Enter or click through credentials

For example, Microsoft SQL Server needs a host, port, database, username and password. Google Drive and Dropbox use OAuth to allow connection with just a few clicks, then provide configuration options on the next page. In any case, work through the details of the form and click "Finish".

5. Configure access. 

In some cases, you may need to configure additional access. For example if you have network security protecting your database, you'll need to allow connection from our integration servers with IP Addresses:

  • 3.132.205.204
  • 3.139.185.169

6. Refresh the Library page

You may need to refresh your browser to see your new data.

7. Create a project!

You can now work with this new data just like you would an uploaded piece of data. You can either start a new project directly from the Library page, or add data to an existing project: