In the process of configuring tasks within the Conecta HUB, one of the crucial steps is the selection of the source and destination data source. This process is essential to determine where the data will be extracted from and where it will be deposited after the necessary transformations.

Step-by-Step Visual Assistant

Conecta HUB facilitates this process by means of a visual wizard that guides the user step by step. This wizard is intuitive and adapts its interface according to the user's decisions. When selecting a specific technology or connection type, the wizard automatically adjusts the fields and options to be filled in.

Connection Types

The wizard allows you to choose between different types of connections, such as:

• API: to connect to web services or applications that offer programming interfaces.
• Database: to extract or deposit data directly from or to database management systems.
• FTP: to transfer files and data via the File Transfer Protocol.

Authentication

Security is paramount, and for this reason, Conecta HUB offers multiple authentication methods, adapting to the needs and characteristics of each data source:

• Windows NativeUses the credentials of the Windows operating system to authenticate.
• SQLAuthentication based on SQL database specific credentials.
• Authentication for APIsDepending on the service or application you want to connect to, different authentication methods can be used for APIs, such as:
  • Basic AuthAuthentication by username and password.
  • OAuthAn authorisation protocol that allows applications to gain limited access to user accounts.
  • Bearer TokenUses access tokens for authentication.
  • API Key: A code passed in HTTP calls to identify the application call.

Query Type Transformations

Beyond simply transferring data between an origin and destination source, Conecta HUB offers query-like transformations that allow data to be triangulated between three or more technologies or data sources. This means that, instead of simply moving data from point A to point B, it is possible to take data from point A, combine or compare it with data from point C, and then deposit the result at point B. This ability to triangulate data opens up a world of possibilities in terms of data enrichment, validation and complex analysis.