Skip to main content

- - Knowledge base overview
Ideas
Updates
Events
Groups

Home
Community
Real-Time Connectivity

Real-Time Connectivity

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

212 Topics

Recently active

Most replies Most views Newest first

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.

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

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

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?

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 !

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?

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

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.

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

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

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

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?

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?

preddyApprentice

posted in CData Drivers & Connectors

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

Dave QApprentice

posted in CData Drivers & Connectors

CDepot - A Powerful Approach to Data Integration and Migration

Hello CData Community! I would like to share my experience with an approach to data integration and migration that has proven to be effective and efficient in my work. I call it the "CDepot," and I'm excited to see if any of you are interested in discussing this method or have had similar experiences using CData tools.The CDepot is a spoke-and-hub data integration system that utilizes CData connectors, continuous replication solutions like CData Sync, and a SQL Server backend. This approach allows for the seamless connection of various data sources and targets while maintaining data quality dimensions such as consistency, timeliness, and audibility.Key Points of the CDepot:Efficient data management through spoken-and-hub integration connecting various data sources and targets. Continuous replication with products like CData Sync, ensuring up-to-date data in the reporting repository. Non-persistent, perishable reporting repository for resilience and flexibility. Data transformations wit

Elizabeth GEmployee

asked in CData Drivers & Connectors

Cannot find QuickBooks Online data on reports

Can the QuickBooks Online driver pull data on Reports? I'm not seeing the Profit & Loss report, or any other reports, in the list of tables and views.

LoriEmployee

posted in CData Connect Cloud

Did you know that 37% of data collection is all you need to make an informed decision?

Like many of you I am driven by data and measured with metrics for success in my job. This type of measurement is highly dependent on the ability to obtain “enough” data to make meaningful recommendations or decisions to present to management without over analyzing. But what is enough data? You may agree with me that it is not always about the amount of data but the right data and enough of it to provide directional information to make a decision. For data minded people, our success relies on understanding what metric is the “ONE” that matters most that will tell our story and help us expose the right data that ultimately leads to the right decision. This viewpoint certainly will help you keep focused on the objective for a reporting assignment. So I googled the question, how much data is good enough to make a decision and the answer is 37% according to Dr. Norman Chorn. Refer to this Linkedin post from Dr. Norman Chorn for details (Linkedin account required.)In summary, Dr. Chorn refe

LoriEmployee

asked in CData Connect Cloud

What benefit does the PowerBI certification for CData Connect Cloud bring?

There are many other data connectors from other companies that connect with PowerBI. What benefit does the PowerBI certification for CData Connect Cloud bring?

LoriEmployee

asked in CData Connect Cloud

How do I create a derived view in Connect Cloud?

I often need to query on the same data for reporting. I heard that derived views can help me save a columnar view that contains the filtered tables and fields so I don’t have to build it everytime I need the information. How do I create a derived view?

David KleissEmployee

posted in CData Connect Cloud

Working with Live Couchbase Capella Data in Google AppSheet (Connect Cloud)

@Jamie F - Thought you would be interested in this one. CData Connect Cloud is the simplest way to connect Low-Code No-Code Apps like Microsoft PowerApps, Appsheet, Outsystems, Betty Blocks and Bubble to Couchbase Capella Data. The principals are the same as well for all of our supported Clients like Looker, PowerBI, QlikSense, SAP Analytics Cloud, Tableau, Amazon QuickSight, IBM Cognos Analytics, etc. Really any application, any data source can connect in real-time, as a service, through CData Connect Cloud.

prestonaEmployee

asked in CData Drivers & Connectors

Unable to see Views in WorkDay JDBC connection.

I just connected with the CData Workday JDBC driver and I am only able to see the Stored Procedures but no views. My connection string looks like this:jdbc:cdata:workday:User=myuser;Password=mypassword;Tenant=mycompany;Host=https://wd3-impl-services1.workday.com;What am I missing?

Kireet GEmployee

asked in CData Drivers & Connectors

Seeing Error message: "You need the 'Custom Body Fields' permission to access this page. Please contact your account administrator". While running tasks in ODBC Driver for NetSuite

Whenever I run a task in the CData ODBC Driver for NetSuite, I see an error message: “You need the 'Custom Body Fields' permission to access this page. Please contact your account administrator”.2023-01-24T09:48:52.070-06:00 1 [16|Q-Id] [META|Schema] Executed column schema query: [SalesOrder] Error: Permission Violation: You need the 'Custom Body Fields' permission to access this page. Please contact your account administrator.2023-01-24T09:48:52.070-06:00 1 [16|Q-Id] [META|Schema] Executed column schema query: [SalesOrder] Error: Permission Violation: You need the 'Custom Body Fields' permission to access this page. Please contact your account administrator.22023-01-24T09:48:52.277-06:00 1 [16|Q-Id] [INFO|Connec] Closed NetSuite connection

Elizabeth GEmployee

asked in CData Drivers & Connectors

User Defined Views missing from linked server

I created some User Defined Views for my ODBC driver, but when I use the driver with a linked server, I can’t find them anymore. Is there a way to access them?

Garrus BirdmanEmployee

asked in CData Drivers & Connectors

License error when using trial version of Salesforce ODBC driver on Linux

I am following the guide in “https://community.cdata.com/how-to-with-cdata-72/using-cdata-odbc-drivers-in-mac-linux-unix-environments-138” to try and install/configure the ODBC driver for Salesforce in our Dev Linux server. For the most part, the steps went smoothly. However, when I finally tried to query with the driver, I keep getting this error about needing a trial license: Could not find a valid license for using CData ODBC Driver for Salesforce 2022 on this system. To obtain a trial license, please visit www.cdata.com or email [email protected] [code: G nodeid: 5E1NWBN8].If you believe you already have a license, please check the following path(s):/opt/cdata/cdata-odbc-driver-for-salesforce/lib/CData.ODBC.Salesforce.lic, /home/garrusb/.cdata/CData.ODBC.Salesforce.lic. Shouldn’t the rpm package I used have installed this trial license already?

Rodrigo de AlbuquerqueEmployee

asked in CData Connect Cloud

Timeout Error in Connect Cloud

I’m facing a timeout error when executing queries to tables for a given connection in Connect Cloud. The error message is as follows: [ERROR] Execution of the SELECT query failed. Error: Timeout when wait response.I tried to increase the Timeout value in the connection Advanced Settings tab, but nothing changed. What should I do?

1
...
5
6
7
8
9

Page 8 / 9

Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Ockerthas earned the badge Product Expert
Origin-AnthonyRhas earned the badge Product Expert
ColdTrackTomhas earned the badge Product Expert
steven.hickshas earned the badge Product Expert
SusanBhas earned the badge Product Expert

Show all badges

Powered by Gainsight

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Log in

CData Community

Log in

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK