CData Connect Cloud

Share product questions and get support for CData Connect Cloud

  • 23 Topics
  • 29 Replies

23 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

2
H
11 months ago
S
SageApprentice
asked in CData Connect Cloud

How to contact SAge 50 Accounting Support 888/3OO-9183 @24*7(Toll-Free-Number)

Get expert help and support for Sage 50 Accounting Support (̲8̲8̲8̲)̲3̲0̲0̲-̲9̲1̲8̲3̲. Contact us for assistance with any issues or questions you may have. Sage 50 Accounting Help (̲8̲8̲8̲)̲3̲0̲0̲-̲9̲1̲8̲3̲ stands out as a popular choice among businesses of all sizes. However, even the best software can encounter issues, making reliable customer support indispensable for users.Understanding Sage 50 Accounting 888.3OO-9183Sage 50 Accounting support 888.3OO-9183 is a comprehensive software solution designed to streamline financial management for businesses. With features like invoicing, expense tracking, and payroll management, it offers significant benefits for users looking to optimize their accounting processes. Despite its many advantages, users may encounter various challenges while using Sage 50.The Importance of Customer Support 888.3OO-9183Customer support plays a crucial role in ensuring a smooth experience for Sage 50 users 888.3OO-9183. When issues arise, prompt resolution is

0
S
2 hours ago
R
Renukachari_KaseeCollaborator
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 Kaseerenukachari.kasee@redwood.com

1
Ethem Q
21 days ago
R
Renukachari_KaseeCollaborator
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.   

3
L
1 month ago
R
Renukachari_KaseeCollaborator
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.' 

7
Ethem Q
1 month 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?

2
Ankit Singh
1 month 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

1
John
2 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

1
A
2 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?

1
James T
3 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 :).

2
U
7 months 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  

3
A
7 months 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

0
Lori
7 months 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.

0
Lori
7 months 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

0
John
10 months 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
11 months 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
11 months ago
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

0
Lori
1 year ago
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? 

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

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

0
David Kleiss
1 year ago
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? 

1
R
1 year ago
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?

1
E
1 year ago
Om D
Om DEmployee
asked in CData Connect Cloud

Connect Cloud Missing Tables and Columns

I am trying to query my sources in CData Connect Cloud but they are running slow. They used to run instantly.What can I do to return to the speed the queries were running with?

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

Badge winners

  • Product Expert
    Sagehas earned the badge Product Expert
  • Product Expert
    Ruppiehas earned the badge Product Expert
  • Product Expert
    ekanshdhas earned the badge Product Expert
  • Product Expert
    jacob fhas earned the badge Product Expert
  • Product Expert
    skuchibhotlahas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings