Talend can be used to send data to
Vizardfrom different data sources such as Enterprise Systems (like SAP, Oracle etc), Relational Databases (like MySQL, MSSQL, PostgreSQL etc) and Cloud Software (like Salesforce etc).
This help section describes how to use Talend to integrate data from a
Database into Vizard.
The following are different steps involved in sending data to
Vizard from a
- Extract Data
- Transform Data
- Load Data
Create a Database Connection
In this section, we will see how to Extract data from a
MySQL database using Talend.
Database connections can either be setup under
Built-intab of a component. It is recommended to setup a connection in
Metadata, as connections under
Metadatacan be used across multiple components.
Convert data to JSON format
Vizard expects request body to be in JSON format, shown to the right, with data rows in
In the following Tutorial, we will see how to configure the JSON structure in
Talend , before it can be sent to Vizard's API.
The Intermediate variable
vizardCounterwill help you send data in batches. here's the Expression to configure batch size
Send Data to Vizard
Sending data to Vizard requires making an HTTP request to Vizard's REST API endpoint.
In the following tutorial, we will see how to send data to Vizard.
An API token is required to authenticate our requests to Vizard API. Only Team Admins can create an API Token n Vizard. Learn more about How to Create an API Token