Syncari Data Store is a feature that makes your Syncari data available via a standard PostgreSQL database connection. You should be able to connect any database tool to your data store once it is provisioned.
If you have trouble connecting to your data store it may be necessary for us to whitelist the IP you will be connecting from. Please open a ticket here in the Help Center to make this request.
This article will cover specifically how to connect Google Data Studio to your Data Store
Find your Syncari Data Store Connection Information
1. Click the Settings option from the bottom-left corner of Syncari.
2. Go to Data Store.
3. Select Configure, now copy the values from these boxes for setting up Google Data Studio.
4. Click this eye icon to reveal your password when needed.
Set up a new Data Source in Google Data Studio
Once you have your connection information available on one tab you can open another browser tab and navigate to https://datastudio.google.com/. The following screens are subject to change at Google's discretion. If you see a discrepancy please notify us so we can update our article.
1. From Data Studio, click the Create button.
2. Then select Data source.
3. Now search for the PostgreSQL connector.
4. Then click PostgreSQL.
5. Now provide all of the connection details from the Syncari tab you opened in the previous section. Also, provide the name for your Datasource at the top-right corner.
6. Click Authenticate.
7. To select data from your Syncari Data Store you will use the Custom Query option.
8. Enter your query (be sure to prefix your table references with the database name like dbname.tablename).
9. Click Connect.
This will take your configured data source. At this point your expertise of Google Data Studio takes over.
10. Most of the time we see users create a report or explore as a next step.