Real-Time Connectivity

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

48 Topics

AndyN
AndyNApprentice
asked in CData Drivers & Connectors

Trying to Insert a ManualJournal into Xero with ODBC

I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error. “A validation exception occurred: The total Debits (1.50) must equal total credits (0.00)" It suggests that cdata is not processing it as one API post but as 2 posts and Xero spits back an error because it expects both lines in the POST api. INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration) VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');Any ideas would be appreciated. 

2
AndyN
1 day ago
W
wecanseeformilesApprentice
asked in CData Drivers & Connectors

Trying to use a cData ODBC DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS.

ObjectiveTrying to use a cData DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS. I can successful setup the DSN in iODBC Data Manager and it tests successfully, but when I try to use the DSN in Excel I get a “Could not bind server socket: Operation not permitted”.   I have screen-grabbed all my steps below in the attached PDF.  

1
E
2 days ago
R
RobNealApprentice
asked in CData Drivers & Connectors

How to update columns for SSIS oData source

We are a new CData user, connecting Acumatica oData as the source to SQL Server OLE DB destination.  It works great for the initial configuration of the data flow, but we often change the underlying Acumatica query (i.e. add columns). I can’t seem to find a way to refresh the available columns in the CDdata Acumatica Source Editor screen.  If I click the preview button, the new columns appear there correctly with data, but how are the columns added to the Columns node of the Editor screen?  Along those lines, is there a way to refresh the list of available Generic Inquiries for new oData sources?  The first time you log into Visual Studio the list of available inquiries refreshes, but after that I have to just use the Advanced Editor and hand-write the name of the query.  Thanks for any feedback!

1
E
2 days ago
E
Elizabeth GEmployee
posted in CData Drivers & Connectors

Using the QuickBooks driver with the QuickBooks Gateway

The QuickBooks Gateway (formerly Remote Connector) is useful if you want to access QuickBooks in a situation where direct COM access to QuickBooks is not available, such as in ASP.NET, Java, or QuickBooks on a remote machine.To authenticate to the QuickBooks company file, you will first need to create a user in the QuickBooks Gateway. Upon pressing Test Connection on that user, a prompt will open and ask you to authenticate it to QuickBooks. Note that QuickBooks must be open as an administrator in single-user mode for this to succeed.Then, you will need to open the QuickBooks DSN/Connection Manager/Connection String Builder and, in the Remote section, enter the information on the QuickBooks Gateway user you just created. The User and Password will be the username and password of your QuickBooks Gateway user, and the URL will be the URL of the QuickBooks Gateway. Note that the Company File property can be left blank, as the QuickBooks Gateway has already specified which company file to

0
E
3 days ago
E
Elizabeth GEmployee
asked in CData Drivers & Connectors

Multiple company files in QuickBooks

Is it possible to connect to more than one QuickBooks company file? My organization uses a few company files, and I’m confused as to how to connect the driver to all of them.

1
E
8 days ago
M
MarcApprentice
asked in CData Drivers & Connectors

Excel add-in for Zoho Books: How to select all “BillLineItems”

Hi!I’m using the Excel add-in to connect to Zoho Books. I would like to get all “BillLineItems” from Zoho. The BillLineItems is a standard view or table.It is not possible to use the SELECT * command in order to retrieve all lineitems. It is required to a specify a BillID (key) number in order to get the data for that specific bill from this table (as I understand).Maybe it is my lack of knowledge of SQL. Do you have any suggestions how to get all BillLineitems? Thanks in advanve for your response.Regards,Marc

2
M
14 days ago
A
AbhilashApprentice
asked in CData Drivers & Connectors

Class java.lang.Boolean cannot be cast to class java.lang.Number

Issue encountered while extracting data using CDATA JDBC driver in Snaplogic. Specifically, we are receiving the following error message: "Class java.lang.Boolean cannot be cast to class java.lang.Number (java.lang.Boolean and java.lang.Number are in module java.base of loader 'bootstrap')" Thanks

1
E
23 days ago
Lori
LoriEmployee
posted in CData Connect Cloud

Tip of the Quarter: Easily publish real-time Workday data to PowerBI.com or Power BI desktop

There are so many benefits to connecting real-time to Workday data from Power BI. No install, just signup for Connect Cloud > Configure DSN.  Easily find the connector in Power BI (under Other data sources) Connection to Workday data occurs instantaneously in Power BI Build intricate visualizations in Power BI based on Workday dataRead this technical article for details on how to connect with PowerBI.comRead this technical article for details on how to connect with Power BI desktop

0
Lori
30 days ago
A
AbhilashApprentice
asked in CData Drivers & Connectors

"Error downloading license: Connection reset" - while installing the CData JDBC driver on linux machine?

