Data Connectivity

SaaS model

The number of data registration systems has grown enormously. Moreover, almost all systems are nowadays offered in a SaaS model. Where we previously had to connect our dashboards to a local database with an ODBC connection, we now make extensive use of APIs to unlock data from the various SaaS solutions.

An API is not easy to call and requires a bit of coding to retrieve the correct data selections in the correct way (authorization). We call the coding for communicating with APIs and retrieving data from SaaS solutions Data Connectivity.

Connectors

We have various solutions that are simple, safe and quick to use. Connectors are lightweight web services that allow you to retrieve data from SaaS environments (Salesforce, Exact Online, etc.) online using APIs. The connectors are fully integrated with data analytics tools and work just like an ODBC connection to a database.

Solutions

In addition to direct links from a visual analytics tool (Qlik or Power BI) or a data management solution (for example Timextender) we also have solutions that go further and provide data pipeline management. In addition to connectivity, we also look at interim storage in a database/data warehouse or data lake. This ensures that data is transferred from the source to the analytics environment in a timely, secure, fast (incremental or change data capture) and complete manner.

For data pipeline management we recommend:

Qlik Replicate

Victa Data Collector

Power BI Connectors

Data analysis tool

The Power BI Connectors are web services that allow you to easily retrieve data from social media and web-based data sources. The desired data can be easily retrieved by means of specific web APIs. All you need to do is select what kind of data and how much data you want to retrieve. The Power BI Web Connectors then automatically generate the correct load script for Power BI.

Data Connectivity

Would you like more information about the possibilities of Data Connectivity? Download the free Data Connectivity whitepaper now and get started right away.

Data Connectivity
You can view the free Data Connectivity PDF file, using the Adobe Acrobat Reader DC program. This program is free to download and suitable for Windows and Mac. This is the only PDF viewer that allows you to open and edit all types of PDF content, including forms and multimedia.

Download Data Connectivity