# How-to with CData **URL:** https://community.cdata.com/c/articles/how-to-with-cdata/37.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the How-to with CData category](https://community.cdata.com/t/about-the-how-to-with-cdata-category/1467)
**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-how-to-with-cdata-category/1467 "2026-10-21T15:35:18Z")
Best practices and helpful tips to help you make the most of your CData solutions. --- ## [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 … --- ## [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 … --- ## [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… --- ## [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… --- ## [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… --- ## [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: 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… --- ## [SSAS: Tabular and Multidimensional Models](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 22, 2023, 3:07pm UTC](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412 "2023-09-22T15:07:37Z")
SQL Server Analysis Services (SSAS) allows you to build both tabular and multidimensional models. Tabular models support the relational model (model, tables, columns) of most data sources. Multidimensional models are Onl… --- ## [How to Setup Verbose logging for Jobs in CData Sync](https://community.cdata.com/t/how-to-setup-verbose-logging-for-jobs-in-cdata-sync/247)
**Author:** [@Eric\_P](https://community.cdata.com/u/Eric_P)\ **Replies:** 0\ **Last updated:** [July 11, 2023, 7:49pm UTC](https://community.cdata.com/t/how-to-setup-verbose-logging-for-jobs-in-cdata-sync/247 "2023-07-11T19:49:55Z")
When asking for assistance through our support email support@cdata.com, Sync support engineers will sometimes require Verbose logs from the jobs that you are running. Verbose logs display more information about the sour… --- ## [CData Podcasts](https://community.cdata.com/t/cdata-podcasts/227)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [June 30, 2023, 12:09pm UTC](https://community.cdata.com/t/cdata-podcasts/227 "2023-06-30T12:09:04Z")
On JOIN, we explore innovations, trends and real-life case studies with leaders and disruptors throughout the world of data — from data integration, architecture, and management to BI & analytics, AI, and more. A… --- ## [CData Arc Quick Tip of the Quarter: Using the Arc Vault](https://community.cdata.com/t/cdata-arc-quick-tip-of-the-quarter-using-the-arc-vault/170)
**Author:** [@Matt\_S](https://community.cdata.com/u/Matt_S)\ **Replies:** 2\ **Last updated:** [May 19, 2023, 4:35pm UTC](https://community.cdata.com/t/cdata-arc-quick-tip-of-the-quarter-using-the-arc-vault/170 "2023-05-19T16:35:39Z")
This quarter’s quick tip centers around the Arc Vault, a feature that enables storing and referencing values for simpler and more secure configuration. Why Use It Here are a few cases in which the Vault is helpful: Sa… --- ## [Deploying CData Sync in a Kubernetes Environment](https://community.cdata.com/t/deploying-cdata-sync-in-a-kubernetes-environment/133)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 5:05pm UTC](https://community.cdata.com/t/deploying-cdata-sync-in-a-kubernetes-environment/133 "2023-03-31T17:05:04Z")
CData Sync provides automated, continuous replication of your enterprise data to any data store. Containerization technology enables you to create applications rapidly and securely and to deploy your application contain… --- ## [How to Work with REST APIs with CData Solutions](https://community.cdata.com/t/how-to-work-with-rest-apis-with-cdata-solutions/135)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 4:50pm UTC](https://community.cdata.com/t/how-to-work-with-rest-apis-with-cdata-solutions/135 "2023-03-31T16:50:53Z")
The CData Drivers for REST provide standards-based access to REST resources by modeling local and remote data as relational tables, views, and stored procedures. The high-performance processing operations hide the comple… --- ## [How to Connect to Amazon DocumentDB with CData MongoDB Drivers](https://community.cdata.com/t/how-to-connect-to-amazon-documentdb-with-cdata-mongodb-drivers/124)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 1:54pm UTC](https://community.cdata.com/t/how-to-connect-to-amazon-documentdb-with-cdata-mongodb-drivers/124 "2023-03-30T13:54:06Z")
Amazon DocumentDB offers a way for developers and DBAs to balance availability, read scalability, and latency with five pre-configured consistency levels. The data in an Amazon DocumentDB cluster is accessible just like … --- ## [How to Create Derived Views, Saved Queries, and Custom Reports in CData Connect AI](https://community.cdata.com/t/how-to-create-derived-views-saved-queries-and-custom-reports-in-cdata-connect-ai/123)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 1:15pm UTC](https://community.cdata.com/t/how-to-create-derived-views-saved-queries-and-custom-reports-in-cdata-connect-ai/123 "2023-03-30T13:15:28Z")
CData Connect AI is a consolidated connectivity platform that links applications to a broad ecosystem of real-time data sources through consistent, standards-compliant interfaces. CData Connect AI provides tools to acces… --- ## [How to Configure the CData Connect Cloud Partner Connector for Looker Studio](https://community.cdata.com/t/how-to-configure-the-cdata-connect-cloud-partner-connector-for-looker-studio/122)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 1:08pm UTC](https://community.cdata.com/t/how-to-configure-the-cdata-connect-cloud-partner-connector-for-looker-studio/122 "2023-03-30T13:08:08Z")
Looker Studio allows you to create branded reports with data visualizations to share with your clients. When paired with CData Connect Cloud, you get instant, cloud-to-cloud access to data from the supported SaaS, Big Da… --- ## [How to Create API Driver API Profiles](https://community.cdata.com/t/how-to-create-api-driver-api-profiles/121)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 12:59pm UTC](https://community.cdata.com/t/how-to-create-api-driver-api-profiles/121 "2023-03-30T12:59:56Z")
RESTful APIs offer a consistent, straightforward way for businesses to work with external data and offer access to their own data. In June 2019, the number of public APIs grew beyond 22,000, with a growth rate of more th… --- ## [Building Dynamic React Apps with Database Data](https://community.cdata.com/t/building-dynamic-react-apps-with-database-data/110)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 27, 2023, 8:44pm UTC](https://community.cdata.com/t/building-dynamic-react-apps-with-database-data/110 "2023-03-27T20:44:35Z")
React is a declarative, efficient, and flexible JavaScript library for building user interfaces. CData Connect Server enables you to generate REST APIs for 250+ data sources, including both on-premises and cloud-based da… --- ## [Displaying Data from Related Tables Using Angular with Connect Server](https://community.cdata.com/t/displaying-data-from-related-tables-using-angular-with-connect-server/111)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 27, 2023, 7:32pm UTC](https://community.cdata.com/t/displaying-data-from-related-tables-using-angular-with-connect-server/111 "2023-03-27T19:32:40Z")
Angular is an updated framework for dynamic Web apps, built upon and expanding principles of Angular JS. CData Connect Server lets you generate a REST APIs for 250+ data sources, including both on-premises and cloud-base… --- ## [Using SQL to Query Gmail](https://community.cdata.com/t/using-sql-to-query-gmail/77)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 21, 2023, 9:54pm UTC](https://community.cdata.com/t/using-sql-to-query-gmail/77 "2023-03-21T21:54:56Z")
The Gmail Data Provider makes it easy to search email from a Gmail account. Instead of learning the details of the IMAP search command, you can simply use the simple SQL syntax. However, the full IMAP search specificatio… [Next page](https://community.cdata.com/c/articles/how-to-with-cdata/37.md?page=1)