# Getting started **URL:** https://community.cdata.com/c/articles/getting-started-1/31.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Getting started category](https://community.cdata.com/t/about-the-getting-started-category/1461)
**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-getting-started-category/1461 "2026-10-21T15:35:17Z")
Helpful articles to get you started working with CData --- ## [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 … --- ## [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 … --- ## [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… --- ## [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… --- ## [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… --- ## [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 (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… --- ## [Connect Cloud: Configuring the API Connector](https://community.cdata.com/t/connect-cloud-configuring-the-api-connector/425)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 29, 2023, 2:21pm UTC](https://community.cdata.com/t/connect-cloud-configuring-the-api-connector/425 "2023-09-29T14:21:23Z")
The API Connector in CData Connect Cloud lets you connect to any cloud-based API that produces XML or JSON data. This means that you can work with data from custom or proprietary APIs from your preferred tools and applic… --- ## [CData Sync: Schedule Sequential Replication Tasks](https://community.cdata.com/t/cdata-sync-schedule-sequential-replication-tasks/410)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 21, 2023, 10:53pm UTC](https://community.cdata.com/t/cdata-sync-schedule-sequential-replication-tasks/410 "2023-09-21T22:53:43Z")
While CData Sync has built-in scheduling for repeating jobs at specific intervals, you may want to trigger some replication tasks only after others have completed. With CData Sync’s event API, you can do this easily. Y… --- ## [Creating User Defined Views](https://community.cdata.com/t/creating-user-defined-views/406)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 20, 2023, 5:31pm UTC](https://community.cdata.com/t/creating-user-defined-views/406 "2023-09-20T17:31:59Z")
The CData Drivers and Connectors allow you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly con… --- ## [CData Sync: DBT Transformations](https://community.cdata.com/t/cdata-sync-dbt-transformations/390)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 13, 2023, 2:57pm UTC](https://community.cdata.com/t/cdata-sync-dbt-transformations/390 "2023-09-13T14:57:23Z")
CData Sync now integrates with dbt Core (a data building tool by dbt Labs™), which enables you to create powerful transformations. This integration enables you to develop, control, and run transformations to build Python… --- ## [Establishing Azure AD SSO Authentication in CData Sync](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-sync/384)
**Author:** [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\ **Replies:** 0\ **Last updated:** [September 7, 2023, 5:55pm UTC](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-sync/384 "2023-09-07T17:55:24Z")
Single Sign-On (SSO) in Azure Active Directory (Azure AD) enhances the user experience with CData Sync and improves security and productivity, which helps create efficient, user-friendly and robust access to the applicat… --- ## [CData Sync: History Mode (including Apache Kafka)](https://community.cdata.com/t/cdata-sync-history-mode-including-apache-kafka/366)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [August 29, 2023, 8:56pm UTC](https://community.cdata.com/t/cdata-sync-history-mode-including-apache-kafka/366 "2023-08-29T20:56:54Z")
CData Sync history mode provides a method for analyzing historical data in your data sources. History mode is a slowly changing dimension that stores and manages relatively static data (current and historical) in a data … --- ## [CData Sync: In-Flight (ETL) Transformation Library](https://community.cdata.com/t/cdata-sync-in-flight-etl-transformation-library/354)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [August 23, 2023, 3:54pm UTC](https://community.cdata.com/t/cdata-sync-in-flight-etl-transformation-library/354 "2023-08-23T15:54:13Z")
CData Sync supports both extract-transform-load (ETL) and extract-load-transform (ELT) transformations for data pipelines. A built-in transformation library allows organizations to easily mask personally identifiable inf… --- ## [CData Sync 2023 Release Enterprise Features](https://community.cdata.com/t/cdata-sync-2023-release-enterprise-features/348)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [August 21, 2023, 7:10pm UTC](https://community.cdata.com/t/cdata-sync-2023-release-enterprise-features/348 "2023-08-21T19:10:10Z")
The 2023 release of CData Sync includes several updates to continue to improve the enterprise experience for Sync users and administrators. In this post, we’ll highlight and provide details on the latest feature updates. … --- ## [ODBC Driver Getting Started Guide](https://community.cdata.com/t/odbc-driver-getting-started-guide/130)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 5:06pm UTC](https://community.cdata.com/t/odbc-driver-getting-started-guide/130 "2023-03-31T17:06:09Z")
With built-in optimized data processing, the CData ODBC Driver offers unmatched performance for interacting with live data. When issuing complex SQL queries to your application, the driver pushes supported SQL operations… --- ## [Getting Started with OAuth in CData Connectivity Solutions](https://community.cdata.com/t/getting-started-with-oauth-in-cdata-connectivity-solutions/134)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 4:35pm UTC](https://community.cdata.com/t/getting-started-with-oauth-in-cdata-connectivity-solutions/134 "2023-03-31T16:35:37Z")
OAuth 2.0 is an authorization protocol that that allows an API client to have restricted access to user data on a web server. It is notably used by the APIs of prominent applications like Facebook, Google, GitHub and man… --- ## [Python Connector Getting Started Guide](https://community.cdata.com/t/python-connector-getting-started-guide/132)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 31, 2023, 4:04pm UTC](https://community.cdata.com/t/python-connector-getting-started-guide/132 "2023-03-31T16:04:53Z")
With built-in optimized data processing, the CData Python Connector offers unmatched performance for interacting with live data. When issuing complex SQL queries to your application, the driver pushes supported SQL opera… --- ## [JDBC Driver Getting Started Guide](https://community.cdata.com/t/jdbc-driver-getting-started-guide/131)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 7:21pm UTC](https://community.cdata.com/t/jdbc-driver-getting-started-guide/131 "2023-03-30T19:21:00Z")
With built-in optimized data processing, the CData JDBC Driver offers unmatched performance for interacting with live data. When issuing complex SQL queries to your application, the driver pushes supported SQL operations… --- ## [How CData Solutions Connect with NoSQL Data Sources](https://community.cdata.com/t/how-cdata-solutions-connect-with-nosql-data-sources/125)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 3:15pm UTC](https://community.cdata.com/t/how-cdata-solutions-connect-with-nosql-data-sources/125 "2023-03-30T15:15:27Z")
Our Drivers provide the fastest and most flexible support for NoSQL data integration. In this article we highlight the specific features and capabilities that are common across all of our NoSQL drivers, using our MongoDB… --- ## [Tableau Connector Getting Started Guide (with video)](https://community.cdata.com/t/tableau-connector-getting-started-guide-with-video/101)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 24, 2023, 5:10pm UTC](https://community.cdata.com/t/tableau-connector-getting-started-guide-with-video/101 "2023-03-24T17:10:43Z")
The CData Tableau Connector provides self-service integration with Tableau, linking your Tableau reports to real-time data. That way, you can monitor enterprise data through dashboards and ensure that your analysis refle… --- ## [SSIS Components Getting Started Guide (with video)](https://community.cdata.com/t/ssis-components-getting-started-guide-with-video/100)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 24, 2023, 4:53pm UTC](https://community.cdata.com/t/ssis-components-getting-started-guide-with-video/100 "2023-03-24T16:53:50Z")
Microsoft SQL Server Integration Services (SSIS) is an enterprise data integration, data transformation, and data migration tool built into the Microsoft SQL Server database. The CData SSIS data flow components are a pow… --- ## [PowerShell Cmdlets Getting Started Guide (with video)](https://community.cdata.com/t/powershell-cmdlets-getting-started-guide-with-video/99)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 24, 2023, 4:42pm UTC](https://community.cdata.com/t/powershell-cmdlets-getting-started-guide-with-video/99 "2023-03-24T16:42:38Z")
Microsoft PowerShell is a command-line shell designed especially for system administrators. PowerShell includes an interactive prompt and a scripting environment that can be used independently or in combination. The CDat… --- ## [Excel Add-In Getting Started Guide (with video)](https://community.cdata.com/t/excel-add-in-getting-started-guide-with-video/91)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 24, 2023, 4:06pm UTC](https://community.cdata.com/t/excel-add-in-getting-started-guide-with-video/91 "2023-03-24T16:06:57Z")
The CData Excel Add-In provides self-service integration with Microsoft Excel, linking your Excel spreadsheet to real-time data. That way, you can monitor enterprise data and keep it up-to-date for use in reporting and a… [Next page](https://community.cdata.com/c/articles/getting-started-1/31.md?page=1)