CData Software - Knowledge Base
Recent Articles
-
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.
-
Extend Google Sheets with Act-On Data
Make calls to Act-On from Google Apps Script via the API Server.
-
Build an OLAP Cube in SSAS from Neo4J Data
Establish a connection to Neo4J data from SQL Server Analysis Services, and use the Neo4J Data Provider to build OLAP cubes for use in analytics and reporting.
-
Establish a Live Connection with Demio Data using Tableau Bridge
The CData ODBC Driver for Demio enables you to integrate live Demio into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Postmark Data in FoxPro
Load Postmark into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for Amplitude from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amplitude to connect to Amplitude from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amplitude in Excel.
-
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.
-
Creating SharePoint-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft SharePoint to Unqork and build custom business apps.
-
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.
-
How to Query Live Reckon Accounts Hosted Data in Perplexity MacOS Desktop
Connect to and query live Reckon Accounts Hosted Data in Perplexity Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy
Connect to Discourse in MicroStrategy Developer using the CData Software ODBC Driver for Discourse.
-
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.
-
Integrate with Asana Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Asana to a JSON file on disk.
-
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.
-
Publish Crystal Reports on Stripe Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stripe.
-
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.
-
Query ZohoPeople Data in DataGrip
Create a Data Source for ZohoPeople in DataGrip and use SQL to query live ZohoPeople.
-
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.
-
Connect to GitLab from a Connection Pool in WebLogic
Use the CData JDBC Driver for GitLab to connect to GitLab from Web applications running on WebLogic.
-
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
-
Integrating Antigravity CLI with Bannerbear via CData CLI
Connect Bannerbear to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
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 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.
-
Access Live Certinia Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Certinia data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
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.
-
Connect and Visualize Live Presto Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Presto into the Databricks platform and create visualization dashboards with real-time Presto.
-
Stream eBay Data into Apache Kafka Topics
Access and stream eBay in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Oracle Service Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Service Cloud in the Pentaho Data Integration tool.
-
Create Reports with ZohoPeople Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoPeople.
-
Connect PDFMonkey to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PDFMonkey with IBM WebSphere for seamless data integration and connectivity.
-
Integrating LangChain with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on JSON within automated workflows.
-
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.
-
Integrating Kiro CLI with SAS xpt 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 connect to Microsoft Teams Data with Squirrel SQL client
Connect to Microsoft Teams and execute queries in the Squirrel SQL Client.
-
Replicate Multiple Blackbaud FE NXT Accounts via the CData Sync CLI
Replicate multiple Blackbaud FE NXT accounts to one or many databases.
-
Use Claude to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Exchange for you.
-
Connect to Browserless Data from PowerBuilder via JDBC
This article demonstrates how to access Browserless from PowerBuilder using the Browserless JDBC Driver.
-
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.
-
Analyze PagerDuty Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PagerDuty with the CData JDBC Driver for PagerDuty.
-
Prepare, Blend, and Analyze Short.io Data in Alteryx Designer (ODBC)
Build workflows to access live Short.io for self-service data analytics.
-
Build a PostgreSQL Interface for OData Services using the CData JDBC Driver
Use the Remoting features of the OData JDBC Driver to create a PostgreSQL entry-point for data access.
-
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 Rootly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Rootly and build web apps with connectivity to live Rootly.
-
Integrating Cursor CLI with Avro 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.
-
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.
-
How to Connect the Power BI Service to Coinbase: Complete Guide
Connect to the CData Software Power BI Connector for Coinbase from PowerBI.com to provide real-time Coinbase across the organization.
-
Enable the Microsoft OneDrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft OneDrive.
-
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!
-
Analyze Google Search Results in Looker
Use CData Connect AI to connect to Google Search Results from Looker and build custom apps using live Google Search.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy Desktop
Connect to Nuclia in MicroStrategy Desktop using the CData Software ODBC Driver for Nuclia.
-
Bind Live SingleStore Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SingleStore data
-
Access SAP SuccessFactors LMS Data from MySQL in Amazon QuickSight
Connect to SAP SuccessFactors LMS and build visualizations of SAP SuccessFactors LMS using a MySQL Connection in Amazon QuickSight.
-
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.
-
Create Datasets from Freshdesk in Domo Workbench and Build Visualizations of Freshdesk Data in Domo
Use the CData Software ODBC Driver for Freshdesk to create datasets from Freshdesk in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous xBase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable xBase replication to Azure SQL Database.
-
Integrate Live Oracle Eloqua Reporting Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Eloqua Reporting to Blue Prism using the CData ODBC Driver for Oracle Eloqua Reporting to create automated workflows for repetitive business tasks.
-
Analyze Egnyte Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Egnyte from Power Pivot. You will use the Table Import Wizard to load Egnyte. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import JobNimbus Data into IBM SPSS Modeler
Integrate JobNimbus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Object-Relational Mapping (ORM) with Marketo 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 Marketo into a Java-based ORM framework, Hibernate.
-
Integrating Kiro CLI with Aircall 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.
-
Natively Connect to JotForm Data in PHP
The CData ODBC driver for JotForm enables you to create PHP applications with connectivity to JotForm. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Invoiced in a Connection Pool in Tomcat
Connect to Invoiced from a connection pool in Tomcat.
-
Extend Google Sheets with Snowflake Data
Make calls to Snowflake from Google Apps Script via the API Server.
-
Import Real-Time Hive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Hive in ColdFusion.
-
IBM Informix Reporting in OBIEE with the IBM Informix JDBC Driver
Deploy the IBM Informix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Hacker News Data in CloverDX (formerly CloverETL)
Transfer Hacker News using the visual workflow in the CloverDX data integration tool.
-
Integrating OpenCode Terminal with IBM Cloud Object 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.
-
Create Power BI Reports on Real-Time Instagram Data
Use the CData ODBC Driver for Instagram to visualize Instagram in Power BI Desktop.
-
How to integrate Act-On with Apache Airflow
Access and process Act-On in Apache Airflow using the CData JDBC Driver.
-
Integrate Live Exact Online Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Migrating data from Webex to Databricks using CData SSIS Components.
Easily push Webex to Databricks using the CData SSIS Tasks for Webex and Databricks.
-
Access Parquet Data from MySQL in PHP
Connect to Parquet through the standard MySQL libraries in PHP.
-
Visualize Clockify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clockify.
-
Integrating LangGraph with Cvent Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cvent within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Superchat
Provide connectivity to Superchat through an SAP BusinessObjects universe.
-
Connect to Sentry Data in Aqua Data Studio
Access Sentry from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Xero Accounting within intelligent workflows.
-
Design BIRT Reports on Authorize.Net Data
Provide current Authorize.Net to your embedded analytics.
-
Integrating Claude Code CLI with Oracle Eloqua Reporting 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.
-
Bind Live Salesforce Marketing Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Marketing data
-
Getting Started with the CData SSIS Components for Amazon S3
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon S3.
-
Connect to SparkPost Data in JRuby
Create a simple JRuby app with access to live SparkPost.
-
Create Reports from Airtable Data in Looker Studio
Use CData Connect AI to gain access to live Airtable and create custom reports in Looker Studio.
-
Visualize ZohoDesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoDesk.
-
Working with Zoho Projects Data in LINQPad
Execute LINQ queries to Zoho Projects in LINQPad.
-
Getting Started with the CData Tableau Connector for Copper
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Epicor Kinetic Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Apache Kafka.
-
Integrate Open WebUI with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP SuccessFactors from within the chat interface.
-
Natively Connect to SQL Server Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft SQL Server. Leverage the native support for ODBC in PHP.
-
Build Data Flows from SQL Server to IBM Informix through SSIS
Easily push SQL Server data to IBM Informix using the CData SSIS Tasks for IBM Informix.
-
Import Real-Time Mixpanel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mixpanel in ColdFusion.
-
Connect to Mailjet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailjet in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load ZohoDesk Data in Informatica PowerCenter
Create a simple Workflow for ZohoDesk in Informatica PowerCenter.
-
Connect to Harvest Data in DBArtisan
Use wizards in DBArtisan to configure Harvest as a data source.