CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to Impala via a JDBC Driver
Manage Apache Impala with visual tools in DBeaver like the query browser.
-
Visualize EnterpriseDB Data in TIBCO Spotfire through OData
Integrate EnterpriseDB into dashboards in TIBCO Spotfire.
-
Integrating SparkPost Data in Talend Cloud Data Management Platform
Connect SparkPost Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Load Strava Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Strava to a database.
-
Connect to ScrapingBee Data from PowerBuilder via JDBC
This article demonstrates how to access ScrapingBee from PowerBuilder using the ScrapingBee JDBC Driver.
-
Query Asana Data in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana.
-
Automated Continuous Excel Online Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Excel Online replication to Apache Kafka.
-
Create Power BI Reports on Real-Time SingleStore Data
Use the CData ODBC Driver for SingleStore to visualize SingleStore in Power BI Desktop.
-
Build Semantic Layer Views for CSV Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CSV/TSV Files.
-
Automated Continuous SAP BusinessObjects BI Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Apache Kafka.
-
Integrate Live Drip Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Drip to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect to EnterpriseDB Data from IntelliJ
Integrate connectivity to EnterpriseDB with wizards in IntelliJ.
-
How to integrate Google Tasks with Apache Airflow
Access and process Google Tasks in Apache Airflow using the CData JDBC Driver.
-
Connect to Rootly Data in RazorSQL
Connect to Rootly from wizards and query Rootly from the GUI in the RazorSQL database management tool.
-
Visualize Live Confluence Data in the Power BI Service
Use CData Connect AI to connect to live Atlassian Confluence and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to Planio Data in C++Builder
DataBind to Planio in C++Builder with standard components and controls.
-
Connect to SharePoint Excel Services Data from a Connection Pool in Jetty
The SharePoint Excel Services JDBC Driver supports connection pooling: This article shows how to connect faster to SharePoint Excel Services from Web apps in Jetty.
-
Automate ClickUp Data Replication to Couchbase
Use CData Sync to Customize and automate ClickUp replication to Couchbase.
-
Build iContact-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live iContact Data in Cursor to assist with building iContact-powered applications.
-
Getting Started with the CData ADO.NET Provider for Anaplan
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Anaplan.
-
Visualize Live Sage Intacct Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage Intacct into custom reports in Power BI.
-
Integrating OpenCode Terminal with ConstantContact Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to use SQLAlchemy ORM to access Azure Data Catalog Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Catalog.
-
Analyze Outreach.io Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Outreach.io and visualize live Outreach.io in Infragistics Reveal.
-
A PostgreSQL Interface for Shopify Data using the CData ODBC Driver
Use the SQL Gateway and Shopify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Blackbaud FE NXT for you.
-
Connect to Float from a Connection Pool in WebLogic
Use the CData JDBC Driver for Float to connect to Float from Web applications running on WebLogic.
-
Easily Integrate Google Calendar Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Calendar in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Dynamics 365 Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to MySQL.
-
How to connect to Microsoft Teams Data from IntelliJ
Integrate connectivity to Microsoft Teams with wizards in IntelliJ.
-
Create Dashboards and Visualize Live Xero Data in Geckoboard
Use CData Connect AI to connect to live Xero Accounting and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Edit and Search FTP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of FTP Servers to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create FTP objects that you can access from apps and the dashboard.
-
How to Connect to Live ActiveCampaign Data 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 ActiveCampaign through natural language.
-
How to connect Amazon QuickSight to Sage Intacct Data
Create a connection to Sage Intacct in CData Connect AI and insert Sage Intacct into Amazon QuickSight SPICE to build interactive dashboards.
-
Validate YouTube Analytics Data with QuerySurge
Access and validate YouTube Analytics in QuerySurge using the CData JDBC Driver.
-
Access Live SendPulse Data in Coginiti Pro
Connect to and query live SendPulse from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
ETL ServiceNow in Oracle Data Integrator
This article shows how to transfer ServiceNow into a data warehouse using Oracle Data Integrator.
-
Connect to Freshservice Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Freshservice.
-
Build Splunk-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Splunk to explore live Splunk Data in Gemini Code Assist to assist with building Splunk-powered applications.
-
Excel Spreadsheet Automation on Auth0 Data with the QUERY Formula
Pull data from Auth0, automate spreadsheets, and more with the QUERY formula.
-
Use the CData ODBC Driver for Salesforce Marketing from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Marketing Cloud in Excel.
-
Build Spark-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Apache Spark to explore live Spark Data in GitHub Copilot to assist with building Spark-powered applications.
-
Connect Clockify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Clockify with IBM WebSphere for seamless data integration and connectivity.
-
How to Design Stripe Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Stripe from mobile and tablet Power Apps.
-
Integrate with Zoho Creator Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Creator to a JSON file on disk.
-
Automated Continuous ActiveCampaign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to AlloyDB.
-
Import Real-Time Sybase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sybase in ColdFusion.
-
Build AI/ML Models with Live Adobe Target Data using Dataiku
Connect Adobe Target Data with Dataiku using the CData JDBC Driver for Adobe Target.
-
Integrating OpenCode Terminal with Exact Online Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to and Visualize Live Scrapfly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Scrapfly.
-
Migrating data from Certinia to Databricks using CData SSIS Components.
Easily push Certinia to Databricks using the CData SSIS Tasks for Certinia and Databricks.
-
Connect to Google Ad Manager Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Ad Manager from Filemaker Pro on Mac.
-
Getting Started with the CData ODBC Driver for Basecamp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Basecamp.
-
Establish a Live Connection with Humanity Data using Tableau Bridge
The CData ODBC Driver for Humanity enables you to integrate live Humanity into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData ODBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FormSite.
-
Integrate Theia IDE with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect MongoDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MongoDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Dash to Build to Web Apps on iContact Data
Create Python applications that use pandas and Dash to build iContact-connected web apps.
-
Automated Continuous Accelo Replication to Vertica
Use CData Sync for automated, continuous, customizable Accelo replication to Vertica.
-
Replicate Aircall Data in Heroku for Use in Salesforce Connect
Replicate Aircall to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Teamwork Data with Squirrel SQL client
Connect to Teamwork and execute queries in the Squirrel SQL Client.
-
ETL FormSite in Oracle Data Integrator
This article shows how to transfer FormSite into a data warehouse using Oracle Data Integrator.
-
How to connect to Spotify Data with Squirrel SQL client
Connect to Spotify and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for AlloyDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google AlloyDB.
-
Build Perigon-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Perigon Data in Gemini Code Assist to assist with building Perigon-powered applications.
-
Integrate Real-Time Access to CampaignMonitor in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CampaignMonitor in real time.
-
Connect to Cloudant Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM Cloudant in Airbyte.
-
Connect to Contentful Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Contentful as an External Source in Dremio.
-
Extract, Transform, and Load Salesforce Data in Informatica PowerCenter
Create a simple Workflow for Salesforce & Force.com in Informatica PowerCenter.
-
Automated Continuous Calendly Replication to Oracle
Use CData Sync for automated, continuous, customizable Calendly replication to Oracle.
-
Getting Started with the CData ODBC Driver for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Eloqua.
-
Connect to Live Trello Data in MicroStrategy through CData Connect AI
Create a live connection to Trello Data in CData Connect AI and connect to your Trello from MicroStrategy.
-
Connect to MySQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MySQL from Filemaker Pro on Mac.
-
Connect to Hive Data in DBeaver
Use the CData ODBC Driver to connect to Apache Hive in DBeaver.
-
How to import Kafka Data into Apache Solr
Use the CData Software JDBC Driver for Kafka in Data Import Handler and create an automated import of Apache Kafka to Apache Solr Enterprise Search platform.
-
How to connect PolyBase to Recurly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Recurly.
-
Automate Keap Data Replication to Azure Synapse
Use CData Sync to customize and automate Keap replication to Azure Synapse.
-
Build Apps with Live SAP HANA XS Advanced Data Using the Low-Code Development Platform of Mendix
Connect SAP HANA XS Advanced with Mendix to build apps using the CData JDBC Driver for SAP HANA XS Advanced.
-
How to Build an ETL App for Onfleet Data in Python with CData
Create ETL applications and real-time data pipelines for Onfleet in Python with petl.
-
Automated Continuous WooCommerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable WooCommerce replication to IBM DB2.
-
Work with Freshteam Data in FoxPro
Load Freshteam into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Live JSON Services in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to JSON from the MuleSoft Anypoint Platform to integrate live JSON into custom reports and dashboards.
-
Connect to SharePoint Excel Services Data from PowerBuilder via JDBC
This article demonstrates how to access SharePoint Excel Services from PowerBuilder using the SharePoint Excel Services JDBC Driver.
-
Build a Simple VCL Application for Landbot Data
How to build a simple VCL Application to view Landbot in RAD Studio using the CData ODBC Driver for Landbot.
-
Integrating Codex CLI with PostgreSQL via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Quickbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quickbase.
-
Create Dynamic Short.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Short.io to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live SurveyMonkey Data in the Power BI Service
Use CData Connect AI to connect to live SurveyMonkey and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on Mixpanel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mixpanel.
-
Automated Continuous Shippo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shippo replication to Google BigQuery.
-
Integrate with ZohoDesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoDesk to a JSON file on disk.
-
Automated Continuous Splunk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Splunk replication to Google BigQuery.
-
Replicate Oracle Service Cloud Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Service Cloud to disparate databases with a single configuration.
-
Import BigQuery Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google BigQuery. In this article, you will use the OData format to import Google BigQuery into Microsoft Power Query.
-
A PostgreSQL Interface for BigCommerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Extend Google Sheets with MessageBird Data
Make calls to MessageBird from Google Apps Script via the API Server.
-
Analyze Aweber Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Aweber with the CData JDBC Driver for Aweber.
-
Use JayDeBeApi to access Campaigner Data in Python
Use standard Python scripting and the development environment of your choice to access live Campaigner.
-
Getting Started with the CData ODBC Driver for Parallel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Parallel.
-
Integrate Real-Time Access to Hubstaff in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Hubstaff in real time.