Solved

Hello, everyone! I am using a Power-Up called Amazing Fields on my Trello.With it, I can create custom fields, organize information in sections, and much more.However, I am facing difficulties loading the custom fields from Amazing Fields from my cards into the Google Sheets spreadsheet using Connect Spreadsheets.Has anyone experienced this or knows how to solve it?

Google now requires OAuth 2.0 to access Gmail, and my SSIS package had stopped working.I did quite extensive research, but still can’t figure out how to make my CData Gmail Connection Manager to access my company’s Gmail Inbox. Can someone please provide a guidance (ideally step-by-step) on how to make my SSIS package query the Gmail Inbox using either CData SSIS Components for Gmail or CData SSIS Components for Email.

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. 

Was trying to access the PricingGroup Table in Netsuite via SuiteQL and keep getting back this error: The query failed with the following error:\r\nUnable to retrieve columns for table [PricingGroup].Query for reference:  {    "query": "SELECT TOP 10 * FROM NetSuite7.Netsuite.PricingGroup"}I have been having this issue with several other tables and/or fields that just don’t seem to be accessible via SuiteQL. Another example is on the Item table I can’t return PurchaseUnit or StockUnit.  Why isn’t everything just available and query able in SuiteQL? 

Hi All,Sorry for the late response and recreating the  topic. The solution provide did to work as the heading info is no been added to the file. Not sure if this is because of the way I created the flows.   The file are received/collected from the FTP server and place into the folder on my server. Please would some assist with a possible solution. Thank you 

Hi.I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched.Here is my error: This is my CData PostgreSQL ODBC configuration:And this is my mysql remoting service configuration in CData SQL Gateway:This is my MySQL WorkBench connection configuration to the above “mysql remoting service”: How do I resolve this issue? Many thanks!

Hi,I have Sync version 24.3.9120.0 and I’m using Apache Kafka as source. It’s working fine, except little irritation. When I run task it will replicate only first 150 000 rows and stops after that. Next time I run the task, it replicates 179 000 rows and so on. Row count will increase. Seem to be randomI can run job multiple times and it will continue where it was stopped earlier. Is there way to change this behavior, so that all rows will be replicated at once?

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. 

When querying my data from SAP SF or running my package in SSIS, I’m getting the following error message: Get data error: [COE_SNAPSHOT_BAD_REQUEST] We have temporarily blocked the snapshot pagination request from companyUser Test |ODATA for all entities until Thu Mar 20 15:51:40 UTC 2025 because too many consecutive requests have been attempted without accessing subsequent data.

Since the update to Sync version 25.1.9207 we are getting some strange errors from different tasks.All these tasks worked without problems before the update.So far i have not found any difference (except for the tables) between tasks that work and that won’t work. It even fails on small datasets (19 in this example, a 16.000.000+ tasks works without problem)And the log also is not showing a lot of info:2025-03-25T12:34:16.494+0100    2    [ |Q-Id| T-Id]    [ |Q-Id]    [SQL |Bulk  ] 15 rows are being committed.2025-03-25T12:34:16.494+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Starting WriteToServer2025-03-25T12:34:16.494+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoke WriteToServer2025-03-25T12:34:16.508+0100    1    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoke WriteToServer is failed. null2025-03-25T12:34:16.508+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoking rollbackTransaction. 2025-03-25T12:34:16.509+0100    0    

In the coming days, I’m getting a new laptop with a qualcomm chip. The product I have is the CData Excel Add-In for QuickBooks Online 2021 (RNXGA) (Perpetual use). Will this product work on an ARM-based Windows device? Or will I need to find an alternate solution?

Hi, We have an XML file that contains a node called /Items/delivery_header/delivery_line_item/serial_numbers and in that node we have a list of serial numbers separated by commas if there is more than one (e.g. 1 serial would just be XYZABC but 2 or more would be XYZABC,XYZDEF). Is there a way on the destination XML to create a loop that can iterate through the comma separated values and create XML nodes like the following: for a single serial number SerialNumber      ManufacturerVersion = XYZABC or for multiple serial number SerialNumber      ManufacturerVersion = XYZABCSerialNumber      ManufacturerVersion = XYZDEF I have got as far as the below in the XML Map designer, I assume that I need to use a Loop with the nodes under it, but not sure what to use to split the values out, populate the ManufacturerVersion and then repeat with the next value:  Any help would be appreciated. Thanks, Anthony.

