CData Software - Knowledge Base
Recent Articles
-
Integrate with live Apollo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apollo in Jitterbit.
-
Build LinkedIn-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn and build LinkedIn-connected web apps with Axios.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy Desktop
Connect to Factorial in MicroStrategy Desktop using the CData Software ODBC Driver for Factorial.
-
Connect to Pushbullet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pushbullet in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData ODBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Email.
-
Automated Continuous Oracle Eloqua Reporting Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Apache Kafka.
-
Getting Started with the CData Python Connector for Campaigner
Learn to install and license the CData Python Connector
-
How to Use a Microsoft Access Database to Update HubSpot Data in Real Time
Update HubSpot data by creating a linked table in Microsoft Access with the CData HubSpot ODBC Driver.
-
Connect to Live Azure Synapse Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Synapse Data in CData Connect AI and connect to your Azure Synapse from MicroStrategy.
-
Provide OData Services of Opsgenie Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Opsgenie by developing a WCF Service Application.
-
Access ServiceNow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ServiceNow from HeidiSQL.
-
How to Create Power BI Visual Reports with Real-Time Bannerbear Data
Use CData Power BI Connectors to visualize Bannerbear in Power BI.
-
Analyze Placid Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Placid and visualize live Placid in Infragistics Reveal.
-
Visualize Live Google Tasks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Tasks using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Grok to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Stripe for you.
-
Build Charts with Basecamp Data in Clear Analytics
Create dynamic charts and perform analytics based on Basecamp in Clear Analytics.
-
Migrating data from SAP HANA XS Advanced to Databricks using CData SSIS Components.
Easily push SAP HANA XS Advanced to Databricks using the CData SSIS Tasks for SAP HANA XS Advanced and Databricks.
-
Choosing the Best Method to Connect Procore to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Procore from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Trigger Workday IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Workday with standard wizards in Logic Apps.
-
Integrate Theia IDE with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Visualize ZarMoney Data in TIBCO Spotfire through OData
Integrate ZarMoney into dashboards in TIBCO Spotfire.
-
Integrate with Monday.com Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Monday.com in SnapLogic.
-
Connect Strava to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Strava using the CData Python MCP Server.
-
Connect to SAP Ariba Procurement from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Ariba Procurement, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Hacker News to Power BI dashboards. Simply drag and drop Hacker News into data visuals on the Power BI canvas.
-
Connect to IBM Informix in SpagoBI
Create reports featuring live IBM Informix in SpagoBI Studio. Host IBM Informix reports on SpagoBI Server.
-
Load AgileCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load AgileCRM to a database.
-
Connect to Teradata Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Teradata and the Script function in FileMaker Pro to connect to Teradata and work with Teradata in your FileMaker application.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS Data Sets
Create an ODBC connection to SAS Data Sets in Informatica and browse and transfer SAS Data Sets.
-
Use the CData Software JDBC Driver for CampaignMonitor in MicroStrategy
Connect to CampaignMonitor in MicroStrategy Developer using the CData Software JDBC Driver for CampaignMonitor.
-
Build Oracle HCM Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle HCM Cloud and build web apps with connectivity to live Oracle HCM Cloud.
-
Build Automated Workflows with Live Databricks Data in Workato
Use CData Connect AI to connect to live Databricks and build automated workflows in Workato.
-
Connecting Mastra with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Pipedrive, no replication required.
-
Build Visualizations of SageHR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SageHR in Birst.
-
Feed Elasticsearch Data into FineReport
How to set Elasticsearch as a JDBC data source in FineReport.
-
How to Connect the Power BI Service to Google Contacts: Complete Guide
Connect to the CData Software Power BI Connector for Google Contacts from PowerBI.com to provide real-time Google Contacts across the organization.
-
Access Cloudant Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Cloudant from your Oracle system.
-
Bidirectional Access to Harvest Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Harvest in Filemaker Pro for Mac or Windows.
-
Build Neo4J-Connected Apps in Choreo
Use CData Connect AI to connect to Neo4J Data from Choreo and build custom apps using live Neo4J.
-
Extract, Transform, and Load Exa Data in Informatica PowerCenter
Create a simple Workflow for Exa in Informatica PowerCenter.
-
Integrate Wave Financial with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wave Financial with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wave Financial.
-
Import and Visualize ADP Data in Power View
Create data visualizations based on ADP in Excel.
-
Access Live Nethunt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Nethunt in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live Quickbase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Seamlessly Import ClickTime Data into IBM SPSS Modeler
Integrate ClickTime data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Real-Time Stripe Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Stripe and Dataflow to import and use Stripe in Power Apps.
-
How to Access Live Jira Data in Visual Studio Code via Cline
Run CData MCP Server for Jira on Windows Subsytem for Linux (WSL) and connect to live Atlassian Jira from the Cline extension in Visual Studio Code.
-
Publish IBM Informix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix.
-
How to Import Data from Elorus into Google Sheets
Import Elorus into a Google spreadsheet that is automatically refreshed.
-
Working with SendGrid Data in LINQPad
Execute LINQ queries to SendGrid in LINQPad.
-
Migrating data from Bitbucket to Databricks using CData SSIS Components.
Easily push Bitbucket to Databricks using the CData SSIS Tasks for Bitbucket and Databricks.
-
Build Factorial-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Factorial Data in Claude Code to assist with building Factorial-powered applications.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Web
Connect to MySQL in MicroStrategy Web using the CData Software ODBC Driver for MySQL.
-
Access Chargebee Data from MySQL in PHP
Connect to Chargebee through the standard MySQL libraries in PHP.
-
Replicate Presto Data to Multiple Databases
Replicate Presto to disparate databases with a point-and-click configuration.
-
Create Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari.
-
Design BIRT Reports on SAP Business One Data
Provide current SAP Business One to your embedded analytics.
-
Integrating OpenCode Terminal with PDFMonkey 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 Oracle Service Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Service Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Live ZohoInvoice Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoInvoice.
-
Build MailChimp-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MailChimp to explore live MailChimp Data in GitHub Copilot to assist with building MailChimp-powered applications.
-
Create a Data Access Object for Sendwithus Data using JDBI
A brief overview of creating a SQL Object API for Sendwithus in JDBI.
-
Access Live Google Spanner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner from your Excel spreadsheets.
-
Build Apps with Live EnterpriseDB in Adalo using CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB into the Adalo platform and build custom mobile and web applications with real-time EnterpriseDB.
-
Work with Workable Data in FoxPro
Load Workable into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create SSAS Tabular Models from Spark Data
How to build a SQL Server Analysis Service Tabular Model from Apache Spark SQL using CData drivers.
-
Create Dynamic PDFMonkey Grids Using the Infragistics XamDataGrid
Learn how you can connect PDFMonkey to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Authorize.Net Replication to SQLite
Use CData Sync for automated, continuous, customizable Authorize.Net replication to SQLite.
-
Load WooCommerce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WooCommerce to a database.
-
Replicate Reckon Data to Multiple Databases
Replicate Reckon to disparate databases with a point-and-click configuration.
-
Automated Continuous ZohoSubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Apache Cassandra.
-
Connect to Apollo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Microsoft Ads-Connected Business Apps in AppSheet
Connect to Microsoft Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Ads.
-
Integrating Cursor CLI with Keap 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.
-
Integrating Gumloop with Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Sheets within automated workflows.
-
Create Splunk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Splunk data access from reports, embedded analytics, and more.
-
Build Avaza-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Avaza Data in Gemini Code Assist to assist with building Avaza-powered applications.
-
How to Connect to Couchbase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Couchbase. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Paylocity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Paylocity to a JSON file on disk.
-
Integrate CircleCI Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CircleCI from Informatica Cloud.
-
ETL Redis in Oracle Data Integrator
This article shows how to transfer Redis into a data warehouse using Oracle Data Integrator.
-
Create NetSuite SuiteAnalytics-Connected Business Apps in AppSheet
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to NetSuite SuiteAnalytics.
-
DataBind Oracle Financials Cloud Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Financials Cloud with the DevExpress Windows Forms and Web controls to provide Oracle Financials Cloud to a chart.
-
Connect GitHub to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect GitHub with IBM WebSphere for seamless data integration and connectivity.
-
Configure the CData JDBC Driver for Bannerbear in a Connection Pool in Tomcat
Connect to Bannerbear from a connection pool in Tomcat.
-
Integrate with Airtable Data in JReport Designer
Create charts and reports based on Airtable in JReport Designer.
-
Automate MarkLogic Data Replication to SAP HANA
Use CData Sync to customize and automate MarkLogic replication to SAP HANA.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Ads for you.
-
How to Work with Sage Cloud Accounting Data in ETL Validator JDBC
Connect to Sage Cloud Accounting from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to CircleCI Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to CircleCI and work with CircleCI in your FileMaker application.
-
How to Build an ETL App for JobNimbus Data in Python with CData
Create ETL applications and real-time data pipelines for JobNimbus in Python with petl.
-
Create Informatica Mappings From/To an ODBC Data Source for Exa
Create an ODBC connection to Exa in Informatica and browse and transfer Exa.
-
Build AI/ML Models with Live IBM Cloud Object Storage Data using Dataiku
Connect IBM Cloud Object Storage Data with Dataiku using the CData JDBC Driver for IBM Cloud Object Storage.
-
Integrating Gumloop with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Ariba Source within automated workflows.
-
Query Airtable Data in ColdFusion
Write standard ColdFusion data access code to connect to Airtable.
-
Build Semantic Layer Views for PolarTeamPro Data in APOS Live Data Gateway
Use the CData Connector for PolarTeamPro in APOS Live Data Gateway to build Semantic Layer Views for PolarTeamPro.
-
How to connect and process Slack from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Slack.
-
Query Printify Data in DataGrip
Create a Data Source for Printify in DataGrip and use SQL to query live Printify.
-
A PostgreSQL Interface for Figshare Data using the CData ODBC Driver
Use the SQL Gateway and Figshare ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Codat Data in DataGrip
Create a Data Source for Codat in DataGrip and use SQL to query live Codat.