Systems | Development | Analytics | API | Testing

elastic.io

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.

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.

Advanced data mapping techniques - The passthrough feature

Let’s start by naming our flow. Here we are taking the webhook connector as our trigger. In case you skipped our previous short tutorial on webhooks, you need to copy this link and paste it in an empty tab to receive a sample. Now we are going to modify the sample – or correctly speaking, add it manually. These are just sample values to demonstrate how the passthrough feature works, so there is no point in seeking any deep meaning in them.

Creating value from legacy data - The whys and the hows of legacy system integration

While there are many challenges young companies might struggle with, they certainly escaped one that is a blessing and a curse at the same time – the legacy IT systems. Data is indeed one of the companies’ most valued assets, as knowledge (read, ‘data’) empowers better, more informed business decisions. Moreover, chances are your organization already has most of the knowledge it needs. The only caveat, though, is that it might be inaccessible and therefore, pretty useless.