Skip to main content

Live Connectivity

Ask questions, get answers, and engage in discussions about real-time data connectivity solutions from CData.

161 Topics
John
JohnCommunity Manager
posted in Connect Spreadsheets
Connect Spreadsheets by CData - Video

  Connect Spreadsheets is the easiest way to get all your live data into Microsoft Excel or Google Sheets – no more downloading, wrangling, and uploading files again. Just connect to your data, select the dataset you’d like to see, and import it into your spreadsheet.  

91
A
9 hours ago
S
ShakilApprentice
asked in CData Drivers
Missing Transactions in Power BI Data Model with QuickBooks Online Connector

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?

262
S
12 hours ago
John
JohnCommunity Manager
posted in Connect Spreadsheets
CData Connect Spreadsheets: Bringing Seamless Data Connectivity to Your Spreadsheets

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. From finance teams to analysts and everyday spreadsheet users, anyone can now enjoy data that’s connected, current, and completely under your control. Why Connect Spreadsheets? Spreadsheets have always been one of the most widely used data tools. Connect Spreadsheets embraces this, enabling teams to use the data they need,

60
John
16 hours ago
John
JohnCommunity Manager
posted in Connect Spreadsheets
CData Connect Spreadsheets: Bringing Seamless Data Connectivity to Your Spreadsheets

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. From finance teams to analysts and everyday spreadsheet users, anyone can now enjoy data that’s connected, current, and completely under your control. Why Connect Spreadsheets? Spreadsheets have always been one of the most widely used data tools. Connect Spreadsheets embraces this, enabling teams to use the data they need,

50
John
16 hours ago
A
ashish.pancholiApprentice
asked in CData Drivers
Is it possible to copy selective data from SAP ECC to SAP S/4 HANA using the CDATA JDBC Driver?

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?

232
A
2 days ago
marcellosalas
marcellosalasApprentice
asked in CData Drivers
Issues Connecting to SQL Server with CData ADO.NET Provider - Need Help with Authentication Setup!

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-sync-error-when-creating-a-source-connection-to-sql-server-rpa/ but couldn’t get enough solution.Thanks in advance for your help, any suggestions or resources would be a huge help as I troubleshoot this.With Re

391
L
7 days ago
D
DaveJones4Collaborator
asked in CData Drivers
Dataverse ODBC Driver - How to select dynamic fields

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? 

834
PratikV
10 days ago
A
Amit SharmaApprentice
asked in CData Drivers
Dremio - Cdata cosmos mongodb Data Read

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

370
A
21 days ago
D
DaveJones4Collaborator
asked in CData Drivers
Using Dataverse ODBC - how to query choicelabels?

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.   

568
Ethem Q
1 month ago
M
matthewrEmployee
asked in CData Drivers
Encountering "The catalog needs to be specified in the TABLE or VIEW property" error when querying an Oracle connection

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?

331
M
1 month ago
E
emmanuelkattoNewcomer
asked in CData Drivers
Methods for achieving real-time data synchronization - Emmanuel Katto

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

221
Ethem Q
1 month ago
J
JdotceeApprentice
asked in CData Drivers
Visual getting started guide for JDBC ODBC driver

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

732
J
1 month ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Deleted Reporting Balance Row Track

How to track which reporting balance row is deleted? because I am syncing record through Power automate. I am not able to track which row is deleted in reporting balance. if i get to know about that transaction I will sync that particular row related records again I am using cdata cloud

371
Ethem Q
2 months ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Reason for ID change in Reporting Balance

5 days back  I get rows from Reporting balance and stored in one excel again I fetch same rows from reporting balance but i noticed that ID is changed for some rows Eg :228473716 where previously for one row but the same row ID is differed now like 2284765654Based on GLAccountCode Division and Reporting year I am fetching the rows any reason for this ? how to track this which row is changed ?Thanks

462
M
2 months ago
M
muthuEOLApprentice
asked in CData Connect Cloud
GLSchemeCode Change track

I have GL Account Classification Mapping In Dataverse Table i used automation to pull data from Exact online and pushed data into dataverse . I need help on how to track that GLSchemeCode Changes from previous version  to updated version Eg:RGS versie 3.3 to RGS versie 3.5 in overtime because based on this updation in exact online I want to update the same thing in dataverse table  how to track this change and update accordingly ?

