Contact support

If you checked the Troubleshooting section but are still having difficulties, you will need to create a log and send it to 1010data support.

1. Run the program cdata.jdbc.c1010.jar in the directory C:\Program Files\Cdata\CData JDBC Driver for 1010data 2022\lib (Windows) or the directory Applications/CData/CData JDBC Driver for 1010data 2022/lib (macOS).
   The CData JDBC Driver for 1010data 2022 screen appears.

   

2. Scroll down to the Logging section in the Connection tab of the JDBC driver.
   
3. In the Logfile field, enter the path and name of your log file. The user changing the JDBC driver configuration must have permission to write to this file. For this example, we will name the log file C:\logs\tableaulog.txt.
4. Under Max Log File Count, enter the maximum number of log files to keep. When the limit is hit, a new log is created in the same folder with the date and time appended to the end of the file name. The oldest log will be deleted. By default, the Max Log File Count is "-1", or unlimited.
5. Under Max Log File Size, enter the maximum size the log file can be. When the limit is hit, a new log is created in the same folder with the date and time appended to the end of the file name. (An old log may be deleted, depending on the Max Log File Count value.) By default, the Max Log File Size is 100MB.
6. Under Verbosity, enter the level of verbosity of the log file as follows:
   • A verbosity of 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
   • A verbosity of 2 will log everything included in verbosity 1, cache queries, and additional information about the request, if applicable, such as HTTP headers.
   • A verbosity of 3 will additionally log the body of the request and the response.
   • A verbosity of 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
   • A verbosity of 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

   The default Verbosity is 1. Remember that the higher the verbosity, the slower the execution times.

   Your CData JDBC Driver for 1010data 2022 now looks similar to the following:

   

   Note: The Connection String text box contains information about the connection. This information should be copied and pasted into the New Connection dialog of Tableau.
7. Click Copy to Clipboard to copy the connection string.
8. Click Close.
9. In Tableau, start a connection to 1010data JDBC by 1010data.
   The 1010data by CData dialog appears.

   

10. Under Connection Properties, paste the connection string you created in the CData JDBC Driver for 1010data 2022 screen.
    Delete jdbc:c1010: if it appears as a prefix in the pasted Connection Properties section.
    The Connection Properties field now contains your logging options.

    

    Note: The next time you sign in to 1010data by CData, Tableau will remember the Connection Properties you set.
11. Enter your user credentials and sign in to Tableau.
12. Reproduce the issue you are experiencing.  The driver will produce the file tableaulog.txt in the C:\logs directory.
13. Log into the 1010data Support Portal at https://support.1010data.com.
14. Click Create New Ticket.
    The Submit a ticket screen appears:

    

15. Complete the following fields:

    Requester	This field lists the email address associated with your Insights Platform account. You can change the default email address.
    Subject	Enter the subject of your support request.
    Priority (optional)	Select the priority of your support request.
    Description	Enter a detailed explanation of the question, problem, or request.

16. Click +Attach a file and include your log file.
17. Click Submit.