CData Software - Knowledge Base
Recent Articles
-
Access Live Paylocity Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Paylocity data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Microsoft Teams Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to delimited files (CSV/TSV).
-
Automated Continuous RSS Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable RSS replication to Apache Kafka.
-
How to Access Email Using Entity Framework
This article shows how to access Email using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Wave Financial to Power BI dashboards. Simply drag and drop Wave Financial into data visuals on the Power BI canvas.
-
Integrate IBM Informix in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM Informix from Informatica Cloud.
-
How to connect to ActiveCampaign from Spring Boot
Connect to ActiveCampaign in a Spring Boot Application using CData JDBC ActiveCampaign Driver
-
How to Connect the Power BI Service to PayPal: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Access Live Google Cloud Storage in Coginiti Pro
Connect to and query live Google Cloud Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Explore Geographical Relationships in TaxJar with Power Map
Create data visualizations with TaxJar in Power Map.
-
Use the CData ODBC Driver for TaxJar in Microsoft Power Query
You can use the CData TaxJar ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import TaxJar into Microsoft Power Query.
-
Publish Odoo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Odoo ERP.
-
ETL Oracle SCM in Oracle Data Integrator
This article shows how to transfer Oracle SCM into a data warehouse using Oracle Data Integrator.
-
Automated Continuous MailChimp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailChimp replication to AlloyDB.
-
How to connect to Vault CRM in DBVisualizer
Integrate Veeva Vault & Vault CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Oracle Eloqua Reporting Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Eloqua Reporting data access from reports, embedded analytics, and more.
-
Getting Started with the CData JDBC Driver for Avro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Avro.
-
DataBind Controls to Klaviyo in Delphi
DataBind to Klaviyo in Delphi with standard data access components and controls.
-
How to connect to Pinterest in DBVisualizer
Integrate Pinterest with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Klaviyo Replication to Oracle
Use CData Sync for automated, continuous, customizable Klaviyo replication to Oracle.
-
Access Live Microsoft Dataverse in Excel 365 Online (Excel for the web)
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Redis in AWS Lambda
Connect to live Redis in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for Sybase in APOS Live Data Gateway
Use the CData Connector for Sybase in APOS Live Data Gateway to build Semantic Layer Views for Sybase.
-
Analyze Live Salesforce in SAS Viya
Use CData Connect AI to connect to Salesforce & Force.com from SAS Viya and deploy self-service analytics using live Salesforce & Force.com.
-
How to Connect Flowise AI Agents to Live Instagram via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
How to Connect to Live Adobe Commerce in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Adobe Commerce for you.
-
Create Data Visualizations Based On IBM Informix in Mode
Use CData Connect AI to connect to IBM Informix from Mode and build visualizations using live
-
How to Connect to Live Act-On from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Act-On through natural language.
-
Connect to CockroachDB in DBeaver
Use the CData ODBC Driver to connect to CockroachDB in DBeaver.
-
View Reports on Real-Time Dynamics NAV in Power BI Report Server
Use the CData ODBC Driver for Dynamics NAV to visualize Microsoft Dynamics NAV in Power BI Desktop and then publish them to Power BI Report Server.
-
Feed Dynamics 365 into FineReport
How to set Microsoft Dynamics 365 as a JDBC data source in FineReport.
-
How to Query Live WooCommerce in Perplexity MacOS Desktop
Connect to and query live WooCommerce in Perplexity Desktop using the CData MCP Server.
-
How to Connect to Live Azure Active Directory from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Azure Active Directory through natural language.
-
Query FHIR as a MySQL Database in Node.js
Execute MySQL queries against FHIR from Node.js.
-
Use Azure AI Foundry to Talk to Your Amazon Marketplace via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Amazon Marketplace for you.
-
How to Connect to Live Greenplum from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Pivotal GreenPlum for you.
-
How to work with Sybase in Apache Spark using SQL
Access and process Sybase in Apache Spark using the CData Software JDBC Driver.
-
Build a Simple VCL Application for Jira Assets
How to build a simple VCL Application to view Jira Assets in RAD Studio using the CData ODBC Driver for Jira Assets.
-
Add Sage 50 UK to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage 50 UK with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Google Sheets Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Sheets replication to Azure SQL Database.
-
Bidirectional Access to Zoho CRM from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho CRM in Filemaker Pro for Mac or Windows.
-
Analyze Hive in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Hive and visualize Apache Hive in SAP Analytics Cloud.
-
Build Dashboards with Zoho Creator in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Creator in Dundas BI.
-
Connect to XML in DBeaver
Use the CData ODBC Driver to connect to XML Files in DBeaver.
-
How to Design TaxJar Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Trigger Paylocity IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Import Real-Time SAS xpt via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAS XPORT in ColdFusion.
-
Automate Parquet Replication to Azure Synapse
Use CData Sync to customize and automate Apache Parquet replication to Azure Synapse.
-
Automated Continuous Office 365 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Office 365 replication to PostgreSQL.
-
Bridge Email Connectivity with Apache NiFi
Access and process Email in Apache NiFi using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Workday via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Workday, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate Facebook Ads Replication to Couchbase
Use CData Sync to Customize and automate Facebook Ads replication to Couchbase.
-
Integrate with Live HubSpot in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HubSpot from the MuleSoft Anypoint Platform to integrate live HubSpot into custom reports and dashboards.
-
How to connect to Hive from IntelliJ
Integrate connectivity to Apache Hive with wizards in IntelliJ.
-
Connect to Azure Data Lake Storage from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage and execute queries in PowerBuilder.
-
Connect to Adobe Commerce in Claris FileMaker Pro
-