521
Ethem Q
2 months ago
M
muthuEOLApprentice
asked in CData Connect Cloud
Check GLAccountCode linked with Division

from which table we can check what are GLAccount code linked for a particular Division ? 

291
Ethem Q
3 months ago
Jerod
JerodCommunity Manager
posted in CData Connect Cloud
Powered by CData - Embedded Connectivity for Connect Cloud

Powered by CData is a way for customers to integrate CData Connect Cloud live data access capabilities for their end users within their own applications.Contact CData sales if you are interested in a Powered by CData account.What is it?Powered by CData is our OEM White label offering for Connect Cloud. It is an embedded solution for customer products and applications to enable their own users to create live data connections right inside their product. Behind the scenes, CData is building and running those data connections.​Who is it for?Powered by CData is for customers that are running and building their own products that need customer data onboarded or have to provide other embedded connectivity capabilities. Instead of building those features out themselves, customers can instead leverage CData's robust and wide selection of drivers and enable users to create those connections and add their credentials themselves.​Why embedded connectivity?A growing number of products require users

710
Jerod
3 months ago
G
GawriApprentice
asked in CData Drivers
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 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.

461
Ethem Q
3 months ago
R
RajeshApprentice
asked in CData Drivers
Delta lake supported?

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.

521
E
3 months ago
James T
James TEmployee
asked in CData Drivers
How can I set up Tableau Bridge with a CData ODBC Drivers?

I found out that I need Tableau Bridge in order to “bridge” my CData ODBC driver with Tableau Cloud. Do you have any instructions you can share?

451
James T
3 months ago
James T
James TEmployee
asked in CData Drivers
Can I use Custom Filters in Tableau to set up Incremental Refresh?

I have a lot of data in my data source that I am trying to use with Tableau. When using CData connectors, is there a way I can help improve performance by only pulling in changed data?

171
James T
3 months ago
S
shaiApprentice
asked in CData Connect Cloud
IICS target failing when encountering error records

I’m using the cdata connector to load from snowflake to Microsoft dynamics dataverse target.I have tested the following approach:I have tested with JDBC_IC connection and the reject records are captured in error file but processes the good records. While running with the JDBC V2 connection the mapping fails when it encounters a record and rolls back all record.Any suggestions on creating error record file with JDBC V2 would be very helpful

991
Ethem Q
4 months ago
T
thebank987Apprentice
asked in CData Drivers
How do I use ArcESB to retrieve data from restful API using a webhook, then take that data and import it into SQL Server Management Studio?

I have a project where I need to retrieve data from a RESTful API. I have already created my request script and tested it in POSTMan.  I would like to retrieve data from the RESTful API’s response, input the data into SQL Server Management Studio.  My Question is what is the appropriate flow of connectors to build this? The Goal is to use a Webhook to retrieve data from the RESTful API, then be able to import that data into tables in SQL Server Management studio.   

781
Rohit
4 months ago
N
ntropicApprentice
asked in CData Drivers
JDBC Azure DataBricks and AzureServicePrincipal Authentication

I am trying to understand the driver behavior when connecting to an Azure DataBricks workspace using AzureServicePrincipal. Given the Azure Service principal and secret it seems to first obtain the Azure AD token and then it tries to call DataBricks REST API using the Azure AD token to obtain a Personal Access Token for the service principal. This is a problem because we do not allow personal access tokens in our environment. Is there a reason why it cannot use the Azure AD token directly to obtain access? Appreciate any insights or help.

832
N
4 months ago
R
RajaApprentice
asked in CData Drivers
CDATA jdbc excel license for ODI Prod and non Prod servers both local and server agents

HiPlease anyone explain the licensing requirement for Oracle Data Integrator (ODI) using CDATA jdbc driver for excel? We have purchased the cdata jdbc excel driver for ODI however not sure if we can use the license on both PROD and non PROD servers as its two different servers and two ODI agents. Do we need to generate the license file on both server from one license? and also we have local agent and server agent in ODI so how do we use the licence wisely?  How do we make use of the license on both prod & non-prod and local & server agents in ODI?  ThanksRaja

151
Ankit Singh
4 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings