Skip to main content

CData Drivers

Share product questions and get support for CData Drivers & Connectors

  • 156 Topics
  • 259 Replies
156 Topics
daniellemorriss
daniellemorrissApprentice
asked in CData Drivers
Is my laptop powerful enough to run multiple CData ODBC drivers for concurrent API connections?

Hi everyone,I’m currently working on a project that involves connecting to several cloud APIs (like Salesforce, HubSpot, and Google Analytics) using CData ODBC drivers. I’m running everything locally from my Windows 11 laptop (16GB RAM, Intel i5, SSD).I’m planning to set up multiple concurrent ODBC connections through a BI tool and possibly through some custom scripts. Before I go all in, I wanted to ask: Is this laptop spec sufficient for running several CData drivers simultaneously without performance issues? Are there any known CPU or memory bottlenecks when using multiple drivers at once? Would virtualization (like using Docker or WSL) complicate or help with performance? Any tips for optimizing driver performance on a laptop setup — like cache settings or connection pooling? I’m mainly doing this for development and testing, but I’d like to keep it as close to a production simulation as possible.Would love to hear your thoughts or setups!Thanks in advance. 🙏

151
Jerod
N
Naomi YEmployee
asked in CData Drivers
"The table has no visible columns and cannot be queried." error when refreshing semantic model in Power BI Online

I'm unable to refresh my Power BI Semantic Model on Power BI Online and am running into the error below. I’m using the QuickBooks Power BI Connector. Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The table has no visible columns and cannot be queried."}}.... The semantic model is tied to my Profit & Loss Standard Report, which was generated using the CreateReportSchema Stored Procedure, and works fine on Power BI Desktop. How can I resolve this issue?

131
N
M
MohsinEmployee
posted in CData Drivers
Choosing the Right BigQuery Insert Operation for Your Use Case with CData

When inserting data into BigQuery, choosing the right method is critical for performance, cost, and data freshness. Our latest article dives deep into the three main insert options supported by the CData BigQuery Driver:🔹 Streaming Inserts: Send real-time data to BigQuery with near-instant availability — perfect for live dashboards and IoT use cases. Higher costs and temporary update restrictions apply. 🔹 DML (Data Manipulation Language): Insert, update, or delete records with full transactional integrity using SQL. Best for small, critical updates where data consistency matters. 🔹 Bulk Loading: Move large datasets cost-efficiently using batch loads. Ideal for ETL jobs and historical imports where immediate query access isn't critical.We compare the three methods across: Performance Update timing Cost Best use cases Plus, learn how to control the insert strategy directly from your connection string with the CData BigQuery JDBC Driver.🔗 Read the full article here:👉 Comparing

90
M
D
DibyenduEmployee
posted in CData Drivers
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers

Hey CData Community!Ready to supercharge your FileMaker apps? Say hello to a world “beyond the file” with CData ODBC Drivers! Whether you're taming spreadsheets, poking into cloud platforms, or cracking open databases, we’ve got 270+ data sources just waiting to shake hands with your FileMaker setup.In our latest post, we break down 3 easy-but-effective methods to plug external data right into your custom apps — no wizardry required. So go on, give your FileMaker the data buffet it deserves!Refer to the given link to read the post: https://www.cdata.com/kb/articles/odbc-filemaker-methods.rst

50
D
G
GritKitApprentice
asked in CData Drivers
Using OAuth 2.0 to access Gmail Inbox from SSIS package

Google now requires OAuth 2.0 to access Gmail, and my SSIS package had stopped working.I did quite extensive research, but still can’t figure out how to make my CData Gmail Connection Manager to access my company’s Gmail Inbox. Can someone please provide a guidance (ideally step-by-step) on how to make my SSIS package query the Gmail Inbox using either CData SSIS Components for Gmail or CData SSIS Components for Email.

412
G
M
MohsinEmployee
posted in CData Drivers
Read SSL Certificates from Amazon S3 with CData AWS Glue Connectors

If you’re authenticating with SSL certificates in your AWS Glue ETL workflows, we’ve made the process even easier! With CData AWS Glue Connectors v24.3, you can now read SSL certificates and OAuthJWT certificates directly from Amazon S3 — no more manual uploads or extra configurations needed.Here’s what you can do now:✅ Easily configure SSL and OAuthJWT certificates right from your S3 buckets✅ Streamline authentication and secure your live data integrations✅ Build even stronger AWS-native ETL pipelines 👉 Dive into the full guide here: https://www.cdata.com/kb/articles/glue-ssl-certs-s3.rst

