When trying to establish a connection to the SAP ERP with our Tableau Connector, you might run into an error indicating that the SAP JCo library is missing. To fix this, make sure the appropriate JAR file is available and properly set up the required native libraries. 

To resolve the "SAP JCo library not found" error, follow these steps:  

Retrieve Native Libraries from SAP:  To link up with SAP ERP through our driver, you'll need to acquire the native libraries from SAP. You can get these directly from SAP's official source. 
https://support.sap.com/en/product/connectors/jco.html 

Copy the JAR and DLL Files: After acquiring the necessary JAR and DLL files from SAP, position them in the default directory on your system as follows: 

C:\Program Files\CData\CData Tableau Connector for SAP ERP 2024\lib  
C:\Program Files\Tableau\Drivers\CData Tableau Connector for SAP ERP 

Opening the JAR File: Keep in mind that the method for accessing the JAR file in SAP ERP differs slightly. Simply double-clicking the cdata.jdbc.saperp.jar file and inputting your credentials could lead to a "library not found" error. 

To properly open the JAR file using Command Prompt (CMD), follow these steps: 
• Launch a Command Prompt (CMD). 
• Go to the default directory where the JAR files are stored. 

cd C:\Program Files\CData\CData Tableau Connector for SAP ERP 2024\lib 

Enter the following command:  

java -cp "sapjco3.jar;cdata.tableau.saperp.jar" cdata.jdbc.saperp.SAPERPDriverMain 

After running the command, the JAR file will open, prompting you to input your SAP ERP credentials. If the credentials are valid, you should see a confirmation of a successful test connection. 

When you attempt to connect on Tableau, you should no longer encounter the "JCo Library Not Found" error, provided the correct JAR file is in place. 

If you run into any other problems, feel free to contact CData Support for help.