We are getting the error message when we tried to install the JDBC on Linux machine.Error:Downloading license data...Error downloading license: Connection reset We were given the linux setup link to download the setup.zip file, after downloading we are not being able to install the JDBC driver on Linux Machine.we are using-  “java -jar cdata.jdbc.xero.jar -license” command from linux terminal to install the driver.Please suggest.Thanks.

1
B
1 month ago
A
AbhilashApprentice
asked in CData Drivers & Connectors

Not able to get the NodeId of Linux Machine

We need to request for transfer of the license from one machine to another, for that we need to get the NodeId of both the machine, the new machine is Linux where we need to transfer the license, as per the Cdata tool to get the NodeId :- https://www.cdata.com/lic/nodeid.exe we can get the NodeId from windows system, but it this tool is not working for Linux system, we also tried ‘Wine’ to run this .exe but we did not got the NodeId, can anybody suggest how to get the NodeId from Linux system.Thanks in advance

3
E
1 month ago
B
Brooks EEmployee
asked in CData Drivers & Connectors

How do I locate my JDBC JAR file path from the tool using it?

I need to locate the file path my tool is referencing the CData JDBC Driver from. I needed to manually move it in the past to a new location outside the installation directory to get the tool to use it, but after time have forgotten where that path was. 

1
B
1 month ago
Lori
LoriEmployee
posted in CData Drivers & Connectors

Rich Data Experience with CData Drivers

Did you know….CData Drivers provides rich data and offer an out-of-the-box experience, supporting a number of technology stacks including JDBC, ODBC, and ADO.NET.  Here are four other ways CData enriches your data experience. Universal Standards: CData optimizes the interoperability of APIs by exposing mapped resources for common use cases and operations to a corresponding relational model, with tables, views, and stored procedures, making it easy for developers to code against it like they would with any other database driver.  Data Model:  CData drivers automatically detect complex structures and metadata, then model them in a relational manner or other configurations, making it easier to connect to the data you need. If you know SQL, you can build user-defined views, manipulate the data model, and define custom entities.Query language - Standard SQL query 92 language – You don’t need to learn all of the different variations of SQL. A full SQL-92-ready query engine is built into each

0
Lori
1 month ago
Lori
LoriEmployee
posted in CData Drivers & Connectors

No Maintenance Headaches with CData Drivers

Did you know…CData heavily invests and proactively monitors APIs and data sources for changes such as new objects, actions, compatibility criteria, and deprecation of features, to ensure CData drivers are kept up-to-date and maintenance-free for you. Here are some ways CData maintains drivers and connectors:CData engineering teams subscribe to the data source and technology developer portals to proactively monitor CData builds and nurtures working relationships with technical partners, OEM companies, and data source and technology tool vendors to “be in the know” of upcoming innovations and changes. CData addresses critical changes and external unplanned circumstances with priority CData provides quarterly publicly available releases, and one-off emergency fixes as necessary

0
Lori
1 month ago
A
Artem3001Apprentice
asked in CData Drivers & Connectors

Why the Update Rows button is not active in CData Excel Add-In for Google Calendar after the installation?

I installed the CData Excel Add-In for Google Calendar, but the Update Rows button, which is responsible for changing the table to change events in the Google Calendar button is not active. Although the connection to the calendar was established successfully. Can you help, please?

1
A
1 month ago
D
Dan SApprentice
asked in CData Drivers & Connectors

QuickBooks "QBW32.EXE - Fatal Application Exit" error using Remote Connector

Hello All,I am using the CData OBDC driver and Remote Connector to integrate SQL Server with QuickBooks Desktop. I have SLQ stored procedures that query QB as a linked server. I'm using this to query the QB customer list and insert timesheet records. It works great 90% of the time. About 10% of the time QB throws and error "QBW32.EXE - Fatal Application Exit" with an open dialog box on the server which must be manually acknowledged. Everything works fine again once the error is acknowledged.QuickBooks Desktop along with the QB company file are installed on a server. The CData OBDC driver and Remote Connector are also installed on the same server. This installation of QB desktop is dedicated to the SQL integration. Other users in the company access the QB company file from local installations of QB Desktop on their PC'sThere is an external app that triggers the SQL stored procs. It was my intention to run the integration unattended on the server. The Remote Connector will automatically

2
D
1 month ago
C
crusoApprentice
asked in CData Drivers & Connectors

Building a Standardized Querying Layer (Metrics, Dimensions, Filters & More)

Hi CData community, We are building a KPI tracking SAAS at Datapad and we’re using CData Drivers as the backbone.Essentially, any user is able to login with a data source through OAuth and can create metrics & reports. We wanted to as if there is a best-practice to create a querying layer that would work accross all integrations. We want to:Show a list of available metrics (numeric / aggregation fields) Display a list of available dimensions (text / group by fields) Users can add filters to available dimensions (matching criteria) Users can change the aggregation on metrics (sum, avg etc) Support for special datetime dimension which fetch data grouped by (hour, day, time, ..) We were thinking of building a dynamic SQL query builder to accomplish this. Before we proceed we wanted to ask the community if there is any best-practice OR previous experience regarding our use-case.  Thanks in advance !

