CData Drivers

When connected to my data source as a Remote Oracle Database via the ODBC Driver, I run into the following error when trying to perform inserts or updates into my database: Error ORA-02070: database xxx does not support <operation> in this contextorORA-02070: database xxx does not support some function in this context I am connected via the Database Gateway dg4odbc. How can I resolve this issue?

Can anyone tell me how to ? I can connect to unprotected excel files, but it says “directory not found” when trying to open password protected ones. I have tried to provide password in various property fileds as well as tried to change “authscheme” but no avail. Kind regards

There’s been a lot of buzz around model context protocol (MCP) lately, and for good reason. The ability to easily connect LLMs to enterprise systems is extremely useful!Outside of our own MCP Servers, you can use our existing technology to build your own MCP Server. To learn how we did it in Java, check out our latest KB article: https://www.cdata.com/kb/articles/jdbc-mcp-server-dev-guide.rst

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 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?

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

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

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.

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

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”:

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

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.

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

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.

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

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?

We are using the ADO.Net QuickBooks Online driver which we have used for many years. Recently we are no longer able to connect with the QBO Profit and Loss statement. We are able to connect with the Balance Sheet. The line of code that it’s erring on is this:Using rdr2 As QuickBooksOnlineDataReader = cmdIS2.ExecuteReader()Here is what I’ve done:1. Tried on both Windows 11 and 10 computers2. Reviewed the schema file 3. Examined the log file (verbosity 5) - here’s a snippet2025-03-12T09:34:39.693-07:00    2    [   13|    5|   38]    [HTTP|Res: 17] HTTP/1.1 406 Not Acceptable, 0 Bytes Transferred2025-03-12T09:34:39.708-07:00    2    [   13|    5|   38]    [HTTP|Res: 17] Error: HTTP protocol error. 406 Not Acceptable. Stack:    at rno240u.T.pX(String )   at rno240u.AF.lF(String ) If anyone has any suggestions, I’d appreciate your thoughts.Thanks,Sally  

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

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

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:

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!

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

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!

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

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