Skip to main content

CData Connect Cloud

Share product questions and get support for CData Connect Cloud

  • 33 Topics
  • 46 Replies
33 Topics
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

1542
H
1 year 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
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
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)  

210
Jerod
5 months ago
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

292
R
5 months ago
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 

292
R
5 months ago
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

553
Ethem Q
6 months ago
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

1101
Ethem Q
6 months ago
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]

673
Ethem Q
6 months ago
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?

1473
James T
6 months ago
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.   

1163
L
8 months ago
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.' 

947
Ethem Q
8 months ago
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

691
John
9 months ago
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

841
A
9 months ago
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?

1531
James T
10 months ago
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 :).

1072
U
1 year ago
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  

1043
A
1 year ago
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

890
Lori
1 year ago
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.

400
Lori
1 year ago
John
JohnCommunity Manager
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

80
John
1 year 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

470
Lori
1 year ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings