CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Salesforce
How to build a simple VCL Application to view Salesforce & Force.com in RAD Studio using the CData ODBC Driver for Salesforce.
-
How to Work with Avalara AvaTax in ETL Validator JDBC
Connect to Avalara AvaTax from ETL Validator jobs using the CData Software JDBC Driver.
-
Elasticsearch Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Elasticsearch facts in real time.
-
Design BIRT Reports on Airtable
Provide current Airtable to your embedded analytics.
-
Getting Started with the CData ODBC Driver for Pinterest
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pinterest.
-
Visualize ActiveCampaign in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ActiveCampaign into TIBCO Spotfire.
-
Access LinkedIn Ads from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn Ads from HeidiSQL.
-
Getting Started with the CData Excel Add-In for Sage 200
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 200.
-
Query Harvest in DataGrip
Create a Data Source for Harvest in DataGrip and use SQL to query live Harvest.
-
Visualize Live Twilio of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Twilio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Dynamics 365 Business Central 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 Dynamics 365 Business Central.
-
Create a Data Access Object for LDAP Objects using JDBI
A brief overview of creating a SQL Object API for LDAP in JDBI.
-
Analyze Clio with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clio from Power Pivot. You will use the Table Import Wizard to load Clio. You can visually build the import query or use any SQL supported by the driver.
-
Build Google Sheets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Sheets from Zoho Analytics and import live Google Sheets.
-
Automated Continuous Vertica Replication to Databricks
Use CData Sync for automated, continuous, customizable Vertica replication to Databricks.
-
Automated Continuous SAP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP replication to Google BigQuery.
-
Automated Continuous Zoho Books Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Books replication to MongoDB.
-
Feed Zoho CRM into FineReport
How to set Zoho CRM as a JDBC data source in FineReport.
-
Automated Continuous Monday.com Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Monday.com replication to PostgreSQL.
-
How to integrate Metabase with Greenplum
Use CData Connect AI to connect to live Pivotal GreenPlum and create an interactive dashboard in Metabase from Pivotal GreenPlum.
-
Use Dash to Build to Web Apps on Odoo
Create Python applications that use pandas and Dash to build Odoo-connected web apps.
-
Build Azure Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Analysis Services.
-
Build Pipelines with Live Slack in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Slack from Google Cloud Data Fusion, enabling the integration of live Slack into the building and management of effective data pipelines.
-
Configure the CData JDBC Driver for Paylocity in a Connection Pool in Tomcat
Connect to Paylocity from a connection pool in Tomcat.
-
Automated Continuous Freshdesk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to Google Cloud SQL.
-
Automate Jira Replication to Azure Data Lake
Use CData Sync to customize and automate Atlassian Jira replication to Azure Data Lake.
-
Add Teradata to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Teradata with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SAP ByDesign from AWS Glue
Use CData Connect AI to gain access to live SAP Business ByDesign from your AWS Glue jobs.
-
Process & Analyze Azure Data Catalog in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Catalog .
-
Integrate Google Analytics in Pentaho Data Integration
Build ETL pipelines based on Google Analytics in the Pentaho Data Integration tool.
-
Deploy the ADO.NET Provider for Teradata on an SSRS Report Server
Connect to Teradata from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Trigger ActiveCampaign IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
How to Connect to Live Microsoft Project 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 Microsoft Project for you.
-
Connect and Query Live QuickBooks Time Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Time into Databricks
-
How to update MailChimp from Excel
This article explains how to transfer data from Excel to MailChimp using the Excel Add-In for MailChimp.
-
Integrate with XML using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy XML Files to a JSON file on disk.
-
Visualize SAS Data Sets in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAS Data Sets into TIBCO Spotfire.
-
Integrate BambooHR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BambooHR with External Services.
-
Build a Singer.io Tap for Azure Table With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Table data using
-
Automated Continuous Epicor Kinetic Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Amazon S3.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy Desktop
Connect to Lakebase in MicroStrategy Desktop using the CData Software ODBC Driver for Lakebase.
-
Create Reports with SAS xpt in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS XPORT.
-
How to Visualize Parquet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Parquet in Python.
-
Access Live Airtable Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Airtable data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import Real-Time Azure Data Catalog via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Data Catalog in ColdFusion.
-
How to Query ADP in MySQL Workbench
Execute MySQL queries against live ADP from MySQL Workbench.
-
Access Google Cloud Storage as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Cloud Storage from your Oracle system.
-
Automated Continuous MariaDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MariaDB replication to Google BigQuery.
-
How to Query Live Google Calendar in Perplexity MacOS Desktop
Connect to and query live Google Calendar in Perplexity Desktop using CData Code Assist MCP.
-
Replicate SAP Ariba Source to Multiple Databases
Replicate SAP Ariba Source to disparate databases with a point-and-click configuration.
-
Extract, Transform, and Load Reckon Accounts Hosted in Informatica PowerCenter
Create a simple Workflow for Reckon Accounts Hosted in Informatica PowerCenter.
-
Analyze QuickBooks Online in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Online from Cognos Analytics and analyze live QuickBooks Online.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Atlassian Jira within intelligent workflows.
-
Create Tableau CRM Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate with PayPal in SnapLogic
Use CData Connect AI to connect to and integrate with live PayPal in SnapLogic.
-
Replicate Unbounce in Heroku for Use in Salesforce Connect
Replicate Unbounce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Kafka with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kafka with External Services.
-
Using the CData Software ODBC Driver for Epicor Kinetic in PyCharm
Connect to Epicor Kinetic as an ODBC data source in PyCharm using the CData Software ODBC Driver for Epicor Kinetic.
-
Connect to Sage Intacct from a Connection Pool in Jetty
The Sage Intacct JDBC Driver supports connection pooling: This article shows how to connect faster to Sage Intacct from Web apps in Jetty.
-
Visualize Live WordPress of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live WordPress using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Edit and Search Google Spanner External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Spanner to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Spanner objects that you can access from apps and the dashboard.
-
Build Act-On-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Act-On and build web apps with connectivity to live Act-On.
-
Connect to Salesforce from PowerBuilder via JDBC
This article demonstrates how to access Salesforce & Force.com from PowerBuilder using the Salesforce JDBC Driver.
-
Connect to Real-Time Oracle HCM Cloud Data in Power Apps Using Dataflows to Build Custom Applications
-