Welcome to the Alteryx Knowledge Base

• Alteryx Designer
  • Version: All
• *Simba ODBC drivers
  • Simba Amazon RedShift
  • Simba Athena
  • Simba MongoDB
  • Simba Oracle
  • Simba Postgres
  • Simba Salesforce
  • Simba Spark
  • Simba Teradata

*This is not an exhaustive list and may not apply to all drivers. For example, Simba Snowflake.

For DSN connection

1. In Windows, open ODBC Data Source Administrator (64-bit).
2. Look for the data source that you are using in the User DSN tab or the System DSN tab, depending on where you have created it.
3. Double-click the data source.
4.  Click the Logging Options... button. The location will depend on the driver, but it is usually at the bottom of the setup window.
5. In the Logging Options window, select LOG_TRACE for the Log Level setting.
6. Set the Log Path setting to the location where log files should be created.
7. Click the OK button to exit the Logging Options window, and click the OK button in the DSN setup.

Example:

NOTE: Logging enabled here applies to all connections (to the data source) using this driver.

For DSN-less connection

If you are using DNS-less in Data Connection Manager (DCM), you will not be able to include the log parameters (as suggested in option 1). Therefore, you can only use option 2.

Option 1: Add parameters in the Connect String

Add the following options to the connect string:

• Loglevel with a value of 6 (for LOG_TRACE).
• LogPath with the location to create the log files. 

Example:

Driver=Simba MongoDB ODBC Driver;Server=<DB_SERVER>;Port=<PORT>;LogLevel=6;LogPath=c:\temp;Database=<DATABASE>;authMechanism=<AUTH_TYPE>;AuthSource=<DATABASE>;UID=<USER>;PWD=<PWD>

NOTE: If you have enabled logging in the driver via one of the ODBC DSNs (of the same driver) before, you do not have to include the log parameters in the connect string. The log files will be generated.

Option 2: Enable Logging in the Driver

1. In Windows, open ODBC Data Source Administrator (64-bit).
2. Go to the System DSN tab and look for the DSN that the Simba driver created by default.

For example, if you have installed the Simba Spark driver, there will be a DSN named "Simba Spark". If you have removed the default DSN, add one or use an existing DSN for the same driver and continue with the rest of the steps.

3. Double-click the data source.
4.  Click the Logging Options... button. 
5. In the Logging Options window, select LOG_TRACE for the Log Level setting.
6. Set the Log Path setting to the location where log files should be created.
7. Click the OK button to exit the Logging Options window, and click the OK button in the DSN setup.

You should see files like the one in the screenshot below once the logging has been enabled. Please provide them to Alteryx Support when requested.

Example of the log files for Simba MongoDB ODBC Driver:

NOTE:

• The name of the files depends on the driver.
• You may only see one log file with suffix "_connection_" for logs created using log parameters in a DSN-less connection.