110
M
D
DuyNguyenApprentice
asked in CData Drivers
PostgreSQL Data in MySQL Workbench with no tables

Hi.I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched.Here is my error: This is my CData PostgreSQL ODBC configuration:And this is my mysql remoting service configuration in CData SQL Gateway:This is my MySQL WorkBench connection configuration to the above “mysql remoting service”: How do I resolve this issue? Many thanks!

331
Ethem Q
Q
quinnfEmployee
posted in CData Drivers
SharePoint - Insert Behavior for ID Column on Custom Lists

When creating a custom List in SharePoint, whether through the SharePoint GUI or using the CData driver, several default columns are added automatically. One of these is the “ID” column, which is the primary key for the List.Although the “ID” column is marked as read-only in the column metadata, SharePoint does not consistently enforce this restriction during data insertion. The actual behavior depends on whether you are using the REST or SOAP schema. REST:When inserting records using the REST schema, the “ID” column can be included in the insert statement:INSERT INTO MyCustomList (ID, Column1) VALUES (1234, 'Hello REST');In this case, all data in the statement, including the explicitly set “ID” value, is persisted in SharePoint. While the CData driver typically raises an error such as:Column [ColumnName] could not be inserted. This column is read-only. This restriction is not enforced for the “ID” column when using the REST schema, as of driver version 24.0.9077.0 and later. This exce

260
Q
R
Rodrigo de AlbuquerqueEmployee
asked in CData Drivers
SAP Success Factors - Get Data Error related to snapshot based pagination

When querying my data from SAP SF or running my package in SSIS, I’m getting the following error message: Get data error: [COE_SNAPSHOT_BAD_REQUEST] We have temporarily blocked the snapshot pagination request from companyUser Test |ODATA for all entities until Thu Mar 20 15:51:40 UTC 2025 because too many consecutive requests have been attempted without accessing subsequent data.

311
R
C
Cameron LEmployee
posted in CData Drivers
New SharePoint Views: Sites, AllLists, AllFiles

As of Version: 24.0.9190 of the CData Drivers and Connectors for SharePoint, the following new views have been added to the REST schema:Sites: The new Sites view retrieves all sites across the SharePoint domain. AllLists: Retrieves lists from all SharePoint sites and subsites within the domain. AllFiles: Retrieves files and folders from all libraries across all SharePoint sites and subsites within the domain.This feature for the CData SharePoint Drivers was added in the March 2025 driver release and allows users to retrieve file information from all sites within a SharePoint domain with a single connection configured. Read more about the new views and how to use them here:New SharePoint Views: Sites, AllLists, AllFiles

90
C
C
Cameron LEmployee
posted in CData Drivers
New HCL Domino REST API Deep Dives!

Hello CData Community!We’re excited to announce the launch of a new Deep Dive series to our Knowledge Base, exploring the HCL Domino REST API. This series covers everything from setting up the REST API environment to real-world integration using CData Products. Here’s what to expect:Set Up the HCL Domino REST API Environment: Learn what the HCL Domino REST API is and how to set up the environment. Configuring Schema and Scope Settings: Learn how to configure access parameters for the HCL Notes application, ensuring structured data retrieval and secure API interactions. Using the HCL Domino REST API from Postman:  Learn to execute API requests and interact with the HCL Domino REST API in real-world scenarios. Using the HCL Domino REST API with CData Products: Learn about accessing and visualizing HCL Domino data in Tableau using the CData Tableau Connector for HCL Domino.If you have additional questions, please let us know!

310
C
M
MohsinEmployee
posted in CData Drivers
🚀 Build Your Own Snowflake Tap with Singer.io!

Singer.io currently doesn’t have a Tap for Snowflake — so we decided to write a quick, easy guide on building one from scratch.We’ve explored how to dynamically retrieve Snowflake metadata using system tables, define a schema based on discovery, and pipe the data into a CSV — all using CData’s Python Connector for Snowflake and Singer.Check out the complete step-by-step guide here: https://www.cdata.com/kb/articles/snowflake-python-singer.rst

