CData Drivers

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

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

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

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?

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.

Hey CData Community!When analyzing business data using BI tools like Power BI and Tableau, you’ve probably found yourself thinking, “This is interesting” or “I need to take action on this item.” After all, the primary goal of analysis is to inform and drive action.Imagine you spot a key insight in your BI dashboard and want to act on it immediately. Instead of jumping directly to the specific SaaS screen, you must open the SaaS, log in, search for the relevant record (whether it’s a customer in a CRM or a project in a task management tool), and navigate to the exact item—an annoying series of steps for something that should be simple.Now, with the latest UI URL capture feature in CData Drivers, this hassle has become a thing of the past. To know more, refer to our latest Knowledge Base article, which guides you through the process: https://w

Hey Community!I’m happy to announce that we’ve published a GA4 Views Intro with Google Analytics Drivers at our Knowledge Base: cdata.com/kb/articles/ga4-driver-views.rstThe guide covers the basics of available views in the CData Driver for Google Analytics and encourages users to explore further.Let us know if you've got any feedback!

The 2024.1 Update for CData Drivers and Connectors include additional connection properties for our Google Analytics connectors to set default start and end dates for GA4 reports.Connection PropertiesDefaultStartDate: A default start date to be applied to all queries for the given connection. This property will be overridden if a start date is set in a query. DefaultEndDate: A default end date to be applied to all queries for the given connection. This property will be overridden if an end date is set in a query.Add these properties to your connection string or connection wizard to set start and end dates for GA4 reports queried using CData’s connectors!

Hi, We’re using CData ADO.NET Provider for Snowflake 2019 [Build 7362] and we’re facing a problem working with UNPIVOT. We’re targeting the Snowflake_Sample_Data with this command:SELECT CC_CALL_CENTER_SK, CC_CALL_CENTER_ID, CC_CLOSED_DATE_SK, CC_OPEN_DATE_SK, Attribute, ValueFROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTERUNPIVOT ( Value FOR Attribute IN ( CC_NAME, CC_CLASS, CC_HOURS, CC_MANAGER, CC_MKT_CLASS, CC_MKT_DESC, CC_MARKET_MANAGER )) AS unpivoted_data;The query is working fine on Snowflake instance but not with CDATA Snowflake driver. We’re getting the error below:Malformed SQL Statement: Expected token ')' but found Identifier with value 'FOR'

 TITLE: Microsoft Visual Studio------------------------------Could not load file or assembly 'Microsoft.DataWarehouse, Version=17.3.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specifiedIt appears after installing the SSIS component for monday 2024 (Build 24.0.9111)Running VS 2019 and the target SQL Server is 2022 Previously i was running monday 2023 (Build 23.0.8839) without this error. Had another error unrelated to this and the reason why I tried to upgrade.I have tried to uninstall and reinstall the old version again but the error remains 

Hey CData Community!I’m happy to announce we’ve published a Deep Dive series to our Knowledge Base around our SAP integration:Which CData Driver should I use? - Learn which CData solution fits with the particular “flavor” of SAP that your organization is using. How to Create RFC Modules with CData Drivers - Learn how to execute and create RFC modules with CData Drivers How to Use the SAP Gateway Module to Create an OData Service for SAP S/4 HANA - Learn how to use the SAP Gateway Module to create OData services for SAP S/4 HANA

Hello CData Community,I need some help troubleshooting issues I’m facing with setting up the CData ODBC Driver on my AMD 2 in 1 laptop. I’m hoping someone here might be able to assist.Here’s what I’ve done so far:Installed the CData ODBC Driver successfully without any errors. Configured a DSN using the ODBC Data Source Administrator and entered the necessary details for connecting to my data source. The connection test within the ODBC configuration returns successful, but when I attempt to connect through certain applications, the data source is either missing or cannot be accessed.Challenges I’m Facing:Data Source Visibility: Despite successfully configuring the DSN, it doesn’t show up in applications like Excel or custom software

Hi, i am using cdata for PBI Excel Online to connect my SharePoint files to PowerBI. My SharePoint folder contains secondary folders with multiple documents as well as my main excel. Is there a way to bring the names of the secondary folders into my dataset as well? It's referred to as “Folder Path” when I connect my PBI directly to SharePoint via SharePoint.Files.

I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but couldn’t locate these transactions. Interestingly, when I used the 'TransactionsList' stored procedure, I was able to retrieve all transactions, including the missing ones.I suspect that some transaction types, such as Payroll Checks, may not be accessible through the CData connector or Intuit Accounting API. Has anyone else encountered this issue? Is there a known limitation or a workaround to include these transaction types in the data model?

I need to copy specific data from the SAP ECC 6.0 tables listed below and paste it into the matching SAP S/4 HANA tables. ADMI_FILES ADMI_RUN  ADMI_STATS ADMI_VARIAI attempted to copy the data manually, and it worked. However, could you please advise if CData JDBC Driver could be used to accomplish this?

Hello everyone,,I am working on setting up a connection between my SQL Server database and a C# application using the CData ADO.NET provider for SQL Server but I am running into some authentication issues. I would like to use Windows Authentication but it doesn’t seem to be working as expected: I have double checked the connection string settings and ensured that "Integrated Security" is set to true. However,,, I keep getting an error related to login credentials.Has anyone here dealt with similar authentication issues using CData’s ADO.NET provider: ?? Also, if there’s a workaround to ensure the connection uses the current user’s Windows credentials,,, I would really appreciate any guidance. I have already gone through this thread https://community.cdata.com/cdata-sync-47/cdata

Hi, I’m confused on how to select the dynamic fields. When I look in the driver ui, I can see the dynamic fields like “createdbyname” which are populated based on the values in “createdby” - but if I try to query using `select createdbyname from account` I get an error: “Query failed: [0x80060888] Could not find a property named ‘createdbyname’ on type ‘Microsoft.Dynamics.CRM.account’” Is there something special I need to do to be able to do this? In TSQL with ssms I can select these fields without issue. Reading through the docs, I don’t see a driver setting that seems like it would enable this feature. Can anyone tell me what I’m missing? 

Hi Community, I have installed Cdata cosmos mongodb driver for a poc and i am able to connect Azure Cosmos Mongo db. In jdbc ui inferface and in data model tab i am able to see the collections along with data. but when i try to query the same from dremio i get error "unknown operator: $readPreference”. can someone help me on this issue?  RegardsAmit

Using the ODBC driver, I am trying to query ChoiceLabels - this simple query works in SSMS but not using the ODBC driver in my reporting application: select * from choicelabels The odbc driver returns:A table could not be found that matches choicelabels.Is there something else I need to do to query this table? I need to join it against an entity table in order to decode the choice value.   

When specifying the name of a table in the Tables connection property (or the name of a view in the Views property), you may receive the following error when querying a table in your Oracle connection (even if the connection was successfully tested):The catalog needs to be specified in the TABLE or VIEW property.However, Oracle does not make use of catalogs. With this in mind, what should be done to work around the error?

Hello Everyone, My name is Emmanuel Katto. I wanted to know what are the methods for achieving real-time data synchronization using CData connectors? Are there particular connectors better suited for this? Looking forward to your suggestions. Thanks in advance! Best,Emmanuel Katto

Do we have a visual JDBC ODBC bridge getting started guide? Unfortunately, I’m a visual learner and I can’t find visual resources on how to set it up on my device. I’m using Microsoft Server

Hi All,I am trying to connect my dynamics GP web services through python but I am unable to do so. I was working out the basic code given on their website and still unable to work it out. Could you advise any probable solution for it?ERROR:cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

Hi,I don’t see a connector for “delta lake” on Azure Data Lake Store Gen2. Is this not a supported source? If not, is it on the roadmap? Thanks.