Manage your FTP data in SQL Server with Talend

FTP (file transfer protocol) is widely employed to transfer files over networks. Most systems support FTP clients and servers, though the protocol's lack of built-in security has engendered variants such as SSH FTP (SFTP) and FTPS (which supports Transport Layer Security (TLS)). Manage FTP data in SQL Server with Talend's suite of data integration tools.

Connecting to FTP

To connect to files over FTP, use the tFTPConnection component. Enter the host, port, username, password, and other optional parameters, such as SFTP support.

More info on establishing an FTP connection

More about integrating FTP data

Talend has detailed documentation on how to ETL your FTP data for a better view of the business.

Connecting to SQL Server

SQL Server is a popular relational database management system created by Microsoft.

Connect to your Microsoft SQL Server database with our native connector and easily carry out the following actions on your data:

  • Write, update, make changes or suppress entries defined on a table and/or on the data contained in a table
  • Prepare a file to be used as parameter in an INSERT query to feed a MS SQL database.
  • Execute a SQL query stated onto a specified Microsoft SQL Server or Azure SQL database.
  • Offer a convenient way to centralize multiple or complex queries in a database and calls them easily.

Get more from your FTP data

Deliver data your organization can trust... Get started today.

Explore Talend's full suite of apps