Chapter 1: ODBC Guide

CData ODBC Drivers let you connect SaaS, NoSQL, and big-data sources to ODBC-compliant tools (Excel, Power BI, Tableau) and programming languages (C#, Python, R).

Installation:

1. Download the ODBC Driver for your source.
2. Install and configure a DSN in ODBC Administrator.
3. Test the connection.

Using in Tools:

• Excel: Data → Get Data → From ODBC.
• Power BI: Home → Get Data → ODBC.
• Tableau: Connect → To a Server → Other Databases (ODBC).

Code Samples: C# (OdbcConnection), Python (pyodbc), R (DBI with odbc).

Troubleshooting:

• Ensure 64-bit System DSN.
• Verify authentication properties.
• Use WHERE filters for performance.