50
M
M
matthewrEmployee
asked in CData Drivers
Encountering "Unable to retrieve columns for table [tablename]" error when querying invoice and timeentry tables within NetSuite's SuiteQL schema

When executing queries on either of the invoice or timeentry tables in the SuiteQL schema within your NetSuite connection, you may receive the following error, replacing <tablename> with the name of the table being queried:Unable to retrieve columns for table [<tablename>].This error may be encountered even when permissions are properly configured and when the connection is successfully tested. With this in mind, what should be done to work around the error?

301
M
A
ashish.pancholiApprentice
asked in CData Drivers
Can the CDATA JDBC Driver be used to retrieve the table(s) and view(s) names from the SAP HANA DB focused on the SAP modules or archive objects?

Hi CDATA Team, There are many tables, views, and other database objects in the SAP application database. I wanted to check if the CDATA JDBC Driver aids in obtaining the filtered list based on SAP modules or an archive object, as it is quite difficult to identify tables based on any standard SAP module or standard archive object.I therefore want to retrieve the list of all tables and views that are utilized in, say, the FI module or FI_Documents, as part of my requirement. Is it possible to retrieve the table and view names from SAP HANA DB using the CDATA JDBC Driver based on SAP modules? Example:If you're querying an SAP table, you could specify a filter such as:SELECT * FROM "SAP_Material" WHERE "Module" = 'MM' Or, for archived objects, the query might look something like:SELECT * FROM "SAP_Archive" WHERE "ArchiveObject" = 'SomeArchiveObject' Thanks

441
A
M
MohsinEmployee
posted in CData Drivers
Optimize Microsoft Access with SQL Pass-Through Queries

Looking to enhance performance in Microsoft Access? Learn how SQL pass-through queries can help you execute SQL directly on external databases, reducing bottlenecks and improving efficiency.Go beyond the native capabilities of Microsoft Access pass-through queries with CData ODBC Connectors, leveraging sys_tables and sys_tablecolumns system tables to retrieve metadata more efficiently and comprehensively. Read the full guide here: SQL Pass-Through Queries in MS Access

120
M
D
DibyenduEmployee
posted in CData Drivers
Maximizing SQL Server Linked Server Efficiency with CData SQL Gateway

Hey CData Community!Recent updates to the CData SQL Gateway have significantly enhanced its read and write speed performance. Users can now experience up to an 8x improvement in performance across all 270+ supported data sources.Our recent CData SQL Gateway performance test article compares the read and write performance of the Snowflake ODBC driver using two versions (Old [Build 8957] and New [Build 9165]) of the CData SQL Gateway remoting service in SQL Server with Linked Server when handling large datasets. We investigate if the latest version of CData SQL Gateway reads and writes large datasets into SQL Server faster than the older version, with the help of varied performance tests.Read here to know more about the tests performed: Maximizing SQL Server Linked Server Efficiency with CData SQL GatewayIf you have additional questions, please let us know!

90
D
C
Cameron LEmployee
posted in CData Drivers
Using DirectQuery in Power BI with CData Power BI Connectors

CData Power BI Connectors support real-time integration with any data source using DirectQuery in Power BI. With DirectQuery, Power BI users can seamlessly work with large datasets while avoiding the issues associated with using traditional import methods that take too much time. Read more about using DirectQuery to connect to large datasets with CData Power BI Connectors here:Using DirectQuery in Power BI with CData Power BI Connectors If you have additional questions, please let us know!

140
C
D
DibyenduEmployee
posted in CData Drivers
How to download and use CData ADO.NET providers in Visual Studio for Windows

Hey CData Community!To download, install, and use CData ADO.NET providers to develop .NET Core apps in Windows, you can also use the NuGet package manager in Visual Studio. First, to manage NuGet packages, right-click on your solution’s name in the Solution Explorer panel and navigate to Manage NuGet Packages… Now, go to Browse and search for your desired provider (e.g.: CData.Salesforce). Select the provider from the list of results and click Install. In the License Acceptance window, click I Accept. Select either the Full or the Trial license. In this step, we have selected the Trial license for demonstration purposes. In the next step, add your Name and Email ID and click Activate. This will add the 30-day trial license for the installed provider. After the installation, you should see the provider (DLL files) in the References section of the Solution Explorer.  To obtain a trial or full license for the provider, please contact [email protected].  

550
D
C
Cameron LEmployee
posted in CData Drivers
New Connectivity to Greenhouse through CData Solutions

