CData Software - Knowledge Base
Recent Articles
-
Connect to Access from Asprova with CData Software ODBC Driver for Access
This article shows how to connect faster to Access data from Asprova.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Desktop
Connect to Zoho Projects in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Projects.
-
How to connect to Dynamics NAV Data from IntelliJ
Integrate connectivity to Microsoft Dynamics NAV with wizards in IntelliJ.
-
Natively Connect to Jira Assets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jira Assets. Leverage the native support for ODBC in PHP.
-
How to work with Google Ad Manager Data in Apache Spark using SQL
Access and process Google Ad Manager Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP from Asprova with CData Software ODBC Driver for SAP
This article shows how to connect faster to SAP data from Asprova.
-
How to Work with TaxJar Data in AWS Glue Jobs Using JDBC
Connect to TaxJar from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous XML Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable XML replication to Google BigQuery.
-
Use the CData ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite data in MicroStrategy Developer using the CData ODBC Driver for NetSuite.
-
Replicate Multiple ZohoPeople Accounts
Replicate multiple ZohoPeople accounts to one or many databases.
-
Create BambooHR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BambooHR Data from OutSystems and build custom enterprise apps using live BambooHR.
-
Extract, Transform, and Load Telegram Data in Informatica PowerCenter
Create a simple Workflow for Telegram in Informatica PowerCenter.
-
Build Sugar CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sugar to explore live Sugar CRM Data in Claude Code to assist with building Sugar CRM-powered applications.
-
Connecting Mastra with Basecamp 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 Basecamp, no replication required.
-
Integrating LangChain with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Impala within automated workflows.
-
Integrating Codex CLI with Drift 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 work with Adobe Target Data in Apache Spark using SQL
Access and process Adobe Target Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Airtable Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Airtable in Airbyte.
-
Use the CData API Server to Access PayPal Data in Microsoft PowerPivot
Use the CData API Server to connect to live PayPal in the Power Pivot business intelligence tool.
-
Use Dash to Build to Web Apps on Neo4J Data
Create Python applications that use pandas and Dash to build Neo4J-connected web apps.
-
Connect to QuickBooks Time Data in HULFT Integrate
Connect to QuickBooks Time as a JDBC data source in HULFT Integrate
-
Integrate with Confluence Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Atlassian Confluence in SnapLogic.
-
ETL HubDB in Oracle Data Integrator
This article shows how to transfer HubDB into a data warehouse using Oracle Data Integrator.
-
Connect to Bannerbear Data in Ruby
Connect to Bannerbear in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Landbot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Landbot.
-
Use Grok to Talk to Your Act-On 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 Act-On for you.
-
Access Live Office 365 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Office 365 from your Excel spreadsheets.
-
Analyze SAP Business Warehouse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Business Warehouse with the CData JDBC Driver for SAP Business Warehouse.
-
Use the CData ODBC Driver for Spark from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Spark to connect to Apache Spark SQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Spark SQL in Excel.
-
Viewing Yelp Data in RAD Studio Data Explorer
How to view Yelp in RAD Studio Data Explorer using the CData ODBC Driver for Yelp.
-
Connect to QuickBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks Desktop from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Create Tally Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tally from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Supabase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Supabase replication to IBM DB2.
-
Enable the Bitbucket JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bitbucket.
-
Migrating data from ConstantContact to Databricks using CData SSIS Components.
Easily push ConstantContact to Databricks using the CData SSIS Tasks for ConstantContact and Databricks.
-
Build a Simple VCL Application for AdRoll Data
How to build a simple VCL Application to view AdRoll in RAD Studio using the CData ODBC Driver for AdRoll.
-
Automated Continuous Exact Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon S3.
-
Consume PhantomBuster OData Feeds in PowerBuilder
This article demonstrates how to consume PhantomBuster as OData feeds from PowerBuilder using the API Server.
-
Access Live Hubstaff Data in Coginiti Pro
Connect to and query live Hubstaff from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Salesloft Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesloft with the DevExpress Windows Forms and Web controls to provide Salesloft to a chart.
-
Work with Postmark Data in FoxPro
Load Postmark into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Stripe Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe from your Google Sheets.
-
Connect to Office 365 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Office 365 from Filemaker Pro on Mac.
-
Create Dashboards and Visualize Live YouTube Analytics Data in Geckoboard
Use CData Connect AI to connect to live YouTube Analytics and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use Dash to Build to Web Apps on CSV Data
Create Python applications that use pandas and Dash to build CSV-connected web apps.
-
Create Reports from Power BI XMLA Data in Looker Studio
Use CData Connect AI to gain access to live Power BI XMLA and create custom reports in Looker Studio.
-
Connect to Twitter Ads from Asprova with CData Software ODBC Driver for Twitter Ads
This article shows how to connect faster to Twitter Ads data from Asprova.
-
Feed WordPress Data into FineReport
How to set WordPress as a JDBC data source in FineReport.
-
Natively Connect to ScrapingBee Data in PHP
The CData ODBC driver for ScrapingBee enables you to create PHP applications with connectivity to ScrapingBee. Leverage the native support for ODBC in PHP.
-
Build SAP Ariba Source Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Ariba Source and build visualizations in Tableau Cloud.
-
Add Missive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Missive with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind NetSuite Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for NetSuite with the DevExpress Windows Forms and Web controls to provide NetSuite CRM & ERP to a chart.
-
Replicate Mode Data from PowerShell
Write a quick PowerShell script to query Mode. Use connectivity to the live data to replicate Mode to SQL Server.
-
How to publish and share Asana Data dashboards with Tableau Server
The CData ODBC driver for Asana enables you integrate Asana into Tableau dashboards.
-
Integrate Live Salesforce CRM Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect and Query Live CSV Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CSV/TSV Files into Databricks
-
Use Dash to Build to Web Apps on Microsoft Planner Data
Create Python applications that use pandas and Dash to build Microsoft Planner-connected web apps.
-
How to connect and process Microsoft Dynamics CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Dynamics CRM.
-
Integrating QuickBooks Online Data in Talend Cloud Data Management Platform
Connect QuickBooks Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks Online.
-
Build Sybase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sybase and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Mouseflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mouseflow in Excel.
-
Consume CircleCI OData Feeds in SAP Lumira
Use the API Server to create data visualizations on CircleCI feeds that reflect any changes in SAP Lumira.
-
Build Dynamics CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Dynamics CRM Data from Choreo and build custom apps using live Microsoft Dynamics CRM.
-
Connect to Hacker News Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hacker News from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to use SQLAlchemy ORM to access Active Directory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Active Directory.
-
Object-Relational Mapping (ORM) with JDBC-ODBC Bridge 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 JDBC-ODBC Bridge into a Java-based ORM framework, Hibernate.
-
Connect Blackbaud FE NXT Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Blackbaud FE NXT using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Gorgias Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gorgias to connect to Gorgias and execute queries in PowerBuilder.
-
Automated Continuous GitHub Replication to MongoDB
Use CData Sync for automated, continuous, customizable GitHub replication to MongoDB.
-
Connect to BenchmarkEmail Data in Aqua Data Studio
Access BenchmarkEmail from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Harvest Data in RazorSQL
Connect to Harvest from wizards and query Harvest from the GUI in the RazorSQL database management tool.
-
Integrating Cursor CLI with Pipeliner CRM 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.
-
Integrate Live Dynamics CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dynamics CRM.
-
Connect to ZohoInvoice 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 ZohoInvoice and work with ZohoInvoice in your FileMaker application.
-
Import Real-Time Active Directory Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Active Directory in ColdFusion.
-
How to connect to Microsoft Teams Data with Squirrel SQL client
Connect to Microsoft Teams and execute queries in the Squirrel SQL Client.
-
Connect to Real-Time ConvertKit Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConvertKit in Power Apps.
-
Build Sybase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sybase and build Sybase-connected web apps with Axios.
-
Create Datasets from Bitly in Domo Workbench and Build Visualizations of Bitly Data in Domo
Use the CData Software ODBC Driver for Bitly to create datasets from Bitly in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Float 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 Float into TIBCO Spotfire.
-
Automate SAP SuccessFactors Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Synapse.
-
Connect to Mailjet Data in Ruby
Connect to Mailjet in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Prepare, Blend, and Analyze Short.io Data in Alteryx Designer (ODBC)
Build workflows to access live Short.io for self-service data analytics.
-
How to create NetSuite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for NetSuite CRM & ERP in MySQL .
-
Migrating data from ClickUp to Snowflake using CData SSIS Components.
Easily push ClickUp to Snowflake using the CData SSIS Tasks for ClickUp and Snowflake.
-
Build a Simple VCL Application for ConstantContact Data
How to build a simple VCL Application to view ConstantContact in RAD Studio using the CData ODBC Driver for ConstantContact.
-
Connect to BenchmarkEmail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time BenchmarkEmail using standard SQL.
-
Build Superchat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Superchat and build web apps with connectivity to live Superchat.
-
Build FHIR-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live FHIR.
-
Build ZendeskSell-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ZendeskSell Data in Cursor to assist with building ZendeskSell-powered applications.
-
Analyze SageHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SageHR with the CData JDBC Driver for SageHR.
-
Build AI/ML Models with Live XML Data using Dataiku
Connect XML Data with Dataiku using the CData JDBC Driver for XML.
-
Analyze YouTube Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for YouTube Analytics from Power Pivot. You will use the Table Import Wizard to load YouTube Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Enable the Microsoft OneDrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft OneDrive.
-
Replicate Billsby Data from PowerShell
Write a quick PowerShell script to query Billsby. Use connectivity to the live data to replicate Billsby to SQL Server.
-
Creating Freshservice-Connected Applications in Unqork
You can use CData Connect AI to feed Freshservice to Unqork and build custom business apps.
-
Connect to Impala from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Impala, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Bind Live SingleStore Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SingleStore data
-
Connect to LinkedIn Ads from Asprova with CData Software ODBC Driver for LinkedIn Ads
This article shows how to connect faster to LinkedIn Ads data from Asprova.
-
Use JayDeBeApi to access Zoho Projects Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Projects.