CData Software - Knowledge Base
Recent Articles
-
Integrating Codex CLI with FreeAgent 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 Kintone Replication to Snowflake
Use CData Sync for automated, continuous, customizable Kintone replication to Snowflake.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OpenWeatherMap
Provide connectivity to OpenWeatherMap through an SAP BusinessObjects universe.
-
How to Connect to Live Facebook Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Facebook Ads securely in real time.
-
Getting Started with the CData ODBC Driver for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Dataverse.
-
Use the CData Software ODBC Driver for Freshteam in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshteam in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshteam.
-
DataBind Controls to Aircall Data in Delphi
DataBind to Aircall in Delphi with standard data access components and controls.
-
How to create BambooHR federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BambooHR in MySQL .
-
Build Apps with Live SAP Netweaver Gateway Data Using the Low-Code Development Platform of Mendix
Connect SAP Netweaver Gateway with Mendix to build apps using the CData JDBC Driver for SAP Netweaver Gateway.
-
How to Create Power BI Visual Reports with Real-Time Sage Intacct Data
Use CData Power BI Connectors to visualize Sage Intacct in Power BI.
-
Migrating data from CapsuleCRM to Databricks using CData SSIS Components.
Easily push CapsuleCRM to Databricks using the CData SSIS Tasks for CapsuleCRM and Databricks.
-
Create Reports with Strava Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Strava.
-
Connect Couchbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Couchbase with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Amazon S3 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 Amazon S3 for you.
-
Moving Data from Redis to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Redis data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate xBase Data to Multiple Databases via the CData Sync CLI
Replicate xBase to disparate databases with a single configuration.
-
How to connect to Clio Data from IntelliJ
Integrate connectivity to Clio with wizards in IntelliJ.
-
A PostgreSQL Interface for Microsoft OneDrive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft OneDrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ActiveCampaign Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Google Cloud SQL.
-
Connect to Pipeliner CRM Data in DBArtisan
Use wizards in DBArtisan to configure Pipeliner CRM as a data source.
-
Natively Connect to GetResponse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GetResponse. Leverage the native support for ODBC in PHP.
-
Automated SharePoint Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft SharePoint replication to Teradata.
-
Validate Autopilot Data with QuerySurge
Access and validate Autopilot in QuerySurge using the CData JDBC Driver.
-
Connect to Opsgenie Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Opsgenie and work with Opsgenie in your FileMaker applications.
-
Integrating LangChain with Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apollo within automated workflows.
-
Publish MailerSend-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MailerSend.
-
Connect to Raisers Edge NXT Data in NetBeans
Connect to Raisers Edge NXT in NetBeans with the data source configuration wizard.
-
Replicate Multiple Rebilly Accounts via the CData Sync CLI
Replicate multiple Rebilly accounts to one or many databases.
-
Integrate Reply.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reply.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reply.io.
-
Import Real-Time Jira Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Atlassian Jira in ColdFusion.
-
How to Access PabblySubscriptions Data Using Entity Framework
This article shows how to access PabblySubscriptions using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dynamic Google Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Ads to Infragistics XamDataGrid to build dynamic grids.
-
Access SAP SuccessFactors Data from MySQL in PHP
Connect to SAP SuccessFactors through the standard MySQL libraries in PHP.
-
Automate Front Data Replication to Azure Data Lake
Use CData Sync to customize and automate Front replication to Azure Data Lake.
-
Connect Reply.io to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Reply.io using the CData Python MCP Server.
-
Use Biml to Build SSIS Tasks to Replicate Redis Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Redis to SQL Server.
-
Build Dynamics NAV-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Dynamics NAV to explore live Dynamics NAV Data in GitHub Copilot to assist with building Dynamics NAV-powered applications.
-
Automated Continuous SAS xpt Replication to Databricks
Use CData Sync for automated, continuous, customizable SAS xpt replication to Databricks.
-
How to Access Live ADP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ADP enables you to integrate ADP into workflows built using Microsoft Power Automate Desktop.
-
Use Agno to Talk to Your Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Paylocity for you.
-
Use the CData Software ODBC Driver for Supabase in SAS for Real-Time Reporting and Analytics
Connect to real-time Supabase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Supabase.
-
Use the CData ODBC Driver for Microsoft OneDrive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft OneDrive in Excel.
-
How to connect and process Google Spanner from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Spanner.
-
Integrate with CSV Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CSV/TSV Files in SnapLogic.
-
Easily Integrate Brex Data in Lazarus Pascal IDE
Learn how to easily integrate live Brex in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to import Cloudant Data into Apache Solr
Use the CData Software JDBC Driver for Cloudant in Data Import Handler and create an automated import of IBM Cloudant to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Confluence Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Atlassian Confluence.
-
Visualize LinkedIn Ads 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 LinkedIn Ads into TIBCO Spotfire.
-
Access Snapchat Ads Data 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 Snapchat Ads.
-
Integrating OpenCode Terminal with Blackbaud FE NXT 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.
-
Creating Elasticsearch-Connected Applications in Unqork
You can use CData Connect AI to feed Elasticsearch to Unqork and build custom business apps.
-
Viewing ShipStation Data in RAD Studio Data Explorer
How to view ShipStation in RAD Studio Data Explorer using the CData ODBC Driver for ShipStation.
-
Connect to Quaderno Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Quaderno and work with Quaderno in your FileMaker applications.
-
Object-Relational Mapping (ORM) with Harvest Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Harvest into a Java-based ORM framework, Hibernate.
-
Connect to Live SAS Data Sets Data in MicroStrategy through CData Connect AI
Create a live connection to SAS Data Sets Data in CData Connect AI and connect to your SAS Data Sets from MicroStrategy.
-
Easily Integrate Access Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Access in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create an RPA flow for NASA Data in UiPath Studio
Use the NASA ODBC Driver to create workflows that access real-time NASA without any coding.
-
Use Biml to Build SSIS Tasks to Replicate Paddle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paddle to SQL Server.
-
Build Semantic Layer Views for Azure Data Lake Storage Data in APOS Live Data Gateway
Use the CData Connector for Azure Data Lake Storage in APOS Live Data Gateway to build Semantic Layer Views for Azure Data Lake Storage.
-
Connect to SharePoint Excel Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SharePoint Excel Services in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for JobNimbus in PyCharm
Connect to JobNimbus as an ODBC data source in PyCharm using the CData Software ODBC Driver for JobNimbus.
-
Build AI/ML Models with Live VWO Data using Dataiku
Connect VWO Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData SSIS Components for SAP Business One
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Business One.
-
Connect to BenchmarkEmail Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to BenchmarkEmail and work with BenchmarkEmail in your FileMaker applications.
-
Use ChatGPT to Talk to Your Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Cvent for you.
-
Getting Started with the CData JDBC Driver for Rootly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Rootly.
-
Access Live JotForm Data in Coginiti Pro
Connect to and query live JotForm from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect and Visualize Live Elasticsearch Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch into the Databricks platform and create visualization dashboards with real-time Elasticsearch.
-
Create Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.
-
Connect to Deel Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Deel to connect to Deel and execute queries in PowerBuilder.
-
How to connect PolyBase to Salesforce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce & Force.com.
-
Visualize Live Databricks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Databricks using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode Terminal with Google Cloud Storage 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 Antigravity CLI with Notion via CData CLI
Connect Notion to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to API Data from AWS Glue
Use CData Connect AI to gain access to live API from your AWS Glue jobs.
-
How to Work with Campaigner Data in AWS Glue Jobs Using JDBC
Connect to Campaigner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Ontraport Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Ontraport with the CData JDBC Driver for Ontraport.
-
Connect to Codat Data in Aqua Data Studio
Access Codat from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Phoenix with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Phoenix with External Services.
-
Use the CData SSIS Components to Insert New or Update Existing Square Records from SQL Server
Easily push SQL Server data to Square using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Square or update existing records with data from a SQL Server database.
-
How to Access Live Everhour Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Everhour enables you to integrate Everhour into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Xero Data 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 Xero Accounting for you.
-
How to Connect to Live CouchDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Apache CouchDB for you.
-
Connect to Figshare Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Figshare and work with Figshare in your FileMaker applications.
-
How to Connect to Amplitude Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amplitude. Leverage the pyodbc module for ODBC in Python.
-
Model IBM Cloud Object Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and IBM Cloud Object Storage, enabling the direct import of real-time IBM Cloud Object Storage.
-
How to Create Power BI Visual Reports with Real-Time Paddle Data
Use CData Power BI Connectors to visualize Paddle in Power BI.
-
How to Query Live SAP Fieldglass Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Fieldglass data in natural language using Python.
-
Use Crystal Reports to create reports with Salesforce data
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.
-
Getting Started with the CData ODBC Driver for Ontraport
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Ontraport.
-
Query Reckon Accounts Hosted Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Reckon Accounts Hosted entities in PHP by modeling them as objects.
-
How to connect to Sugar CRM Data from Spring Boot
Connect to Sugar CRM in a Spring Boot Application using the CData JDBC Driver for Sugar CRM
-
Access Google Ad Manager Data from MySQL in Amazon QuickSight
Connect to Google Ad Manager and build visualizations of Google Ad Manager using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Instagram Replication to SingleStore
Use CData Sync for automated, continuous, customizable Instagram replication to SingleStore.
-
Connect to Real-Time Brex Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Brex in Power Apps.
-
Create Dashboards and Visualize Live Azure Table Data in Geckoboard
Use CData Connect AI to connect to live Azure Table Storage and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Salesloft Data in Heroku for Use in Salesforce Connect
Replicate Salesloft to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate AgileCRM Data to Multiple Databases
Replicate AgileCRM to disparate databases with a point-and-click configuration.
-
Migrating data from Close to Snowflake using CData SSIS Components.
Easily push Close to Snowflake using the CData SSIS Tasks for Close and Snowflake.
-
How to connect and process Apache Cassandra from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Cassandra.