macOS DSN Configuration
This section shows how to set up ODBC connectivity and configure DSNs on macOS.
Minimum macOS Version
The CData ODBC Driver for FTP driver requires macOS Sierra (10.12) or above.
Licensing the Driver
In a terminal, run the following commands to license the driver. To activate a trial, omit the <key> input.
cd "/Applications/CData ODBC Driver for FTP/bin"
sudo ./install-license.sh <key>
You'll be prompted for a name and password. These refer to your name and your machine's password.
The CData ODBC Driver for FTP allows connecting to FTP servers.
Connecting to an FTP Server
FTP supports both plaintext and SSL/TLS connections. To connect to an FTP server specify the RemoteHost, User, and Password. Set SSLMode and SSLServerCert to secure connections with TLS/SSL. See SSL Configuration for more information on configuring connectivity over TLS/SSL.
Connecting to Data
Set the following connection properties to control the relational view of the file system:
- RemotePath: Set this to the current working directory.
- TableDepth: Set this to control the depth of subfolders to report as views.
- FileRetrievalDepth: Set this to retrieve files recursively and list them in the Root table.
Uninstalling the Driver
The easiest way to uninstall the driver is to open a terminal and run the included uninstall.sh script, located in the installation directory. For example:
cd "/Applications/CData ODBC Driver for FTP" sudo ./uninstall.sh
Note: The script needs to be run from the installation directory.