Recently active topics

HiI’m getting the above error “[x:ic] System error : No such host is known” when trying to debug a DTS package in visual studio.I’ve check the Organisation URL and all other settings are correct against production, which is working fine. I’ve also connected to the same host using a different application on my machine, so I don’t think it’s a firewall issue. I’ve tried Visual Studio 2022 and 2026.Is there anywhere I can get more details on the error, or has anyone come across this before?Thanks

We are working on various solutions to incrementally replication Epicor data.  The challenge is Epicor does not allow cdc and while some tables have fields indicating last change date and another one for time but it is not consistent.  We attempted to create a trigger solution to capturing any time a row changed but this would cause deadlocks and system performance issues.  Epicor also has a trigger option but this will cause significant performance issues on the front end.  Our last resort maybe to replicate the server and set up cdc on the replicated server.  While viable there has to be a better solution than this and I thought maybe someone could help me here.

I am trying to upgrade from to the latest version 2025. When I start my job, I get the following error message “Could not get the allow dB amp to run remotely registry setting”. It does seem we have this particular registry setting that might be different from others.  

Hi Everyone, I am Dheeraj Sudan , a UK-based software developer. I’m running into OAuth token authentication errors when trying to connect GA4 and a few APIs through CData. I’ve double-checked my client ID, secret, and redirect URIs, but the connection still fails. Has anyone experienced this before? Any tips or steps to troubleshoot and fix these authentication issues would be greatly appreciated! RegardsDheeraj Sudan and Meenu Hinduja 

Microsoft is retiring the built-in Salesforce connector in Access, which may disrupt existing workflows and break live connections to Salesforce data.To maintain connectivity, teams can switch to ODBC-based solutions like CData, allowing them to continue using their existing Access queries, reports, and applications with minimal changes.In this article, you’ll learn how to:Understand the impact of the connector discontinuation Maintain Access workflows without disruption Replace the built-in connector with a CData solution Restore live Salesforce connectivityTo learn more, read:How to Keep Microsoft Access Working After the Salesforce Connector Discontinuation

Hello communityI am trying to use GA4 (Google Analytics 4) connector to Tableau.The problem I`m facing is: I create the connections to GA4 properties. I save the Tableau Prep file. I could download it locally ad a .csv without a problem. When I close the software and open it again (I`m trying it in the Desktop version), there is the following error in the GA4 connections:“Error in input “properties/446731XXXX”. An error occurred while communicating with Google Analytics 4 Tableau needs an unexpired OAuth refresh token to connect to the data. Authorize refresh tokens or ask the data source owner for help. Connector Class: google_analytics_4, Version: 1.2.1”If I click on “Edit” in the data source, it makes me connect to GA4, which is ok, but then it is like recreating the connection again: chose a GA4 account, chose a GA4 property, select the dimensions, select the metrics … and I assume redoing all the filters etc. The error is in the attached screenshot. Has anyone experienced this iss

Just discovered CData Connect Spreadsheets when searching for a way to get Google Calendar information into Excel. Looks very good.However, when test-driving the software, I run into an issue.I have a primary calendar under my Google Workspace account [removed by moderator] . In addition, I have created multiple secondry calendars for various purposes.I've successfully connected the addin to my account, including successful authentication. When I start the Import process, I can select the configured connection, and the Table list populates with all available tables, including all calendars. When I select one of the secondary calendars, such as 'Placeholders' or 'Flags', the column list is loaded, the generated query is created, and the Execute/Reset buttons become available (see 2nd screenshot). When I hit Execute, the Excel list is populated with data from the selected calendar. All as expected.But when I select my primary calendar [removed by moderator] , none of that happens. The

CData ODBC drivers connect your data to any database management tool that supports Open Database Connectivity (ODBC). This includes many of the most popular productivity tools, adding new capabilities for document sharing and collaboration. Using the CData ODBC driver for Google Calendar, you can update live Google data in Microsoft Access; for example, you can make updates to a calendar that can instantly be seen by other users.Create a Google DSNIf you have not already, you will need to save Google connection properties in a data source name (DSN). Microsoft Access will use the DSN to connect. You can create and configure a DSN in the Microsoft ODBC Data Source Administrator. For a guide to set the required properties in the ODBC Data Source Administrator, see the "Getting Started" section in the help documentation.Create a Linked Table to Google Calendar EventsFollow the steps below to create a linked table to Google Calendar Events.In Access, click New Data Source > From Other S

Migrating to cloud ERPs like Acumatica, NetSuite, or Business Central often removes direct SQL access, disrupting Microsoft Access-based workflows many finance teams rely on.Since SaaS ERPs use API-only architectures, traditional database connections no longer work. CData ODBC Drivers bridge this gap by enabling seamless connectivity from Access to cloud ERP data without major changes to your existing files or queries.In this article, you’ll learn how to:Navigate the shift from SQL to API-based ERP systems Maintain Access workflows after cloud migration Connect Access to cloud ERP data using CData ODBC Drivers Continue using existing queries with minimal modificationsTo learn more, read:How to Keep Microsoft Access Working After an ERP Cloud Migration