CData's new Greenhouse Drivers and Connectors enable seamless integration with Greenhouse, allowing users to easily connect their HR data with reporting tools, databases, and custom applications through standards-based drivers. With these new drivers and connectors, you can streamline reporting, analytics, and decision-making by accessing Greenhouse data in real-time.Read more about CData’s Greenhouse connectivity here:https://www.cdata.com/blog/connectivity-to-greenhouse If you have additional questions, please let us know!

110
C
M
MohsinEmployee
posted in CData Drivers
Access Excel Data from Subfolders of a Root Resource Directory

Recently, a new subfolder file access feature was released for the CData Microsoft Excel drivers, enabling seamless retrieval of Excel files stored in subdirectories of a root resource folder. Key parameters include:IncludeSubdirectories – Enables scanning of subfolders within the root folder to locate Excel files. DirectoryRetrievalDepth – Defines how deep the scan goes within subdirectories. Use -1 to scan all subfolders within the root directory. PathSeparator – Prepends the relative folder path to schema names using a customizable delimiter (default: "_"), ensuring unique table identification.Check out the complete guide on how to set it up locally and access Excel sheets as tables: Access Excel Files within Sub-Folders Using CData Excel Drivers

210
M
D
DibyenduEmployee
posted in CData Drivers
Authenticating Connections from the Client Side

Hey CData Community!When using CData ODBC Drivers and Power BI Connectors to connect to a data source, authentication is usually handled through the ODBC DSN settings. However, what if you want more flexibility? Some users prefer to authenticate directly from the client—whether it's Power BI or another reporting tool—to streamline access and enhance security. Let’s explore how to make that happen!Refer to our latest Knowledge Base article, which guides you through the process: https://www.cdata.com/kb/articles/authenticate-connections-client-side.rst

150
D
Q
quangdutran809Collaborator
asked in CData Drivers
CData for MongoDB JDBC error Authentication failed

I’ve downloaded JDBC driver for MongoDB but when using it with the correct username password, it throws the error:Exception in thread "main" java.sql.SQLException: Failed to authenticate database 'testdb', Error code: [18] - "Authentication failed."..  Class.forName("cdata.jdbc.mongodb.MongoDBDriver"); Properties prop = new Properties(); prop.setProperty("Server","127.0.0.1"); prop.setProperty("Port","27017"); prop.setProperty("Database","testdb"); prop.setProperty("User","useradmin"); prop.setProperty("Password","welcome!"); Connection conn = DriverManager.getConnection("jdbc:mongodb:", prop); Statement stat = conn.createStatement(); boolean ret = stat.execute("SELECT name FROM users"); It throws error on the last line. These username password are correct and can be used in mongosh inside mongo server container

2007
Ethem Q
R
Renukachari_KaseeEnthusiast
asked in CData Drivers
Azure cosmos DB dataset one column having sub dataset that need to be extract

Hi All, Please help me on to extract the column dataset using cdata cosomos db driver using cdata connector.  Thanks,Chari

969
R
R
Rodrigo de AlbuquerqueEmployee
asked in CData Drivers
"The primary key must be specified to update a row" error - SSIS Destination components

When trying to run an update with my CData SSIS Destination components, the job is failing with the following error: “The primary key must be specified to update a row”. What should I do to workaround this problem?

631
R
Jerod
JerodCommunity Manager
posted in CData Drivers
CData Connectors Support the LAG() Window Function

CData Drivers, Connectors, and other solutions now include the LAG() window function in the library of supported SQL functions. This capability unlocks the ability to compare and calculate the change in values over a sequence of data. This support is across all data sources. Where possible, CData solutions will push the LAG request down to the data source, otherwise the function will be resolved in memory after the initial data is retrived.Example Query Using the LAG() FunctionThe example below uses the Data Explorer in CData Connect Cloud with a Salesforce connection, but the principals apply to any CData solution across all data sources.The query below calculates the sum of all expected revenue for all opportunities, grouped by month of the opportunity and the associated customer account in Salesforce. Using the LAG() function, we compare each month's expected revenue to the previous month.QuerySELECT Account.Name, SUM(ExpectedRevenue), AS CurExpRevenue MONTH(CloseDate)

70
Jerod
CData MCP Servers

Badge winners

Show all badges
Terms and ConditionsCookie settings