Skip to main content

CData Connect Cloud

Share product questions and get support for CData Connect Cloud

  • 51 Topics
  • 61 Replies
51 Topics
Jerod
JerodCommunity Manager
posted in CData Connect Cloud
Connect your CData Connect Cloud account to your Snowflake account through Partner Connect

Snowflake users can now access CData Connect Cloud right from their Snowflake account and begin working with live Snowflake data using the applications and client tools they already use. Users can quickly create an account with a free trial of CData Connect Cloud and automatically configure a Snowflake connection to gain real-time bi-directional data integration from any cloud reporting, analytics, or business tool.Video TutorialWritten InstructionsIn Snowflake, click Data Products -> Partner Connect and search for "CData"   Review the permissions and click "Connect"   Click "Activate" to continue the activation   If you don’t have a CData Connect Cloud account, you will be asked to complete the sign-up process for a free trial.   Log into your Connect Cloud account and review your automatically configured connection (look for "Snowflake_PC_CDATA_DB" on the "Connections" page)  

280
Jerod
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Freshbooks object error while using ssis cdata drivers

Hi Ethem, i am able to connect freshbooks, except invoices object, all other objects are showing an error. kindly assist me on this. i am attaching an error image please check and suggest Thanks,Chari

392
R
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
unable to connect Freshbooks using Cdata SSIS component

Hi Team, i am unable to connect my freshbooks using Cdata connection kinldy share me the connection properties. in Freshbooks site there is an option to create app under that app all settings are attached as an attachment. please check and suggeset Thanks,Chari 

372
R
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
unable to view the data from customerinvocies view

Hi Ethem, i am unable to the data in customerinvoices object. any filters do we need to appliy kindly help me.i have attached the error images please check.. Thanks,Chari

613
Ethem Q
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Unable to schedule the CData SSIS job in sql server Agent job.

Hi Ethem Q,i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing with below error. kindly help me in this.. MessageExecuted as user: XXXXXXXXX\RKASEE. Microsoft (R) SQL Server Execute Package Utility  Version 15.0.2000.5 for 32-bit  Copyright (C) 2019 Microsoft. All rights reserved.    Started:  2:13:56 PM  Error: 2024-04-26 14:15:59.96     Code: 0xC0047062     Source: Workday_BankAccounts CData Workday Source [609]     Description: CData.SSIS.Workday.WorkdayException (0x80004005): [500] Request timed out. Either there is a server issue, or you've entered wrong credentials or wrong callback url. ---> jwo230k.Rx: Request timed out. Either there is a server issue, or you've entered wrong credentials or wrong callback url.     at jwo230k.FFZ.Ra(Rx )     at jwo230k.FFZ.pg(uNj )     at jwo230k.uPB.K(WP , uNd )     at jwo230k.uPB.G(WP , uT

1421
Ethem Q
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Unabale to see the user created workday views/datasets on CData SSIS connector

Hi Team, in workday SSIS cdata connector whatever my team has been created new views based on workday system datasets are not visible on views dropdown list. is there any permissions issue?  or user created views we will not see? kidnly Suggest. Thanks,Renukachari [email protected]

753
Ethem Q
James T
James TEmployee
asked in CData Connect Cloud
Does Connect Cloud support incremental refreshes in PowerBI?

I am importing some very large tables into PowerBI. Each time the data refreshes, the process gets slowed down since all of the data is getting requested/refreshed.Does Connect Cloud support updating/refreshing the data incrementally?

2443
James T
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Error from Workday SSIS connector extention question

Hi Ethem,thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attaching error image for your reference. and also one more is, please suggest how to get all the objects listed in workday, same like in sql server usually SELECT * FROM information_schema.Tables sintax used to get all objectssimilar kind of thing any sintax is it available in Workday? kidnly advise.   

1523
L
R
Renukachari_KaseeEnthusiast
asked in CData Connect Cloud
Error from Workday SSIS connector

Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise.“Invalid FROM clause starting with character: 6405. Invalid WQL syntax.”i am using below query from workday.select * from creditcardtransactionswhere "company_Prompt" = 'LE020 Redwood Software, Inc.' 

1087
Ethem Q
D
db_maverickApprentice
asked in CData Connect Cloud
Cassandra to MySQL Db migration is failing

Hi,I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.The migration job ran for 11 hours and then failed with below error:2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hen

901
A
D
db_maverickApprentice
asked in CData Connect Cloud
Db migration is failing for large tables : Cassandra to MySQL

Hi,I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.The migration job ran for 11 hours and then failed with below error:2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hen

991
A
James T
James TEmployee
asked in CData Connect Cloud
Can I schedule a refresh in PowerBI using CData Connect Cloud?

I am using CData Connect Cloud with PowerBI to access my data (Sage Intacct). Is there a way to configure a scheduled refresh? Is this even something that Connect Cloud supports?

2271
James T
U
ucetinApprentice
asked in CData Connect Cloud
File Connector: "*path* does not match any existing files or folders" error on cdata cloud

Hello! I am familiarizing myself with the tool and was trying to receive a file from a folder on my desktop and after processing it on CData Cloud, would send it into a different folder on my desktop. I’ve permitted sharing both input and output folders and put directories as “\\genericPcName\Users\genericPcName\Desktop\input” (\output for output). I’m coming across an error which reads the same on the title of my question. It would be awesome if anyone could assist on this matter, thanks in advance :).

1352
U
M
muthuEOLApprentice
asked in CData Connect Cloud
Exact online - QUERY_ABORTED -Error Fetching Results

Hi Team, Tried to fetch results from Exact online where it does not work properly for some divisions Exact online - QUERY_ABORTED -Error Fetching Results  

1143
A
Lori
LoriEmployee
posted in CData Connect Cloud
We are excited to share what’s new in Q3 2023 for CData Connect Cloud

What’s NewFive new data sources and four new client tools have been added and are now available in Connect Cloud! New Data Sources Act-On is a comprehensive marketing automation tool. Blackbaud Raisers Edge NX aka RE NXT, is a CRM system for nonprofit fundraising and constituent relationship management. TSheets is a cloud-based employee time-tracking and scheduling tool. Slack is a messaging app businesses use for communication and collaboration. Sage 200 is a cloud-connected financial and business management tool. New Client Tools Airbyte is an open-source ELT platform that securely syncs data from data sources to a data warehouse, data lake, or database. Nintex is an analytic and reporting suite with workflow and process automation. Outsystems is a low-code no-code development platform used to develop mobile and web enterprise applications that run in the cloud, on-premises, or hybrid environments. Polybase is a data virtualization tool that accesses and combines non-relational and r

950
Lori
Lori
LoriEmployee
posted in CData Connect Cloud
Q3 2023 Tip of the Quarter for Connect Cloud

Integrate Live Snowflake Data into Custom Business Apps Built-in Power Apps Snowflake's data platform is one of the top-performing leaders in data storage, processing, and analytics. CData Connect Cloud seamlessly integrates real-time Snowflake data into custom-made applications built in Microsoft Power Apps without replicating the data. The result is a streamlined and efficient user experience.This can be done in just a few steps.Connect to Snowflake in Connect Cloud Connect to Snowflake data from Power Apps Integrate live Snowflake data into the apps built-in Power AppsRead this knowledge base article for step-by-step instructions on how to do this.

430
Lori
A
Anonymous
posted in CData Connect Cloud
What Data Challenges Are You Facing? Let's Discuss in Our Upcoming Webinar!

Hello Everyone, We all know the power of Tableau in providing insights from our data. But have you ever struggled with inaccessible data across your tech stack? Or faced challenges when there is no built-in support from Tableau for your vital applications or data sources? We would love to hear about your experiences and how these challenges have impacted your work. Sharing these experiences can help us all learn and grow! To help address these issues, we're hosting a FREE WEBINAR on June 22nd at 11am EST, where we will introduce how Tableau & Tableau Cloud can be seamlessly integrated with our Data Connectivity-as-a-Service platform, CData Connect Cloud. This solution provides real-time access to hundreds of sources, without any need for coding or installation. CData's Sr. Technology Evangelist, Jerod Johnson, and Tableau Ambassador and Leader of the RDU Tableau User Group, Christopher Scott, will be joining us. They will not only discuss how Tableau and CData are transforming data

110
A
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

520
Lori
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? 

871
Om D
Lori
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

200
Lori
Lori
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? 

401
Lori
Lori
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?

611
Lori
David Kleiss
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.  

330
David Kleiss
R
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? 

2551
R
E
Elizabeth GEmployee
asked in CData Connect Cloud
Verification email missing

I can't find the verification email to verify my Connect Cloud account. It's not in my inbox, or in the Spam or Trash folders. How can I verify my account?

491
E
CData MCP Servers

Badge winners

Show all badges
Terms and ConditionsCookie settings