Stitch Data is a cloud-first, open-source ETL platform that connects multiple data sources and puts all the data in a single database destination.
There are 2 ways to use Stitch with Grow:
1. Stitch to your Company Postgres Database to Grow
2. Stitch to Grow provided Postgres Database to Grow
If you want to use Stitch, please contact your Grow BI Consultant who can help guide you through the process.
Setting Up Stitch
Stitch allows all new users to have a free trial account for 14 days. This is a trial of the standard plan, which grants access to all standard (paid) and free integrations for 14 days, after which you have the choice to opt into the Standard plan and use the standard integrations or use the free plan.
The Free plan allows up to 5 integrations (or data sources) to be saved to any one destination at a time. You can save a total of 5 million total not-unique rows of data every billing period in order to qualify for the free plan. If you opt for the Standard plan, you will start on their $100/mo plan for 10 million rows + access to all the free and standard integrations. If you need more rows, you will be able to upgrade. So if the data sources you want to use are available in the Free plan, you can still use that with Grow.
Step 1: Set up an account
To set up a new account, go to stitchdata.com, enter your email address in the field, and click Sign up for free.
You will then be brought to a page where you can enter in your name and company info and set a password for your account, then click Save account details.
Step 2: Setting up the Integration/Authentication
Next you will select the data sources you want to connect to Stitch. You simply need to search for the desired data source and click on it to start the authentication process.
When you select a data source, you will give Stitch the name of the integration in the first input box. This is the schema that will be named in the destination DB. For example, if you named a Shopify integration Grow, the orders table in the DB would be called grow.orders. See below:
From here, the authentication process is very straight-forward and similar to connecting a data source in Grow. Make sure to follow each step carefully. You can also consult the documentation for each data source if you are not sure of the requirements.
Here is a demonstration of the process of connecting Hubspot (which is available on the Standard plan):
After you have connected your data source to Stitch, you will select which tables and fields you want to replicate in a database to use in Grow. Keep in mind the row limit available in the Stitch account plan you will be using.
Step 3: Select a Destination
When you finish with the authentication portion, you will be prompted to select a destination for your data and enter in database credentials for that destination.
Grow currently only supports a PostgreSQL database for Stitch users.
This is where you connect your company Postgres Database. If you don't have a Postgres Database, Grow has the ability to provide you with one.
Contact your Grow BI Consultant at this point and they will give you the database information that Grow provisioned for you. Once this is done, you will be able to test the connection.
Once it verifies that the connection has been established both to the database and the data source, you are good to go. Just wait until the first full replication has finished, and all the data will appear in your Grow-provided custom PostgreSQL warehouse.
Once your replication has begun in StitchData, simply go into Grow and use the PostgreSQL connector to connect your database using the credentials provided by your Grow BI Consultant. When it is connected you may query the data in any way you wish! You can also reach out to support if you need help navigating your database.