# Articles **URL:** https://community.cdata.com/c/articles/6.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Articles category](https://community.cdata.com/t/about-the-articles-category/1436)
**Author:** [@system](https://community.cdata.com/u/system)\ **Replies:** 0\ **Last updated:** [October 21, 2026, 3:35pm UTC](https://community.cdata.com/t/about-the-articles-category/1436 "2026-10-21T15:35:16Z")
Knowledge Base --- ## [Update a Google Calendar with a Microsoft Access Linked Table](https://community.cdata.com/t/update-a-google-calendar-with-a-microsoft-access-linked-table/70)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 4\ **Last updated:** [April 7, 2026, 3:51pm UTC](https://community.cdata.com/t/update-a-google-calendar-with-a-microsoft-access-linked-table/70 "2026-04-07T15:51:01Z")
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 sharin… --- ## [Seamless Integration & Monitoring between CData Sync and ELK stack](https://community.cdata.com/t/seamless-integration-monitoring-between-cdata-sync-and-elk-stack/975)
**Author:** [@Aleksander\_P](https://community.cdata.com/u/Aleksander_P)\ **Replies:** 0\ **Last updated:** [December 18, 2024, 4:34pm UTC](https://community.cdata.com/t/seamless-integration-monitoring-between-cdata-sync-and-elk-stack/975 "2024-12-18T16:34:42Z")
Table of Contents Introduction Overview of CData Sync Overview of ELK stack Why integrate CData Sync with ELK stack? Prerequisites Setting up CData Sync Deploying ELK stack Integrating CData Sync logs with ELK stack … --- ## [Automating Real-Time Data Pipelines using CData JDBC Drivers](https://community.cdata.com/t/automating-real-time-data-pipelines-using-cdata-jdbc-drivers/974)
**Author:** [@Manikandan\_Palanisamy](https://community.cdata.com/u/Manikandan_Palanisamy)\ **Replies:** 0\ **Last updated:** [December 18, 2024, 4:21pm UTC](https://community.cdata.com/t/automating-real-time-data-pipelines-using-cdata-jdbc-drivers/974 "2024-12-18T16:21:59Z")
Data integration and automation have become crucial for businesses that rely on seamless data flows between different platforms. In this article, we’ll walk you through building and automating a real-time data pipeline … --- ## [Create Custom reports on Sage Intacct and use them on Power BI via Connect Cloud](https://community.cdata.com/t/create-custom-reports-on-sage-intacct-and-use-them-on-power-bi-via-connect-cloud/916)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [October 16, 2024, 1:45pm UTC](https://community.cdata.com/t/create-custom-reports-on-sage-intacct-and-use-them-on-power-bi-via-connect-cloud/916 "2024-10-16T13:45:20Z")
Sage Intacct is a cloud-based financial management platform used for automating accounting processes, managing core financials, and providing real-time financial reporting and insights for businesses. Custom reports in … --- ## [CData Connect Cloud Jobs (Caching)](https://community.cdata.com/t/cdata-connect-cloud-jobs-caching/877)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [July 30, 2024, 1:59pm UTC](https://community.cdata.com/t/cdata-connect-cloud-jobs-caching/877 "2024-07-30T13:59:17Z")
The Jobs feature, formerly known as the Caching feature, is a key component of CData Connect Cloud. It allows users to select tables for caching, saving them to a PostgreSQL database. Once the tables are selected, CData … --- ## [Getting error in Integrating CData JDBC connector in Talend Cloud Data Management Studio Version: 8.0.1 / Build id: R2024-04 or later](https://community.cdata.com/t/getting-error-in-integrating-cdata-jdbc-connector-in-talend-cloud-data-management-studio-version-8-0-1-build-id-r2024-04-or-later/863)
**Author:** [@AnkitK](https://community.cdata.com/u/AnkitK)\ **Replies:** 0\ **Last updated:** [July 17, 2024, 10:25am UTC](https://community.cdata.com/t/getting-error-in-integrating-cdata-jdbc-connector-in-talend-cloud-data-management-studio-version-8-0-1-build-id-r2024-04-or-later/863 "2024-07-17T10:25:32Z")
After upgrading Talend Cloud Data Management Studio to version 8.0.1 (Build ID: R2024-04) or later, the user may encounter the error below. Error: Exception in thread "main" java.lang.ExceptionInInitializerErrorat org.t… --- ## [Running an Application (.exe File) Post Job Completion in CData Sync](https://community.cdata.com/t/running-an-application-exe-file-post-job-completion-in-cdata-sync/808)
**Author:** [@Aman\_Shetty](https://community.cdata.com/u/Aman_Shetty)\ **Replies:** 0\ **Last updated:** [July 1, 2024, 10:03am UTC](https://community.cdata.com/t/running-an-application-exe-file-post-job-completion-in-cdata-sync/808 "2024-07-01T10:03:41Z")
CData Sync is a powerful data integration tool, enabling seamless synchronization between various data sources. One handy feature is the ability to run a Windows application or an .exe file after job completion through p… --- ## [Performing Hard Delete in CDC Job Type](https://community.cdata.com/t/performing-hard-delete-in-cdc-job-type/802)
**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\ **Replies:** 0\ **Last updated:** [June 26, 2024, 5:51am UTC](https://community.cdata.com/t/performing-hard-delete-in-cdc-job-type/802 "2024-06-26T05:51:55Z")
Change Data Capture (CDC) is a job type in Sync where supported data sources use a log file to record events (Insert, Update, or Delete) that alter the database. Instead of querying the source table for changes, CData Sy… --- ## [Integrate CData Power BI Connector for SAP HANA with SAP Datasphere:](https://community.cdata.com/t/integrate-cdata-power-bi-connector-for-sap-hana-with-sap-datasphere/799)
**Author:** [@VikasAgarwal](https://community.cdata.com/u/VikasAgarwal)\ **Replies:** 0\ **Last updated:** [June 25, 2024, 2:42pm UTC](https://community.cdata.com/t/integrate-cdata-power-bi-connector-for-sap-hana-with-sap-datasphere/799 "2024-06-25T14:42:51Z")
This article covers required configuration of both SAP Datasphere and the CData Power BI Connector for SAP HANA, to make the two successfully integrated. The steps to accomplish this integration are listed below. Co… --- ## [How to run the Sync API endpoints using the C# code](https://community.cdata.com/t/how-to-run-the-sync-api-endpoints-using-the-c-code/784)
**Author:** [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\ **Replies:** 0\ **Last updated:** [June 17, 2024, 6:06pm UTC](https://community.cdata.com/t/how-to-run-the-sync-api-endpoints-using-the-c-code/784 "2024-06-17T18:06:23Z")
Running CData Sync API endpoints using C# code is a powerful way to manage your data transformation and synchronization tasks. This can be accomplished within the Microsoft Visual Studio environment, using an ASP.NET Cor… --- ## [Disabling Data Virtuality ports](https://community.cdata.com/t/disabling-data-virtuality-ports/760)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 4:06pm UTC](https://community.cdata.com/t/disabling-data-virtuality-ports/760 "2024-06-10T16:06:28Z")
A common scenario is for companies to always require encrypted connections (TLS/SSL) to Data Virtuality and prevent insecure connections (non-TLS/non-SSL). \* Data Virtuality has TLS and non-TLS ports for connectivit… --- ## [Recommended firewall settings for an on-premise installation of Data Virtuality](https://community.cdata.com/t/recommended-firewall-settings-for-an-on-premise-installation-of-data-virtuality/759)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 4:04pm UTC](https://community.cdata.com/t/recommended-firewall-settings-for-an-on-premise-installation-of-data-virtuality/759 "2024-06-10T16:04:05Z")
Recommended firewall settings for ports used by Data Virtuality Server. Name in dvserver-standalone.xmlPortPrivate networkPublic networkDescriptionUsed by Data Virtuality StudioNecessary for DV to start jboss.socket.bi… --- ## [Partitioning Tables in BigQuery](https://community.cdata.com/t/partitioning-tables-in-bigquery/758)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 3:58pm UTC](https://community.cdata.com/t/partitioning-tables-in-bigquery/758 "2024-06-10T15:58:01Z")
If you use BigQuery, especially for large amounts of data, you can optimize your work by partitioning your tables - that is, dividing them into smaller segments. This helps to improve query performance and reduce costs b… --- ## [Connecting C# via ADO.NET](https://community.cdata.com/t/connecting-c-via-ado-net/757)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 3:53pm UTC](https://community.cdata.com/t/connecting-c-via-ado-net/757 "2024-06-10T15:53:02Z")
his is a short example showing how to connect to Data Virtuality from C# using the Npgsql - an open source ADO.NET Data Provider for PostgreSQL. Prerequisites Install the Npgsql using the NuGet Package Manager in Visu… --- ## [Understanding Log Files – CData Connect Cloud](https://community.cdata.com/t/understanding-log-files-cdata-connect-cloud/745)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 2:14pm UTC](https://community.cdata.com/t/understanding-log-files-cdata-connect-cloud/745 "2024-06-05T14:14:28Z")
About CData Connect Cloud log files CData Connect Cloud offers a detailed logging system that is essential for monitoring and troubleshooting the interactions with the cloud data connectivity service. The logs are divid… --- ## [Deploy CData SSIS Components on Azure Data Factory](https://community.cdata.com/t/deploy-cdata-ssis-components-on-azure-data-factory/78)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 1\ **Last updated:** [May 10, 2024, 10:54pm UTC](https://community.cdata.com/t/deploy-cdata-ssis-components-on-azure-data-factory/78 "2024-05-10T22:54:39Z")
Azure Data Factory is a scalable, trusted, cloud-based solution for building automated data integration solutions with a visual, drag-and-drop UI. Moving on-premises SSIS workloads to Azure can reduce the operational cos… --- ## [Migrating CData Sync from the .NET Edition to the Cross-Platform Edition](https://community.cdata.com/t/migrating-cdata-sync-from-the-net-edition-to-the-cross-platform-edition/713)
**Author:** [@SusanB](https://community.cdata.com/u/SusanB)\ **Replies:** 0\ **Last updated:** [May 10, 2024, 6:26pm UTC](https://community.cdata.com/t/migrating-cdata-sync-from-the-net-edition-to-the-cross-platform-edition/713 "2024-05-10T18:26:18Z")
Starting with Sync 2024, the .NET edition of the application is deprecated. As a result, users need to migrate their current .NET edition of Sync to the Cross-Platform edition. Follow these steps to perform this migratio… --- ## [Understanding Log Files – CData Arc](https://community.cdata.com/t/understanding-log-files-cdata-arc/702)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [April 25, 2024, 2:49pm UTC](https://community.cdata.com/t/understanding-log-files-cdata-arc/702 "2024-04-25T14:49:35Z")
About CData Arc log files CData Arc, a comprehensive B2B integration application, maintains logs for a multitude of activities. These activities encompass Messages, Transactions, Application requests, Access requests, a… --- ## [Creating the RDS instance for PostgreSQL using the IAM Authentication](https://community.cdata.com/t/creating-the-rds-instance-for-postgresql-using-the-iam-authentication/701)
**Author:** [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\ **Replies:** 0\ **Last updated:** [April 25, 2024, 2:47pm UTC](https://community.cdata.com/t/creating-the-rds-instance-for-postgresql-using-the-iam-authentication/701 "2024-04-25T14:47:12Z")
In cloud computing, managing databases efficiently and securely is paramount. One such method involves creating an Amazon RDS instance for PostgreSQL using IAM Authentication. This process allows users to leverage the ro… --- ## [Data Virtualization, Reimagined - On-demand (video playlist)](https://community.cdata.com/t/data-virtualization-reimagined-on-demand-video-playlist/668)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 15, 2024, 4:10pm UTC](https://community.cdata.com/t/data-virtualization-reimagined-on-demand-video-playlist/668 "2024-03-15T16:10:20Z")
Learn why a new approach to data virtualization is needed to remove the biggest bottleneck faced by modern data teams. IT leaders: Watch to learn how to think about this new approach to data virtualization within your … --- ## [Understanding Log Files – CData Sync](https://community.cdata.com/t/understanding-log-files-cdata-sync/658)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 11, 2024, 4:23pm UTC](https://community.cdata.com/t/understanding-log-files-cdata-sync/658 "2024-03-11T16:23:09Z")
About CData Sync log files The CData Sync application keeps track of its operations through a comprehensive Job History table, documenting the outcomes of each executed task. Beyond just maintaining a job history, Sync r… --- ## [Setting up account impersonation for a Microsoft Exchange Online data source](https://community.cdata.com/t/setting-up-account-impersonation-for-a-microsoft-exchange-online-data-source/641)
**Author:** [@Theo](https://community.cdata.com/u/Theo)\ **Replies:** 0\ **Last updated:** [February 26, 2024, 5:56pm UTC](https://community.cdata.com/t/setting-up-account-impersonation-for-a-microsoft-exchange-online-data-source/641 "2024-02-26T17:56:18Z")
Microsoft Exchange, like other Microsoft services, allows accounts to impersonate other users to collect data. This functionality is often used for service accounts, so that they can work to access data in the background… --- ## [CData Sync – HTTPS endpoint connectivity enablement (Linux)](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-linux/639)
**Author:** [@Aleksander\_P](https://community.cdata.com/u/Aleksander_P)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 2:28pm UTC](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-linux/639 "2024-02-23T14:28:51Z")
There are several data sources (Workday, Google BigQuery) that require HTTPS connectivity, in order to define a successful source/destination connection within CData Sync. By default, Sync is installed as HTTP web ser… --- ## [CData Sync – HTTPS endpoint connectivity enablement (Windows)](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-windows/638)
**Author:** [@Aleksander\_P](https://community.cdata.com/u/Aleksander_P)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 2:19pm UTC](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-windows/638 "2024-02-23T14:19:39Z")
There are several data sources (Workday, Google BigQuery) that require HTTPS connectivity, in order to define a successful source/destination connection within CData Sync. By default, Sync is installed as HTTP web serve… --- ## [Understanding CData Log Files – Drivers](https://community.cdata.com/t/understanding-cdata-log-files-drivers/634)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [February 20, 2024, 11:06pm UTC](https://community.cdata.com/t/understanding-cdata-log-files-drivers/634 "2024-02-20T23:06:57Z")
About CData Driver Log Files CData Driver log files capture communications between client applications and data sources, providing valuable information for troubleshooting error messages or addressing unexpected behavio… --- ## [CData Connect Cloud: Using User-Defined Credentials with Snowflake](https://community.cdata.com/t/cdata-connect-cloud-using-user-defined-credentials-with-snowflake/568)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [December 14, 2023, 4:45pm UTC](https://community.cdata.com/t/cdata-connect-cloud-using-user-defined-credentials-with-snowflake/568 "2023-12-14T16:45:06Z")
Query Users (Connect Cloud users with permissions to query connections, but not manage them) can inject their own credentials into connections. Administrators can configure Connections to use Shared Credentials or User C… --- ## [CData Sync: Configuring the API Connector](https://community.cdata.com/t/cdata-sync-configuring-the-api-connector/489)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [October 25, 2023, 3:12pm UTC](https://community.cdata.com/t/cdata-sync-configuring-the-api-connector/489 "2023-10-25T15:12:56Z")
​The API Connector in CData Sync lets you connect to any API (on-premises or cloud-based) that produces XML or JSON data. This means that you can replicate data from custom or proprietary APIs from your preferred tools a… --- ## [Accessing Harvest Time Tracking Data from Anywhere](https://community.cdata.com/t/accessing-harvest-time-tracking-data-from-anywhere/456)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [October 11, 2023, 5:58pm UTC](https://community.cdata.com/t/accessing-harvest-time-tracking-data-from-anywhere/456 "2023-10-11T17:58:59Z")
The API Connector in CData Connect Cloud lets you connect to any cloud-based API that produces XML or JSON data. When paired with the Harvest Time Tracking service API, customers can access Harvest data from their favori… --- ## [CData Sync: Using Transformations to JOIN Data After Replications (in SQL Server)](https://community.cdata.com/t/cdata-sync-using-transformations-to-join-data-after-replications-in-sql-server/429)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [October 3, 2023, 1:55pm UTC](https://community.cdata.com/t/cdata-sync-using-transformations-to-join-data-after-replications-in-sql-server/429 "2023-10-03T13:55:19Z")
Data transformations are often the most complex and costly part of an ETL and ELT process. They can vary from simple data conversions to extremely complex data aggregating techniques. Enterprises use data warehouses to a… [Next page](https://community.cdata.com/c/articles/6.md?page=1)