How to setup Segment Integration

This integration will allow you to connect with Segment and start collecting your data. It is a matter of minutes to send your behavioral and customer data to feed your BI, your data warehouse, or your custom analytics stack. With your Segment data into one place like Google BigQuery, PostgreSQL, Amazon Redshift or Microsoft SQL Server, it is much easier to analyze your customer data. You can even get it a bit further up by combining with transactional data or data from your marketing or support and analyzing them using your favorite Analytics, Business Intelligence, or querying tools.

Getting Started – Setup Segment integration at Blendo.

Step 1. Create your Segment pipeline

Login to your Blendo account and make sure that your data warehouse of choice is selected (at the navigation bar). Click on the “Add Pipeline” button to create a new Segment pipeline. You will be presented a list of sources to choose from. This should also be what you see if you have no pipelines created yet. Select the Segment option to start creating your pipeline.

Setting up the Segment pipeline is really simple. You will be presented with your API key, related to this specific pipeline. Make sure you save this key, you will need it in order to connect it to any of your Segment sources. You can also copy it to clipboard by just clicking on it.

Next, select an optional table prefix that will be added in front of the names of any tables created by this pipeline. Blendo will create one table for each of the available Segment types: identify, track, page, screen, alias and group. Leave the field empty if you prefer the table names unchanged.

Finally, select which Segment types you want to be synced. By default, all six types are selected. Click on each one you don’t need, to deselect it. When you are read click on the “Create” button. That’s it! Your pipeline is ready to receive data.

Step 2. Connect your pipeline with your Segment work

Once your pipeline is ready, you can connect it to any of your Segment sources to start receiving data to your data warehouse. Make sure you have the API key, created in the previous step, available. Go to Segment’s catalog and look for “Blendo”. Once you find it, select it and click on “Configure Blendo”.

Next, select any of your existing Segment sources you want to start receiving data from. You can direct data from many Segment source to the same Blendo pipeline, create one pipeline for each, or mix them in any way you see fit.

Once you select the source, you should setup your destination by entering the API key you received from the previous step. Remember, each Blendo pipeline has a unique key, use it accordingly to direct your Segment source data to the data warehouse and tables you want.

You source is now connected! Make sure you enable the destination by clicking on the enable switch. Any data from your Segment source should now be send to your Blendo pipeline.

Blendo collects the data as soon as they arrive and will sync them to your data warehouse according to your pipeline’s schedule. The default behaviour is to do this once per hour, but you can configure it to run as often as once per 15 minutes. You can also sync any collected immediately by selecting your Segment pipeline and clicking “Sync now”.

Questions? Contact us!

in Connecting SaaS Data Sources