Whether you are a new or an existing customer using CData connectivity drivers, here are a couple of helpful tips.
Tip #1: Turn on logging
Logging is a very valuable feature that helps support help you if you run into errors or issues.
There are four types of logging
- Basic Logging – is a filepath that designates the name and location of the log file
- Log Verbosity – there are five levels of verbosity which determines the amount of detail in the log
- Sensitive Data – is found in verbosity levels 3 and higher and you may not want to share this information outside of your organization (see details in the article link below)
- Advanced Logging – is used to refine the exact information recorded in the log file (see details in the article link below)
The logging options are basically the same for all editions (ADO.NET, ODBC, JDBC, SSIS, etc.)
Here is a detailed technical logging article with definitions, and for turning on logging.
Tip #2: Creating linked server connections using SQL Gateway with ODBC Drivers
Many organizations need access to data from outside of SQL Server, for example, desktop applications, flat files, on-prem SharePoint, etc. Linked Servers give you virtual access to data from within your SQL Server interface. Typically, it's used to allow access to a remote SQL Server database from within a local database. With CData, you can access non-SQL Server data in the same way.
Using a CData ODBC driver to connect to any ODBC data sources as a linked server. Reference this article for the detailed steps: https://www.cdata.com/kb/articles/sqlgateway-linked-server.rst