CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Tickspot
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tickspot.
-
Connecting GenSpark with IBM Informix Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to IBM Informix without any replication or custom integration required.
-
Extract, Transform, and Load Freshservice Data in Informatica PowerCenter
Create a simple Workflow for Freshservice in Informatica PowerCenter.
-
How to Create Power BI Visual Reports with Real-Time Oracle Financials Cloud Data
Use CData Power BI Connectors to visualize Oracle Financials Cloud in Power BI.
-
Visualize Teradata 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 Teradata into TIBCO Spotfire.
-
DataBind Charts to Aweber Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Aweber from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrating GitHub Copilot CLI with Apache Parquet 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 integrate Metabase with ShipStation Data
Use CData Connect AI to connect to live ShipStation and create an interactive dashboard in Metabase from ShipStation.
-
Deploy the ADO.NET Provider for Aweber on an SSRS Report Server
Connect to Aweber from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy
Connect to WordPress in MicroStrategy Developer using the CData Software ODBC Driver for WordPress.
-
Build Voice Agents in ElevenLabs with access to Live Oracle HCM Cloud Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle HCM Cloud.
-
Automated Continuous Copper Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Copper replication to Google BigQuery.
-
Automated Continuous FormSite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FormSite replication to Azure SQL Database.
-
Create Reports with Apollo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apollo.
-
Build IBM Cloud Object Storage-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM Cloud Object Storage and build web apps with connectivity to live IBM Cloud Object Storage.
-
Stream Google Directory Data into Apache Kafka Topics
Access and stream Google Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Oracle Eloqua Reporting 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 Oracle Eloqua Reporting into TIBCO Spotfire.
-
Access Live FHIR Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FHIR into the statistical analysis tools available in SAS JMP. This article shows how to use FHIR in the Graph Builder and Query Builder.
-
Integrate Cline with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Inventory from within your IDE.
-
Build Automated Splunk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Splunk and build automated workflows in Zapier.
-
Replicate DocuSign Data from PowerShell
Write a quick PowerShell script to query DocuSign. Use connectivity to the live data to replicate DocuSign to SQL Server.
-
Automated Continuous Zuora Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zuora replication to SQL Server.
-
How to connect to Clockify Data with Squirrel SQL client
Connect to Clockify and execute queries in the Squirrel SQL Client.
-
Integrating Claude Code CLI with Onfleet 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Qualaroo
Provide connectivity to Qualaroo through an SAP BusinessObjects universe.
-
Use Manus AI to Talk to Your Google Ad Manager 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 Google Ad Manager.
-
Migrating data from Drift to Snowflake using CData SSIS Components.
Easily push Drift to Snowflake using the CData SSIS Tasks for Drift and Snowflake.
-
Create Apps from MariaDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to MariaDB Data and build apps from live MariaDB in Qlik Sense Cloud.
-
Connect to Elorus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Elorus.
-
Access Live Oracle Sales Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Sales from your Google Sheets.
-
Automate Azure Data Lake Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure Data Lake Storage replication to Azure Synapse.
-
Integrate Hugging Face with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hugging Face with External Services.
-
Use JayDeBeApi to access Strava Data in Python
Use standard Python scripting and the development environment of your choice to access live Strava.
-
Integrate Zoho Creator Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Creator and integrate live Zoho Creator into your Power Automate tasks.
-
Integrate Live DocuSign Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automated Google Ads Data Replication to Teradata
Use CData Sync to Customize and automate Google Ads replication to Teradata.
-
Working with Power BI XMLA Data in LINQPad
Execute LINQ queries to Power BI XMLA in LINQPad.
-
Visualize Live Azure Data Lake Storage Data in the Power BI Service
Use CData Connect AI to connect to live Azure Data Lake Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code CLI with Suadeo 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.
-
Getting Started with the CData SSIS Components for Kintone
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Kintone.
-
Integrating Cursor CLI with Salesforce Pardot 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 Cline with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP SuccessFactors LMS from within your IDE.
-
Automated Continuous Wrike Replication to MySQL
Use CData Sync for automated, continuous, customizable Wrike replication to MySQL.
-
Integrate LibreChat with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live OData from within the chat interface.
-
A PostgreSQL Interface for Spark Data using the CData ODBC Driver
Use the SQL Gateway and Spark ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Facebook Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Facebook and Dataflow to import and use Facebook in Power Apps.
-
Automated Continuous AgileCRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AgileCRM replication to Google BigQuery.
-
Create a Data Access Object for Dropbox Data using JDBI
A brief overview of creating a SQL Object API for Dropbox in JDBI.
-
Getting Started with the CData Excel Add-In for Shopify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Shopify.
-
Build Pipelines with Live Marketo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Marketo from Google Cloud Data Fusion, enabling the integration of live Marketo into the building and management of effective data pipelines.
-
Integrate with Pipedrive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pipedrive to a JSON file on disk.
-
Build a PostgreSQL Interface for Browserless Data using the CData JDBC Driver
Use the Remoting features of the Browserless JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Power BI XMLA Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Power BI XMLA to Blue Prism using the CData ODBC Driver for Power BI XMLA to create automated workflows for repetitive business tasks.
-
Build Voice Agents in ElevenLabs with access to Live Google Search Results
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Search.
-
Integrate Live Cohere Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cohere to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with Eventbrite Data in JReport Designer
Create charts and reports based on Eventbrite in JReport Designer.
-
Enable the WordPress JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with WordPress.
-
Visualize Apollo Data in TIBCO Spotfire through ADO.NET
Integrate Apollo into dashboards in TIBCO Spotfire.
-
Build Dashboards with Oracle HCM Cloud Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in Dundas BI.
-
Connect to Toggl Data in NetBeans
Connect to Toggl in NetBeans with the data source configuration wizard.
-
Integrate Live MariaDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MariaDB to Blue Prism using the CData ODBC Driver for MariaDB to create automated workflows for repetitive business tasks.
-
Build a Singer.io Tap for Wrike With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Wrike data using
-
Integrating Demio Data in Talend Cloud Data Management Platform
Connect Demio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Python Connector for Facebook Ads
Learn to install and license the CData Python Connector
-
Integrating Salesforce Data 360 Data in Talend Cloud Data Management Platform
Connect Salesforce Data 360 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce Data 360.
-
Connect to Hugging Face Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Hugging Face and work with Hugging Face in your FileMaker applications.
-
Natively Connect to Aha! Data in PHP
The CData ODBC driver for Aha! enables you to create PHP applications with connectivity to Aha!. Leverage the native support for ODBC in PHP.
-
Build Tanda-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Tanda.
-
Integrate Real-Time Access to Stripe in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Stripe in real time.
-
How to Connect DBeaver to iContact via a JDBC Driver
Manage iContact with visual tools in DBeaver like the query browser.
-
Query, Visualize, and Share live Shopify Data in Redash
Use CData Connect AI to connect to live Shopify in Redash for querying, visualizing, and sharing.
-
DataBind Controls to Mailjet Data in C++Builder
DataBind to Mailjet in C++Builder with standard components and controls.
-
Visualize SurveyMonkey Data in Tableau
The CData ODBC driver for SurveyMonkey enables you integrate SurveyMonkey into Tableau dashboards.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Asana using the Model Context Protocol.
-
Build Charts with Epicor Kinetic Data in Clear Analytics
Create dynamic charts and perform analytics based on Epicor Kinetic in Clear Analytics.
-
Integrating Antigravity CLI with Miro via CData CLI
Connect Miro to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Dashboards with Supabase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Supabase in Dundas BI.
-
Automated Continuous Salesforce Marketing Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Apache Kafka.
-
Build AI/ML Models with Live Omnisend Data using Dataiku
Connect Omnisend Data with Dataiku using the CData API Driver for JDBC.
-
Extract, Transform, and Load Rootly Data in Informatica PowerCenter
Create a simple Workflow for Rootly in Informatica PowerCenter.
-
How to Connect to Mixpanel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mixpanel. Leverage the pyodbc module for ODBC in Python.
-
How to Use a Microsoft Access Database to Update Active Directory Data in Real Time
Update Active Directory data by creating a linked table in Microsoft Access with the CData Active Directory ODBC Driver.
-
Import Real-Time Salesforce Marketing Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce Marketing Cloud in ColdFusion.
-
Visualize Live Amazon DynamoDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon DynamoDB into custom reports in Power BI.
-
Query Helpscout Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Helpscout from Node.js.
-
Build MVC Applications with Connectivity to Tavily Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tavily from an ASP.NET MVC application.
-
Operational Reporting on JDBC-ODBC Bridge Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JDBC-ODBC Bridge.
-
Integrating Dataiku with Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Service Cloud.
-
Natively Connect to ConvertKit Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConvertKit. Leverage the native support for ODBC in PHP.
-
How to connect and process Simplesat from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Simplesat.
-
Create Active Directory-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Active Directory Data from OutSystems and build custom enterprise apps using live Active Directory.
-
Automated Continuous Freshteam Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshteam replication to AlloyDB.
-
Working with OpenWeatherMap Data in LINQPad
Execute LINQ queries to OpenWeatherMap in LINQPad.
-
Connect to Notion Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Vault CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Veeva Vault & Vault CRM.
-
Use the CData Software ODBC Driver for Google Drive in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Drive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Drive.
-
How to Easily Query Testmonitor Data in OpenOffice Base
Connect to Testmonitor data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
ETL ChargeOver in Oracle Data Integrator
This article shows how to transfer ChargeOver into a data warehouse using Oracle Data Integrator.
-
Connect to Salesforce Marketing Data in RazorSQL
Connect to Salesforce Marketing from wizards and query Salesforce Marketing Cloud from the GUI in the RazorSQL database management tool.
-
How to Connect to & Open Gong Data in Microsoft Excel
This article uses the CData ODBC driver for Gong to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.