Overview
Toolio connects directly to your Redshift data warehouse to query data in real-time — no information is transferred via SFTP. This direct connection allows for a seamless and secure integration.
To set up the Redshift integration, the Toolio team will need the following information:
Database Name
Host
Port
Schema Name
User (see note below)
Password
Table mappings for each specific table being integrated
If Inventory is included in the scope of your integration, please also provide the field name for inventory units.
<Note: Toolio has a 10-character limit for the database user. Please ensure the username you provide is no longer than 10 characters.>
Table Naming Conventions
You will need to set up a table for each core model. Below are the required table names:
Data Model | Table Name |
Product | toolio_products |
Inventory | toolio_inventory |
Sale | toolio_sales |
Purchase Order | toolio_purchase_orders |
Required Table Schema
You can think of each column on your table corresponding to an attribute on Toolio’s data models. Column names should be the same as the slugs. Please see core model documentation for the column types you should use.
Pagination & UpdateAt Field
If possible, make sure to add an updatedAt field to each of the tables that you create. This helps Toolio keep track of the last value that has been synced from your Data Warehouse. To learn more please see how Toolio handles pagination here.