Set Import Query to a SQL query that will extract the data you want from FTP, i.e.:.Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard. Built-in Connection String Designerįor assistance in constructing the JDBC URL, use the connection string designer built into the FTP JDBC Driver. See the Data Model chapter of the FTP data provider documentation for more information. Stored Procedures are available to download files, upload files, and send protocol commands. FileRetrievalDepth: Set this to retrieve and list files recursively from the root table.TableDepth: Set this to control the depth of folders to list as views.RemotePath: Set this to the current working directory.Set the following connection properties to control the relational view of the file system:
The data provider lists the tables based on the available folders in your FTP server. Set SSLMode and SSLServerCert to secure connections with SSL. See the Getting Started section of the data provider help documentation for more information on authenticating via SSH. Set SSHAuthMode to use SSH authentication. Set User and Password to perform Basic authentication. To connect to FTP or SFTP servers, specify at least RemoteHost and FileProtocol. Set Connection String to the JDBC URL for FTP.Set Reference Name to a value for any future references (i.e.: cdata-ftp).For more information on obtaining this license (or a trial), contact our sales team. NOTE: To use the JDBC Driver in Google Data Fusion, you will need a license (full or trial) and a Runtime Key (RTK). Click "Properties" on the Database source to edit the properties.From the "Source" options, click "Database" to add a source for the JDBC Driver.Navigate to the Pipeline Studio to create a new Pipeline.With the JDBC Driver uploaded, you are ready to work with live FTP data in Google Data Fusion Pipelines. Class name: Set the JDBC class name: ()Ĭonnect to FTP Data in Google Data Fusion.Name: Create a name for the driver () and make note of the name.On the "Upload driver" tab, drag or browse to the renamed JAR file.Click the to add an entity and upload a driver.Due to the naming restrictions for JDBC drivers in Google Data Fusion, create a copy or rename the JAR file to match the following format driver-version.jar. Upload the CData JDBC Driver for FTP to your Google Data Fusion instance to work with live FTP data. Upload the CData JDBC Driver for FTP to Google Data Fusion While the CData JDBC Driver enables piping FTP data to any data source natively supported in Google Data Fusion, this article walks through piping data from FTP to Google BigQuery, Uploading the CData JDBC Driver for FTP enables users to access live FTP data from within their Google Data Fusion pipelines. Google Data Fusion allows users to perform self-service data integration to consolidate disparate data.