Introduction
Accessing JSON files stored on an SFTP server is a common requirement in modern data workflows. The ZS SFTP JSON Driver, part of the ZappySys ODBC PowerPack, simplifies this process, allowing seamless integration of SFTP JSON data into your applications. This article provides a step-by-step guide to connecting to a JSON file on an SFTP server using the ZS SFTP JSON Driver.
Prerequisites
- Download the ODBC driver from here (click Download button).
- Install ODBC PowerPack
Step 1: Create an SFTP JSON Driver:
-
Open the ODBC Data Source Administrator.
-
Click on System DSN or User DSN tab.
-
Click on Add to create a new data source.
-
Create a User Data Source (User DSN) based on ZappySys SFTP JSON Driver.
Step 2: Configure the SFTP JSON Driver:
-
Enter your SFTP credentials: Host, Port, Username, and Password.
Note: For advanced scenarios, configure additional options in the Proxy, SFTP/FTP Settings, and SSL/TLS tabs as needed.
-
Select your desired single file by clicking the […] path button. You can also read multiple files stored in FTP/SFTP Storage using a wildcard pattern, e.g., dbo.tblNames*.json.
-
You can also read zip and gzip compressed files without extracting them using the FTP/SFTP JSON Source File Task.
-
Go to the preview tab, select Table from Tables Dropdown, select [value], and click Preview.
Video tutorial
Conclusion
The ZS SFTP JSON Driver streamlines connecting to JSON files on SFTP servers, eliminating the need for complex coding. Following the steps outlined in this guide, you can efficiently retrieve and integrate JSON data into your workflows. For enhanced data processing capabilities, explore the full potential of the ZappySys ODBC PowerPack.