CData Software - Knowledge Base
Recent Articles
-
Build Act CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Act CRM and create custom apps in Mendix.
-
How to load Parquet data into Elasticsearch via Logstash
Introducing a simple method to load Parquet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from PayPal to Databricks using CData SSIS Components.
Easily push PayPal to Databricks using the CData SSIS Tasks for PayPal and Databricks.
-
Integrate with Google Ad Manager using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ad Manager to a JSON file on disk.
-
Explore Geographical Relationships in SharePoint Excel Services with Power Map
Create data visualizations with SharePoint Excel Services in Power Map.
-
Build a PostgreSQL Interface for Monday.com using the CData JDBC Driver
Use the Remoting features of the Monday.com JDBC Driver to create a PostgreSQL entry-point for data access.
-
Validate Reckon with QuerySurge
Access and validate Reckon in QuerySurge using the CData JDBC Driver.
-
Automated Continuous YouTube Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Oracle.
-
Build a Simple VCL Application for BigQuery
How to build a simple VCL Application to view Google BigQuery in RAD Studio using the CData ODBC Driver for BigQuery.
-
Create Informatica Mappings From/To a JDBC Data Source for EventBrite
Create EventBrite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Zoho CRM in DataGrip
Create a Data Source for Zoho CRM in DataGrip and use SQL to query live Zoho CRM.
-
Automated Continuous Vault CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Vault CRM replication to Amazon S3.
-
How to connect PolyBase to SFTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SFTP.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph in MicroStrategy Web using the CData Software ODBC Driver for TigerGraph.
-
Use the CData ODBC Driver for Gmail in Microsoft Power Query
You can use the CData Gmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gmail into Microsoft Power Query.
-
Add JSON Services to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JSON with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use CData Connect AI to Access Acumatica in Microsoft Power Pivot
Use CData Connect AI to connect to live Acumatica ERP in the Power Pivot business intelligence tool.
-
Automated Continuous ShipStation Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Cassandra.
-
Query Zoho Creator using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Creator entities in PHP by modeling them as objects.
-
Configure the CData JDBC Driver for Zoho Books in a Connection Pool in Tomcat
Connect to Zoho Books from a connection pool in Tomcat.
-
Access CockroachDB in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for CockroachDB.
-
Extract, Transform, and Load Access in Informatica PowerCenter
Create a simple Workflow for Microsoft Access in Informatica PowerCenter.
-
Visualize SAS Data Sets in Sisense
Create an ElastiCube in Sisense app with access to SAS Data Sets.
-
Visualize Live SAP Netweaver Gateway in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Netweaver Gateway.
-
Import Real-Time Excel Online via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Excel Online in ColdFusion.
-
Integrate with BambooHR in JReport Designer
Create charts and reports based on BambooHR in JReport Designer.
-
Import Real-Time Zoho Inventory via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Inventory in ColdFusion.
-
Extract, Transform, and Load SFTP in Informatica PowerCenter
Create a simple Workflow for SFTP in Informatica PowerCenter.
-
Configure the CData JDBC Driver for Oracle Service Cloud in a Connection Pool in Tomcat
Connect to Oracle Service Cloud from a connection pool in Tomcat.
-
Connect to SAP HANA in JRuby
Create a simple JRuby app with access to live SAP HANA.
-
Integrate with Databricks in JReport Designer
Create charts and reports based on Databricks in JReport Designer.
-
Use Dash to Build to Web Apps on QuickBooks
Create Python applications that use pandas and Dash to build QuickBooks-connected web apps.
-
DataBind Controls to Shopify in Delphi
DataBind to Shopify in Delphi with standard data access components and controls.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for EventBrite
Provide connectivity to Eventbrite through an SAP BusinessObjects universe.
-
Create Datasets from MarkLogic in Domo Workbench and Build Visualizations of MarkLogic in Domo
Use the CData Software ODBC Driver for MarkLogic to create datasets from MarkLogic in Domo Workbench and then build visualizations in the Domo service.
-
How to connect Amazon QuickSight to Gmail
Create a connection to Gmail in CData Connect AI and insert Gmail into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Bing Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Bing Ads replication to Snowflake.
-
Visualize Live Google Campaign Manager 360 in the Power BI Service
Use CData Connect AI to connect to live Google Campaign Manager 360 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Trigger WooCommerce IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Use Biml to Build SSIS Tasks to Replicate Jira Assets to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jira Assets to SQL Server.
-
Rapidly Develop Microsoft Teams-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure DevOps
Create an ODBC connection to Azure DevOps in Informatica and browse and transfer Azure DevOps.
-
Natively Connect to Sugar CRM in PHP
The CData ODBC driver for Sugar CRM enables you to create PHP applications with connectivity to Sugar CRM. Leverage the native support for ODBC in PHP.
-
Create Apps from Cosmos DB in Qlik Sense Cloud
Use CData Connect AI to connect to Cosmos DB and build apps from live Azure Cosmos DB in Qlik Sense Cloud.
-
Access Snowflake in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Snowflake.
-
Query Todoist in DataGrip
Create a Data Source for Todoist in DataGrip and use SQL to query live Todoist.
-
Bridge Oracle SCM Connectivity with Apache NiFi
Access and process Oracle SCM in Apache NiFi using the CData JDBC Driver.
-
Connect to Live Odoo in PostGresSQL Interface through CData Connect AI
Create a live connection to Odoo in CData Connect AI and connect to your Odoo ERP from PostgreSQL.
-
Build Cosmos DB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cosmos DB and create custom apps in Bubble.
-
Build AI Agents with Sage 200 Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
DataBind ActiveCampaign to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for ActiveCampaign with the DevExpress Windows Forms and Web controls to provide ActiveCampaign to a chart.
-
Connect to SendGrid from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendGrid using standard SQL.
-
Integrate Smartsheet in Pentaho Data Integration
Build ETL pipelines based on Smartsheet in the Pentaho Data Integration tool.
-
Build Cosmos DB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Cosmos DB and build visualizations in Tableau.
-
Build a Singer.io Tap for ShipStation With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ShipStation data using
-
How to Seamlessly Import Basecamp Data into IBM SPSS Modeler
Integrate Basecamp data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live IBM Informix 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 IBM Informix for you.
-
Connect to Live Google Drive in MicroStrategy through CData Connect AI
Create a live connection to Google Drive in CData Connect AI and connect to your Google Drive from MicroStrategy.
-
Query MySQL in ColdFusion
Write standard ColdFusion data access code to connect to MySQL.
-
Use the CData Software JDBC Driver for Excel in MicroStrategy Desktop
Connect to Microsoft Excel in MicroStrategy Desktop using the CData Software JDBC Driver for Excel.
-
Connect to IBM Informix from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Informix from Appeon PowerBuilder using the CData ADO.NET Provider for IBM Informix.
-
Design BIRT Reports on Amazon S3
Provide current Amazon S3 to your embedded analytics.
-
Analyze Act CRM in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Act CRM and visualize Act CRM in SAP Analytics Cloud.
-
Replicate Multiple Marketo Accounts via the CData Sync CLI
Replicate multiple Marketo accounts to one or many databases.
-
Connect and Query Live Stripe Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Stripe into Databricks
-
Connect to Salesloft in Aqua Data Studio
Access Salesloft from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Google Contacts Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Contacts replication to Apache Cassandra.
-
Connecting GenSpark with Quickbase via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
How to Connect Flowise AI Agents to Live SAP SuccessFactors 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.
-
Connect BambooHR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BambooHR using the CData Python MCP Server.
-
Connect to and Query Google Campaign Manager 360 in QlikView over ODBC
Create data visualizations with Google Campaign Manager 360 in QlikView.
-
Using the CData Software ODBC Driver for MariaDB in PyCharm
Connect to MariaDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for MariaDB.
-
Use the CData API Server to Access Oracle Financials Cloud in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Financials Cloud in the Power Pivot business intelligence tool.
-
Use Microsoft Copilot Studio to talk to your Oracle HCM Cloud via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
Create SSAS Tabular Models from Salesloft
How to build a SQL Server Analysis Service Tabular Model from Salesloft using CData drivers.
-
Query Live SAP Business One in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP Business One directly from the development environment.
-
Integrate Live Active Directory into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Active Directory and integrate live Active Directory into apps built in Microsoft Power Apps.
-
Automated Continuous Todoist Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Todoist replication to Google Cloud SQL.
-
Analyze Shopify in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shopify and visualize Shopify in SAP Analytics Cloud.
-
Access Live Adobe Experience Manager in AWS Lambda
Connect to live Adobe Experience Manager in AWS Lambda using the CData JDBC Driver.
-
Build Outreach.io-Powered Applications in Claude Code with CData Code Assist MCP
-