2
C
1 month ago
Om D
Om DEmployee
asked in CData Connect Cloud

Connect Cloud Some Tables and Columns are missing and are not appearing

I am using Connect Cloud to pull some data but I am missing some Tables and Columns that exist in the data source.Where can I find them and what can I do to make sure that I am getting all of my data? 

1
Om D
1 month ago
Rick L
Rick LApprentice
posted in CData Connect Cloud

CData Connect for business users, thoughts?

I’m curious to hear how folks are using CData Connect, in particular on-prem in a business setting.  It seems one need we keep running across is that non-technical folks want to be able to download their data to Excel.  So often what they’ll do is have someone create a Tableau Dashboard and publish it to Tableau Server, but then they ignore the dashboard and go straight to the “Download” button to send the data to Excel.  But then because Tableau is inflexible they rarely like what Tableau gives them so they end up having to do a lot of manual work to get to what they really need.  I’m imagining that CData Connect could eliminate the middle man, so that if someone with enough SQL knowledge could define the SQL query, then it could be made available on CData Connect for anyone that has rights to access it and they could download the data that they need in the format they desire.  Other more technical folks might have the alternative of doing the same sort of thing using Toad or similar

2
H
1 month ago
E
Elizabeth GEmployee
asked in CData Drivers & Connectors

'Invalid Product Key' error after downloading new driver

I am a licensed customer and I just downloaded the latest version of a driver from the CData website. However, when I tried using my product key to license the new driver, I received an ‘Invalid Product Key’ error. My license should be valid and was working with the older version so I’m not sure why this is happening.

1
E
1 month ago
Lori
LoriEmployee
posted in CData Drivers & Connectors

Q2 Driver Tips of the Quarter

Whether you are a new or an existing customer using CData connectivity drivers, here are a couple of helpful tips.Tip #1:  Turn on logging Logging is a very valuable feature that helps support help you if you run into errors or issues.  There are four types of loggingBasic Logging – is a filepath that designates the name and location of the log file Log Verbosity – there are five levels of verbosity which determines the amount of detail in the log Sensitive Data – is found in verbosity levels 3 and higher and you may not want to share this information outside of your organization (see details in the article link below) Advanced Logging – is used to refine the exact information recorded in the log file (see details in the article link below)The logging options are basically the same for all editions (ADO.NET, ODBC, JDBC, SSIS, etc.)Here is a detailed technical logging article with definitions, and for turning on logging. Tip #2: Creating linked server connections using SQL Gateway with

0
Lori
1 month ago
L
Lance REmployee
asked in CData Drivers & Connectors

The configuration window for SSIS source component closes when I hit the parameter button

I'm using a CData SSIS source component within my data flow. The connection to the data source is working fine -- the problem is I can't define parameters for my SQL expression. I open the configuration editor for the source component and enter a SQL expression that contains a parameter (e.g., "Select * from Customer where Name = @param"). Then, when I hit the "Parameters" button, the configuration window suddenly closes.How do I get past this so I can define the parameter?I'm using Visual Studio 2022. 

1
L
1 month ago
A
Andrew HEmployee
asked in CData Drivers & Connectors

Could not find a valid license for using CData FireDAC Components for CSV on this system

“I updated Delphi and I am now receiving the following error during runtime: Could not find a valid license for using CData FireDAC Components for CSV on this system. Can you help me?” - Customer

1
A
1 month ago
Z
Zachary GEmployee
asked in CData Drivers & Connectors

I tried to use the embedded Xero credentials, but get a message about hitting a connection limit.

I was using the one of the CData Xero drivers, and followed the instructions to set up the connection using the credentials embedded in the driver, however, when I tried to verify the connection the following error occured: How should I change the connection to fix this?

1
Z
1 month ago
E
Elizabeth GEmployee
asked in CData Drivers & Connectors

"'https://cloud.cdata.com/api/catalogs' (404): Not Found" Power BI error

I’ve just downloaded one of the Power BI connectors, but I can’t get data with it because it’s throwing the error "'https://cloud.cdata.com/api/catalogs' (404): Not Found". How do I fix this?

1
E
1 month ago
P
preddyApprentice
posted in CData Drivers & Connectors

QB ODBC Driver

Hello CData Community, Do we have any folks who are using the QB ODBC Driver? Thanks,Pratik 

3
Ankit Singh
2 months ago

Badge winners

  • Product Expert
    AndyNhas earned the badge Product Expert
  • Product Expert
    wecanseeformileshas earned the badge Product Expert
  • Product Expert
    bdempseyhas earned the badge Product Expert
  • Product Expert
    RobNealhas earned the badge Product Expert
  • Product Expert
    Marchas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings