Live Connectivity

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?

I am using CDATA Connect AI with a virtual SQL server to connect to Exact Online. I have two requirements related to data tracking and retrieval: Tracking Classification Code Changes: I need to track any changes or modifications made to the Classification Codes in Exact Online. Specifically, I want to retrieve all rows where changes have occurred in the Classification Codes. Request: Could you provide a SQL query to fetch rows with any modifications or changes in the Classification Codes? Retrieving Division-Associated GL Account Codes: I need to retrieve the GL Account Codes associated with each Division in Exact Online. Request: Could you provide a SQL query to fetch the Division-associated GL Account Codes?

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.

 We are excited to share that this week scheduled queries are available to all Connect AI accounts! With Scheduled Queries, you can automatically write data to a variety of supported destinations based on a schedule you set. Using either our Query Builder, or by writing your own custom SQL queries, ensure your data is up to date when needed in the destination of your choice. The following destinations are currently supported: BigQuery Databricks PostgreSQL Redshift Smartsheet Snowflake Try it out in the Data Explorer in Connect AI today!Learn more in the blog: 

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!  If you are on a free Spreadsheets plan every month you are receiving an email that states you may need to update your billing information.  Remember that your subscription is FREE and that you are not required to have payment details on file. However, due to regulations we need to send out a reminder that you are on an auto renewal and we have our emails worded the same for all our renewal emails if you are paying or not at this time.  Sorry if it has confused you. 

I’ve got something stumping me… In Connect AI, i set up a custom report to use a NetSuite Saved Search. When executing the Saved Search in NS, the results display fine and as expected. When i use Connect AI to call the Saved Search - it displays the columns properly prior to execution, but the execution results show 0 rows. in NS, there are a total of 1935 rows.  I’m not sure what barrier lies between the Saved Search and the Connect AI custom report results - but something between those two seems to be preventing the results from coming into Connect AI. What should I check?

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.

Hello Connect Spreadsheets community!  What kinds of reports are you connecting data to and building in Excel and Google Sheets using Connect Spreadsheets? We are looking for feedback and ideas of what reports we can standardize to come prebuilt in templates, ready to fill with data, in Connect Spreadsheets, to make it easier for users to get the report they want. Whether it’s P/L statements, sales reports, or something else, let us know and your idea may be chosen to make building your reports easier!

 Q: How do I install Connect Spreadsheets? Select your preferred spreadsheet, where you’ll be directed to install the add-in for Google Sheets or Excel in their add-in marketplaces. Then, open your spreadsheet and launch Connect Spreadsheets. You’ll be prompted to sign up for a Connect Spreadsheets account. Finally, sign in and start connecting data to your spreadsheet.  Q: Is there a free trial? All accounts start on a 15-day free trial of the unlimited Pro plan. Purchase a paid plan before your trial ends to convert automatically and never lose access to the unlimited benefits of Connect Spreadsheets.  Q: What are the limits if I stay on the free plan? Continue to use Connect Spreadsheets free forever, no credit card required, but after your 15-day free trial you’ll be limited to only 5,000 records per query, 1 user, 3 data sources, and 50 total queries per month. Upgrade to a paid plan to connect data with more users, remove

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?

Introducing Connect Spreadsheets, CData’s latest offering for effortless data access in Excel and Google Sheets. What is Connect Spreadsheets? Connect Spreadsheets is a free tool that connects your spreadsheets to data from 250+ sources without any of the usual hassle. Instead of exporting and copying data manually, simply connect once and access fresh data with a click or on a set schedule. No coding is needed, and it’s available right now on Google Workspace Marketplace and Microsoft AppSource. Who is it for? Connect Spreadsheets is for anyone who works in Google Sheets or Excel and needs live data without the extra steps of downloading, importing, or reformatting. Fro

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?