如何用Windows上的Tableau Desktop连接远程Linux服务器的数据？

Hey there! Let's break down how to connect your remote Linux-hosted data to Tableau Desktop 10.3.7—since you're using SSH to access the server, we first need to make that remote data look like a local resource to Tableau, then hook it up via your SQLite ODBC driver. Here's the step-by-step:

Tableau can only access files it can "see" locally, so we'll map the remote Linux folder to a Windows drive letter using SSH. Two easy tools for this:

• SSHFS-Win: Download and install it, then open the SSHFS tool. Enter your Linux server's IP, SSH username/password, specify the remote folder path you need, and assign a local drive letter (like Z:).
• WinSCP: If you already use WinSCP, you can mount the remote folder directly via its "Mount as drive" feature (look for the option in the toolbar after connecting to the server).
• Test the mount: Open Windows File Explorer and check if you can browse the mapped drive and access your SQLite file—make sure you can read it without issues.

Now that the remote data is locally accessible, let's configure Tableau to connect to it:

1. Open Tableau Desktop, and in the left-hand "Connect" pane, select Other Databases (ODBC).
2. If you haven't created a SQLite ODBC DSN yet, do this first:
   • Open the Windows ODBC Data Source Manager (critical note: use the 32-bit version if your Tableau 10.3.7 is 32-bit, or 64-bit if it's 64-bit—mismatches will cause connection failures).
   • Go to the "User DSN" or "System DSN" tab, click "Add", and select your installed SQLite ODBC driver.
   • Name your DSN (e.g., "RemoteLinuxSQLite"), then browse to the SQLite file on your mapped drive (like Z:/path/to/your-data.sqlite).
   • Click "Test Connection" to confirm it works, then save the DSN.
3. Back in Tableau's ODBC connection window, select the DSN you just created, then click "Connect".

• Once connected, Tableau will load the tables from your SQLite database. Drag a table to the canvas to check if the data pulls correctly.
• If you run into permission errors: Double-check that your SSH user has read access to the remote folder and SQLite file on the Linux server. Also, ensure the mapped drive has read permissions in Windows.
• Quick heads-up: Tableau 10.3.7 is an older version, so it might not support the latest SQLite features. If you hit compatibility snags, try copying the SQLite file to your local machine temporarily (though mounting keeps the data in sync with the remote server).

内容的提问来源于stack exchange，提问作者Joohun Lee