How to read REST API Data in Talend

 Configure ZappySys Data Gateway

Try some query

Install Talend

You can download from here

https://www.talend.com/products/data-integration/data-integration-open-studio/

Configure Microsoft SQL Server JDBC Driver in Talend

Download jdbc driver from here (select tar.gz file). Download from below link and Extract it in a folder somewhere.

 https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

Inside sqljdbc_6.0\enu\jre8\ folder rename sqljdbc42.jar to  mssql-jdbc.jar (name must be this) 

Click on import external jar icon (JAR icon) 

3. Configure new Connection (MS SQL Server Type)