How to setup Gitlab Integration

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

Our Gitlab integration uses our Incoming Webhooks to connect and sync data. For more information on Incoming Webhooks, check out the Setting up Incoming Webhooks guide in our knowledge base.
Our Gitlab integration is currently in open beta.

What can I see with Webhooks on Gitlab?

You can use a webhook as a trigger of events. When you want a trigger or update sent from Gitlab after an issue event occurs, use a webhook. For example:

  • You can trigger a webhook when you push to a repository.
  • You can create a webhook when a new issue is created or an existing issue was updated/closed/reopened.

You can see a list of events you can enable in the picture bellow.

Gitlab Webhook integration

Getting Started – Setup Gitlab integration at Blendo.

1. Login to your Gitlab dashboard from a browser tab

2. Go to your project. Click on the gear icon in the top right side of your dashboard and click on Integrations.

gitlab integration

3. You will see a box URL and list of checkboxes with the events that can be triggered e.g. Push events, Comments, Issues events, Merge Request events, Build events and more. Check any of these you want to push to your data warehouse.

gitlab integration

Setup Gitlab and Blendo integration

In Blendo, for every separate webhook that you create, another different table will be created in your output database. For example:

a) You may create a webhook in Blendo that you will send all the Issue events.

b) Create another webhook in Blendo that you will send all the Push events.

6. Open Blendo in a new browser tab.

7. Add a webhook (in our example we will use this to receive only the Push events)

Setup Gitlab Webhook integration8. In the new page, you will setup the Webhook. Add a table prefix if you like. It will help better separate your tables. Click Save.

Setup JIRA Webhook integration

9. Then you will return back to the home dashboard. Click on your new Webhook data source.

Setup JIRA Webhook integration

10. Let’s change the name to reflect its use. Hover over the name Webhook and click on it and rename it if you like.

Setup JIRA Webhook integration10. In the same page you may see the Webhook address we are going to use to send our Gitlab data.

Setup JIRA Webhook integration

11. Copy the URL.

12. Go to your browser tab with Gitlab.

13. In URL boxpaste the URL we copied from step #11 above. Click Add Webhook.gitlab integration

Next Steps:

Blendo will now start receiving data from your Gitlab data source and it will copy everything into your destination data warehouse.

Questions? Contact us!

in Connecting SaaS Data Sources