Systems | Development | Analytics | API | Testing

Integration

Connecting to 3rd-party APIs - How to work with REST API connector

In this video, I’m working with our REST API connector to connect to our own elastic.io Integration Management API. We offer several ways to authenticate an API depending on its configuration. Here we take basic authentication with username and password. Now with the elastic.io API, the username is actually the email address you registered with. You can navigate to the Profile Information page to copy it from there.

How to work with databases

To start working with a MySQL, PostgreSQL, Oracle or MSSQL database, all you need to do is to select our Database connector. We have already learned from the short video on credentials that there are quite a few fields to fill in when you need to connect to a database for the first time. The data you see me enter here is merely from our test database.

Ritual Improves Retention With a Modern Data Stack

A brittle ETL pipeline, a mix of different code languages and degrading warehouse performance inhibited customer retention analysis. With a modern data stack, Ritual has a 95% reduction in data pipeline issues, a 75% reduction in query times, and a threefold increase in data team velocity. By empowering the business with data, the business has seen a sustained improvement in retention.

Aceable Switches From Alooma to Fivetran, Eliminates ETL Maintenance

After Alooma announced it was sunsetting its services for Redshift customers, Aceable moved to Fivetran for data integration. In one week, the business integrated all of its sources, including MongoDB — a project that was never completed with Alooma. With Fivetran, Aceable eliminates the need for back-end maintenance and adds Jira to its stack to track project progress across the entire org.

How to handle errors on elastic.io

You can see if any of your flows have errors as soon as you log in to your dashboard. It shows you the number of records processed in total – in green – and the number of records with errors – in red. You can also see the same information if you click on the corresponding flow from the dashboard. In my case, you can see I have three records processed and all three returned errors.