CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FormSite.
-
Integrate Goose with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Excel Online from within the local AI agent.
-
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.
-
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.
-
ETL FormSite in Oracle Data Integrator
This article shows how to transfer FormSite into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for Google Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Analytics data using
-
Visualize Live Dynamics 365 Business Central Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dynamics 365 Business Central.
-
Analyze Hive Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Hive with the CData JDBC Driver for Hive.
-
Use Microsoft Copilot Studio to talk to your Avalara AvaTax Data 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 Avalara AvaTax for you.
-
How to connect to Sage 200 Data in DBVisualizer
Integrate Sage 200 with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Autopilot Data in Tableau
The CData ODBC driver for Autopilot enables you integrate Autopilot into Tableau dashboards.
-
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.
-
SAP SuccessFactors Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP SuccessFactors facts in real time.
-
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 to Microsoft OneDrive Data in DBVisualizer
Integrate Microsoft OneDrive with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Keap Data Replication to Azure Synapse
Use CData Sync to customize and automate Keap replication to Azure Synapse.
-
Connect to and Query Xero Data in QlikView over ODBC
Create data visualizations with Xero Accounting in QlikView.
-
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.
-
Create Dynamic MariaDB Grids Using the Infragistics XamDataGrid
Learn how you can connect MariaDB to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Excel Add-In for Onfleet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Onfleet.
-
Extract, Transform, and Load TigerGraph Data in Informatica PowerCenter
Create a simple Workflow for TigerGraph in Informatica PowerCenter.
-
Build Semantic Layer Views for Klaviyo Data in APOS Live Data Gateway
Use the CData Connector for Klaviyo in APOS Live Data Gateway to build Semantic Layer Views for Klaviyo.
-
Rapidly Develop Pipeliner CRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Pipeliner CRM.
-
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.
-
Validate Monday.com Data with QuerySurge
Access and validate Monday.com in QuerySurge using the CData JDBC Driver.
-
How to create Reckon Accounts Hosted federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon Accounts Hosted in MySQL .
-
Natively Connect to Raisers Edge NXT Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Raisers Edge NXT. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for MySQL in MicroStrategy Web
Connect to MySQL in MicroStrategy Web using the CData Software JDBC Driver for MySQL.
-
Import Email Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Email Data and provide access to live Email for custom reports in the Power BI Service.
-
Connect to MailChimp Data in JRuby
Create a simple JRuby app with access to live MailChimp.
-
How to connect to Float Data with Squirrel SQL client
Connect to Float and execute queries in the Squirrel SQL Client.
-
Create Demio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Demio data access from reports, embedded analytics, and more.
-
Automated Continuous Shippo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shippo replication to Google BigQuery.
-
Automated Continuous Optimizely Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Optimizely replication to Google Cloud SQL.
-
Connect to PabblySubscriptions Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PabblySubscriptions as an External Source in Dremio.
-
Automated Continuous ConstantContact Replication to Snowflake
Use CData Sync for automated, continuous, customizable ConstantContact replication to Snowflake.
-
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.
-
Integrating Gumloop with Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dynamics 365 Business Central within automated workflows.
-
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.
-
Use Manus AI to Talk to Your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Instagram.
-
Enable the Pushbullet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pushbullet.
-
How to Connect DBeaver to Parallel via a JDBC Driver
Manage Parallel with visual tools in DBeaver like the query browser.
-
Connect to SingleStore Data from Crystal Reports
Use CData Connect AI to connect to and report on live SingleStore from Crystal Reports.
-
Access Live SFTP Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SFTP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Process & Analyze ChartMogul Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ChartMogul Data.
-
Back Up SendPulse to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with SendPulse data.
-
How to Visualize Avalara AvaTax Data in Python with pandas
Use pandas and other modules to analyze and visualize live Avalara AvaTax in Python.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MYOB AccountRight to Power BI dashboards. Simply drag and drop MYOB AccountRight into data visuals on the Power BI canvas.
-
Integrating Cursor CLI with Salesloft 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.
-
Automated Continuous Billsby Replication to MongoDB
Use CData Sync for automated, continuous, customizable Billsby replication to MongoDB.
-
Integrating OpenCode Terminal with ConvertKit 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 Seamlessly Import Browserless Data into IBM SPSS Modeler
Integrate Browserless data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Theia IDE with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to CSV Data in Ruby
Connect to CSV/TSV Files in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for Opsgenie in SAS for Real-Time Reporting and Analytics
Connect to real-time Opsgenie in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Opsgenie.
-
Connect to PivotalTracker Data in DBArtisan
Use wizards in DBArtisan to configure PivotalTracker as a data source.
-
Integrating LlamaIndex with Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Gong in real time.
-
Visualize ConvertAPI Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ConvertAPI into TIBCO Spotfire.
-
How to Connect the Power BI Service to Azure Data Catalog: Complete Guide
Connect to the CData Software Power BI Connector for Azure Data Catalog from PowerBI.com to provide real-time Azure Data Catalog across the organization.
-
Integrate Pinecone with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pinecone with External Services.
-
Integrating GitHub Copilot CLI with Sendwithus 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.
-
Bidirectional Access to Drift Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Drift in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Salesforce CRM Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce CRM Analytics data using
-
Connect to Mailjet Data in NetBeans
Connect to Mailjet in NetBeans with the data source configuration wizard.
-
How to use SQLAlchemy ORM to access Avaza Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Avaza.
-
Build Semantic Layer Views for MongoDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MongoDB.
-
Configure the CData JDBC Driver for Airtable in a Connection Pool in Tomcat
Connect to Airtable from a connection pool in Tomcat.
-
Connect to Oracle HCM Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle HCM Cloud from HeidiSQL.
-
Query ConvertKit Data in ColdFusion
Write standard ColdFusion data access code to connect to ConvertKit.
-
Connect QuickBooks to SQL Server through SSIS
Easily back up QuickBooks data to SQL Server using the QuickBooks Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with QuickBooks data using the QuickBooks ADO.NET Data Provider.
-
Connect to REST Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for REST in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Square Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Square for you.
-
Connect to PayPal Data in Ruby
Connect to PayPal in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Query Vercel Data in MySQL Workbench
Execute MySQL queries against live Vercel from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Forms
Provide connectivity to Google Forms through an SAP BusinessObjects universe.
-
How to Access CampaignMonitor Data Using Entity Framework
This article shows how to access CampaignMonitor using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Edit and Search External Salesforce CRM Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce CRM Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce CRM Analytics Data objects that you can access from apps and the dashboard.
-
Integrate with Live Redshift Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Redshift from the MuleSoft Anypoint Platform to integrate live Amazon Redshift into custom reports and dashboards.
-
Stream Float Data into Apache Kafka Topics
Access and stream Float in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build MVC Applications with Connectivity to Figshare Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Figshare from an ASP.NET MVC application.
-
Access Live Dropbox Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dropbox in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Build an ETL App for SAS xpt Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAS XPORT in Python with petl and the CData Connect AI Python SDK.
-
Connect Bright Data Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bright Data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Bullhorn CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Bullhorn CRM Data and provide access to live Bullhorn CRM for custom reports in the Power BI Service.
-
Connect to PostgreSQL from Asprova with CData Software ODBC Driver for PostgreSQL
This article shows how to connect faster to PostgreSQL data from Asprova.
-
Automated Continuous Oracle HCM Cloud Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Apache Cassandra.
-
Configure the CData JDBC Driver for Samanage in a Connection Pool in Tomcat
Connect to Samanage from a connection pool in Tomcat.
-
Import SAP SuccessFactors Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP SuccessFactors. In this article, you will use the OData format to import SAP SuccessFactors into Microsoft Power Query.
-
Viewing Cohere Data in RAD Studio Data Explorer
How to view Cohere in RAD Studio Data Explorer using the CData ODBC Driver for Cohere.
-
How to Work with AgileCRM Data in ETL Validator JDBC
Connect to AgileCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Instagram with Apache Airflow
Access and process Instagram in Apache Airflow using the CData JDBC Driver.
-
Access Xero Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Xero Accounting from HeidiSQL.
-
How to integrate Metabase with Azure Analysis Services Data
Use CData Connect AI to connect to live Azure Analysis Services and create an interactive dashboard in Metabase from Azure Analysis Services.
-
Enable the ZohoDesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoDesk.