If you do not know a driver name, you can check "Connectors.log". This name must be unique.Īn array of ODBC driver names. The odbcConfig.json file contains the following objects that you can edit to modify your connectors behavior: Name You can edit this file to add functionality such as support for accumulative builds, increase query timeouts, or modify your query patterns. This configuration file, written in JSON syntax, is located in the directory: …\Program Files\Sisense\DataConnectors\DotNetContainer\Connectors\GenericODBC. When you add an ODBC connection to your Sisense configuration, Sisense saves the details of your connection in an odbcConfig.json file. However, if the default settings do not fit your specific use-case, Sisense enables you to customize your ODBC connection to give you the functionality you need. Though there are hundreds of data sources available, the generic ODBC driver can help you connect to almost all of them. Auto Query Structure: Select the proper SQL syntax delimiter.In Query Properties, set the following options: When non-standard SQL must be supplied, the table addition dialog provides a quick preview of the current SQL query and an Edit button that opens the Query Properties dialog. Sisense sets by default the standard SQL for the ODBC/OLE DB tables which covers most of today’s known data providers. Therefore, the SQL syntax being executed against the actual data source may vary from one provider to another. Setting the Table Query (Troubleshooting) #ACTUAL ODBC DRIVER FOR ACCESS UPDATE#You may need to update the executed table query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |