CData Connect AI

I am trying to setup Connect Spreadsheets to Sage One (renamed to Sage Business Cloud Accounting) but when I want to setup the authentication via the basic setup I don’t get South Africa as a region and can therefor not authenticate to our company in Sage. Any assistance would be appreciated. 

Hi Community!I’m trying to create a source to sharepoint where we can navigate to a specific file saved on the sharepoint location and open the contents of a csv or xlsm file. Is this possible? I have the sharepoint connection created using AzureAD authentication method. Using a query such as this:  SELECT * FROM [Sharepoint_testing].[REST].[Financial Models] where Name like '%.xlsm%' I can get the various file names contained in the Sharepoint location, and see things like file size, modify date, etc. At this point, I can’t figure out how to use the file name retrieved and then query it to get at the contents of it… any help with this?  TIA for the assist, i appreciate it. 

CData Connect AI offers a pure cloud-to-cloud interface for your data, enabling the creation of business applications directly from live data within Appsmith. In Connect AI , you can create connections from 300+ sources, and then connect to that data in Appsmith using Connect Cloud’s Virtual SQL Server. The article below outlines the process of connecting to a data source in Connect AI and creating a basic application from that data within Appsmith:https://www.cdata.com/kb/tech/salesforce-cloud-appsmith.rstNote: While this article refers to Salesforce, the principles can be applied to any of the 300+ data sources CData Connect AI supports.

I created a custom report that we’re using as a source in a Power BI semantic model. The intent is that our financial controller developed the Saved Search in Netsuite to grab the transactions desired. With that as a data source, we should be able to reconcile pretty quickly and shouldn’t see variances between the Saved Search results in Netsuite and the data pulled in Connect AI - however that’s not the case.Initially this data exclusion seemed to be limited to Credit Card transactions - a relatively small number, around 3000 rows. I created a work-around to get the transactions into our data model, but i’m encountering the issue again with transactions that seem to be standard Journal Entries. My initial through was perhaps this was a permissions issue and maybe the access token created uses a restricted account - when i set it up it was the first time, i didn’t really know what i was doing, etc… SO i created a new token using the Netsuite account I use to run t

Hi Team, I am trying to run this query in CDATA through powerautomate but its not producing any results but with some other divisons it producing results strange issue.please guide me on this  SELECT GLAccountCode,MIN(FinancialYear) AS LeastFinancialYear,MAX(FinancialYear) AS HighestFinancialYearFROM [ExactOnline1].[11111111.[TransactionLines]GROUP BY GLAccountCode

Greetings,I am in the process of creating an advice report to a corporate client who is interested if CData Connect Spreadsheet is a right tool for her needs.The following features are required:Load data from multiple backend Excel spreadsheets to a report sheet in Excel. Update the report sheet and push updates to the backend sheets if needed. Create joins using backend spreadsheets and display them in the report in Excel.  Joins should be created in GUI without using SQL queries. Do you think these objectives can be effectively achieved using CData add-in for Excel? Thanks,Eugene

I am using CDATA Connect AI with a virtual SQL server to connect to Exact Online. I have two requirements related to data tracking and retrieval: Tracking Classification Code Changes: I need to track any changes or modifications made to the Classification Codes in Exact Online. Specifically, I want to retrieve all rows where changes have occurred in the Classification Codes. Request: Could you provide a SQL query to fetch rows with any modifications or changes in the Classification Codes? Retrieving Division-Associated GL Account Codes: I need to retrieve the GL Account Codes associated with each Division in Exact Online. Request: Could you provide a SQL query to fetch the Division-associated GL Account Codes?

 We are excited to share that this week scheduled queries are available to all Connect AI accounts! With Scheduled Queries, you can automatically write data to a variety of supported destinations based on a schedule you set. Using either our Query Builder, or by writing your own custom SQL queries, ensure your data is up to date when needed in the destination of your choice. The following destinations are currently supported: BigQuery Databricks PostgreSQL Redshift Smartsheet Snowflake Try it out in the Data Explorer in Connect AI today!Learn more in the blog: 

Hello!  If you are on a free Spreadsheets plan every month you are receiving an email that states you may need to update your billing information.  Remember that your subscription is FREE and that you are not required to have payment details on file. However, due to regulations we need to send out a reminder that you are on an auto renewal and we have our emails worded the same for all our renewal emails if you are paying or not at this time.  Sorry if it has confused you. 

I’ve got something stumping me… In Connect AI, i set up a custom report to use a NetSuite Saved Search. When executing the Saved Search in NS, the results display fine and as expected. When i use Connect AI to call the Saved Search - it displays the columns properly prior to execution, but the execution results show 0 rows. in NS, there are a total of 1935 rows.  I’m not sure what barrier lies between the Saved Search and the Connect AI custom report results - but something between those two seems to be preventing the results from coming into Connect AI. What should I check?

Hello Connect Spreadsheets community!  What kinds of reports are you connecting data to and building in Excel and Google Sheets using Connect Spreadsheets? We are looking for feedback and ideas of what reports we can standardize to come prebuilt in templates, ready to fill with data, in Connect Spreadsheets, to make it easier for users to get the report they want. Whether it’s P/L statements, sales reports, or something else, let us know and your idea may be chosen to make building your reports easier!

 Q: How do I install Connect Spreadsheets? Select your preferred spreadsheet, where you’ll be directed to install the add-in for Google Sheets or Excel in their add-in marketplaces. Then, open your spreadsheet and launch Connect Spreadsheets. You’ll be prompted to sign up for a Connect Spreadsheets account. Finally, sign in and start connecting data to your spreadsheet.  Q: Is there a free trial? All accounts start on a 15-day free trial of the unlimited Pro plan. Purchase a paid plan before your trial ends to convert automatically and never lose access to the unlimited benefits of Connect Spreadsheets.  Q: What are the limits if I stay on the free plan? Continue to use Connect Spreadsheets free forever, no credit card required, but after your 15-day free trial you’ll be limited to only 5,000 records per query, 1 user, 3 data sources, and 50 total queries per month. Upgrade to a paid plan to connect data with more users, remove

Introducing Connect Spreadsheets, CData’s latest offering for effortless data access in Excel and Google Sheets. What is Connect Spreadsheets? Connect Spreadsheets is a free tool that connects your spreadsheets to data from 250+ sources without any of the usual hassle. Instead of exporting and copying data manually, simply connect once and access fresh data with a click or on a set schedule. No coding is needed, and it’s available right now on Google Workspace Marketplace and Microsoft AppSource. Who is it for? Connect Spreadsheets is for anyone who works in Google Sheets or Excel and needs live data without the extra steps of downloading, importing, or reformatting. Fro

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 connect ai

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

Powered by CData is a way for customers to integrate CData Connect AI 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 AI. 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

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  

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

I am using Connect AI 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? 

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

I’m facing a timeout error when executing queries to tables for a given connection in Connect AI. 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? 

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

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