Hi All,I’m try to setup the flow that receives file from a FTP server in multiply folders  and then send an email with the subject containing the sub folder name. The flow I've create is as per  below In the  Navis, a script, connector I've added the below script however I keep receiving the below messageFormatter [ subfolder_path ] failed in the evaluation of [subfolder_path]. The error was: The value of the attribute could not be accessed: The attribute does not exist.please can anyone guid me to a better solution or why I’m receiving the message.<arc:script>  <arc:set attr="output.header:subfolder" value="[subfolder_path]" />  <arc:set attr="output.filepath" value="[filepath]" />  <arc:set attr="output.header:email" value="[email_address]" />  <arc:set attr="output.header:subject" value="[email_subject]" />  <arc:push item="output" /></arc:script>

When executing queries on either of the invoice or timeentry tables in the SuiteQL schema within your NetSuite connection, you may receive the following error, replacing <tablename> with the name of the table being queried:Unable to retrieve columns for table [<tablename>].This error may be encountered even when permissions are properly configured and when the connection is successfully tested. With this in mind, what should be done to work around the error?

Hi there.Is there a way of replicating data in batches.We are looking at a lambda approach with small incremental replication, followed up with a weekly full reload to catch late-arriving data and physical/hard deletes.The challenge is that the full reload data volumes are too large for the server hosting our CData Sync. Even with the JAVA heap adjustments.I was wondering if we could do the reload/replication in a looping process.  The source is Snowflake the target is Azure ADLS2 parquet files.

I am working with an incoming EDI file where I use lookaheads to identify the correct loop. In my case, the EDI file contains the Service Level Loop (HL/HL03='SS') appearing twice. While I can successfully extract the first occurrence using the following XPath:xpath("HLLoop1[HL/HL03='SS']/MSG/MSG01")I attempted to retrieve the second occurrence using:xpath("HLLoop1[HL/HL03='SS'][2]/MSG/MSG01")Although this expression did not return an error, it did not extract the expected data either. Has anyone encountered a similar issue? What would be the correct XPath expression to extract both occurrences of the Service Level Loop? Any insights or alternative approaches would be greatly appreciated!

Hi CDATA Team, There are many tables, views, and other database objects in the SAP application database. I wanted to check if the CDATA JDBC Driver aids in obtaining the filtered list based on SAP modules or an archive object, as it is quite difficult to identify tables based on any standard SAP module or standard archive object.I therefore want to retrieve the list of all tables and views that are utilized in, say, the FI module or FI_Documents, as part of my requirement. Is it possible to retrieve the table and view names from SAP HANA DB using the CDATA JDBC Driver based on SAP modules? Example:If you're querying an SAP table, you could specify a filter such as:SELECT * FROM "SAP_Material" WHERE "Module" = 'MM' Or, for archived objects, the query might look something like:SELECT * FROM "SAP_Archive" WHERE "ArchiveObject" = 'SomeArchiveObject' Thanks

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 the saved search (Accou

For the Email Send is there a solution for controlling the To: field dynamically with data coming into it from the workflow?Seems that Subject: and From: fields can be, but not much else. 

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

Looking for config details for the google sheets connector within DataVirtuality.  I’m getting the error below:  This app is blockedThis app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.

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’ve downloaded JDBC driver for MongoDB but when using it with the correct username password, it throws the error:Exception in thread "main" java.sql.SQLException: Failed to authenticate database 'testdb', Error code: [18] - "Authentication failed."..  Class.forName("cdata.jdbc.mongodb.MongoDBDriver"); Properties prop = new Properties(); prop.setProperty("Server","127.0.0.1"); prop.setProperty("Port","27017"); prop.setProperty("Database","testdb"); prop.setProperty("User","useradmin"); prop.setProperty("Password","welcome!"); Connection conn = DriverManager.getConnection("jdbc:mongodb:", prop); Statement stat = conn.createStatement(); boolean ret = stat.execute("SELECT name FROM users"); It throws error on the last line. These username password are correct and can be used in mongosh inside mongo server container

When trying to run an update with my CData SSIS Destination components, the job is failing with the following error: “The primary key must be specified to update a row”. What should I do to workaround this problem?

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?