- - Knowledge base overview
Ideas
Updates
Events
Groups

Home
Community
Real-Time Connectivity
CData Connect Cloud

CData Connect Cloud

Share product questions and get support for CData Connect Cloud

33 Topics
45 Replies

When you subscribe we will email you when there is a new topic in this category

33 Topics

Recently active

Most replies Most views Newest first

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

1 year ago

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

4 days ago

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

4 days ago

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 ?

18 days ago

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 ?

1 month ago

JerodCommunity Manager

posted in CData 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

1 month ago

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

2 months ago

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)

3 months ago

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

3 months ago

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

3 months ago

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

4 months ago

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

4 months ago

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]

4 months ago

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?

4 months ago

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.

5 months ago

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.'

6 months ago

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

7 months ago

db_maverickApprentice

asked in CData Connect Cloud

Db migration is failing for large tables : Cassandra to MySQL

7 months ago

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?

8 months ago

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 :).

1 year ago

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

1 year ago

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

1 year ago

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.

1 year ago

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

1 year ago

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

1 year ago

Page 1 / 2

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

Badge winners

leoarthurhas earned the badge Product Expert
loisine.ann.mendozahas earned the badge Product Expert
ella.eviohas earned the badge Product Expert
Ockerthas earned the badge Product Expert
Origin-AnthonyRhas earned the badge Product Expert

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

CData Community

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.

This file cannot be downloaded

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