API Connector

Presight facilitates communication between Presight platform and different software systems or applications by allowing them to exchange data through APIs. Currently, Presight supports direct connection from following databases:

• Google BigQuery

• PostgreSQL

• MSSQL

• MySQL

Steps API Connector

1. Select Use Data Connectors

1. Select a Data Connector

1. Input Connector information, then click Next

1. Then, review your tables before connecting: clicking on each table to review:

Then click Next to continue connecting.

1. After successfully connecting click Back to Data Hub to view your tables and dimensions.

1. Join the Date column of your transactional tables to Date column of Presight's Dimdates table. Then, you can start creating metrics.

Instructions for joining with the Dimdates table, creating metrics and editing dimensions in the documentations below:

Dimensional Dates (Dimdates table)Creating a new Dimension

Our support team is available to support via [e-mail].

If your database type is not in the list, please contact our support team for assistance.