CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Cvent Data in Lazarus Pascal IDE
Learn how to easily integrate live Cvent in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Query Strava Data in QlikView over ODBC
Create data visualizations with Strava in QlikView.
-
How to connect and process Discord from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Discord.
-
Publish Crystal Reports on Google Drive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Drive.
-
Analyze Smartsheet Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Smartsheet and visualize Smartsheet in SAP Analytics Cloud.
-
Add ShipStation Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ShipStation with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Marketo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Marketo replication to SingleStore.
-
Build AI/ML Models with Live Microsoft Exchange Data using Dataiku
Connect Microsoft Exchange Data with Dataiku using the CData JDBC Driver for Exchange.
-
Automated Continuous PabblySubscriptions Replication to MySQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to MySQL.
-
Analyze Gong Data in Cognos Analytics
Use CData Connect AI to connect to Gong Data from Cognos Analytics and analyze live Gong.
-
Prepare, Blend, and Analyze Redshift Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon Redshift for self-service data analytics.
-
How to Connect Flowise AI Agents to Live IBM Informix Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live IBM Informix without replication.
-
Publish Reports with ZarMoney Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZarMoney.
-
Connect to Freshdesk Data in JRuby
Create a simple JRuby app with access to live Freshdesk.
-
Visualize Live MYOB AccountRight Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MYOB AccountRight into custom reports in Power BI.
-
Integrating Claude Code CLI with Elasticsearch 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.
-
Automate Zuora Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zuora and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Data Visualizations in Cognos BI with Attio Data
Access Attio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData ODBC Driver for Paylocity in Microsoft Power Query
You can use the CData Paylocity ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paylocity into Microsoft Power Query.
-
DataBind Controls to Exa Data in Delphi
DataBind to Exa in Delphi with standard data access components and controls.
-
Visualize Chargebee 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 Chargebee into TIBCO Spotfire.
-
Visualize Live ActiveCampaign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ActiveCampaign.
-
Build Databricks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Databricks and build visualizations in Tableau Cloud.
-
Build Apps with Live Facebook Ads Data Using the Low-Code Development Platform of Mendix
Connect Facebook Ads with Mendix to build apps using the CData JDBC Driver for Facebook Ads.
-
Add ADP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ADP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Miro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Miro to a database.
-
Enable the GraphQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GraphQL.
-
How to Access Live Deel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Deel enables you to integrate Deel into workflows built using Microsoft Power Automate Desktop.
-
How to Query Live Facebook Data in Claude Desktop
Connect to and query live Facebook Data in Claude Desktop using CData MCP Server.
-
Prepare, Blend, and Analyze Act-On Data in Alteryx Designer (ODBC)
Build workflows to access live Act-On for self-service data analytics.
-
Publish Avalara AvaTax-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Avalara AvaTax.
-
Build a Simple VCL Application for CloudConvert Data
How to build a simple VCL Application to view CloudConvert in RAD Studio using the CData ODBC Driver for CloudConvert.
-
Connect to SAS xpt Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SASxpt and the Script function in FileMaker Pro to connect to SAS xpt and work with SAS XPORT in your FileMaker application.
-
How to Seamlessly Import Sage Cloud Accounting Data into IBM SPSS Modeler
Integrate Sage Cloud Accounting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
LINQ to Eventbrite Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Eventbrite Data Provider.
-
How to Access Live SingleStore Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SingleStore enables you to integrate SingleStore into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous JSON Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable JSON replication to Azure SQL Database.
-
How to Access Elorus Data Using Entity Framework
This article shows how to access Elorus using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (ODBC)
Build workflows to access live Jira Assets for self-service data analytics.
-
Automate Wave Financial Data Replication to Azure Synapse
Use CData Sync to customize and automate Wave Financial replication to Azure Synapse.
-
Getting Started with the CData JDBC Driver for SendInBlue
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendInBlue.
-
How to Connect the Power BI Service to Bannerbear: Complete Guide
Connect to the CData Software Power BI Connector for Bannerbear from PowerBI.com to provide real-time Bannerbear across the organization.
-
Replicate Multiple Phoenix Accounts via the CData Sync CLI
Replicate multiple Phoenix accounts to one or many databases.
-
Building Dynamic Web Pages with Clio Data Using AngularJS
Create single-page applications with live connectivity to Clio using the CData API Server.
-
Getting Started with the CData Excel Add-In for Tanda
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tanda.
-
Connect to Onfleet Data in RapidMiner
Integrate Onfleet with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Automated Paylocity-Connected Workflows in Zapier
Use CData Connect AI to connect to live Paylocity and build automated workflows in Zapier.
-
Analyze Klaviyo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Klaviyo and visualize Klaviyo in SAP Analytics Cloud.
-
Connect to Apollo Data in ACL Analytics
Connect to Apollo via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apollo.
-
How to Connect the Power BI Service to ServiceNow: Complete Guide
Connect to the CData Software Power BI Connector for ServiceNow from PowerBI.com to provide real-time ServiceNow across the organization.
-
Connect Sybase IQ to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sybase IQ with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Claude Code CLI with Snapchat Ads 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.
-
Perform Batch Operations with Cloudant Data in Apache NiFi
Connect to IBM Cloudant and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Campaigner Data using Dataiku
Connect Campaigner Data with Dataiku using the CData API Driver for JDBC.
-
Working with SAP SuccessFactors LMS Data in LINQPad
Execute LINQ queries to SAP SuccessFactors LMS in LINQPad.
-
Integrating Boomi Agentstudio with GraphQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GraphQL, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live Attio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Attio.
-
Integrate Real-Time Access to SAP SuccessFactors LMS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP SuccessFactors LMS in real time.
-
Connect to Beeminder Data in RazorSQL
Connect to Beeminder from wizards and query Beeminder from the GUI in the RazorSQL database management tool.
-
Connect to Epicor Kinetic Data in CloverDX (formerly CloverETL)
Transfer Epicor Kinetic using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous CapsuleCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to delimited files (CSV/TSV).
-
Automated Continuous Oracle Eloqua Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to OneLake in Microsoft Fabric.
-
Integrating OpenCode Terminal with Pinterest 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.
-
Access Live Omnisend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Omnisend into the statistical analysis tools available in SAS JMP. This article shows how to use Omnisend in the Graph Builder and Query Builder.
-
How to Access SuiteCRM Data Using Entity Framework
This article shows how to access SuiteCRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Delighted Data in Heroku for Use in Salesforce Connect
Replicate Delighted to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Semantic Layer Views for Landbot Data in APOS Live Data Gateway
Use the CData Connector for Landbot in APOS Live Data Gateway to build Semantic Layer Views for Landbot.
-
Connecting Mastra with GitHub 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 GitHub, no replication required.
-
Connect to PDFMonkey Data from a Connection Pool in JBoss
Integrate PDFMonkey into Java servlets: Use the Management Console in JBoss to install the PDFMonkey JDBC Driver.
-
Bridge Facebook Ads Connectivity with Apache NiFi
Access and process Facebook Ads in Apache NiFi using the CData JDBC Driver.
-
Analyze Wave Financial Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Wave Financial in Microsoft R Open.
-
How to Connect to Outlook Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Outlook. Leverage the pyodbc module for ODBC in Python.
-
Connect to Zoho Inventory Data from a Connection Pool in JBoss
Integrate Zoho Inventory into Java servlets: Use the Management Console in JBoss to install the Zoho Inventory JDBC Driver.
-
Create Customer.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Customer.io data access from reports, embedded analytics, and more.
-
Create Confluence-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Confluence Data from Klipfolio and build custom visualizations using live Atlassian Confluence.
-
How to load HubDB data into Elasticsearch via Logstash
Introducing a simple method to load HubDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live JSON Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live JSON securely in real time.
-
Load Keap Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Keap to a database.
-
Moving Data from SendGrid to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SendGrid data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Datadog Data (MySQL Remoting via JDBC)
Use the Remoting features of the Datadog JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Guru Data in Apache Spark using SQL
Access and process Guru Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Float Data in the Pentaho Report Designer
Publish reports based on Float in the Pentaho BI tool.
-
Connect to Redshift Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Amazon Redshift and execute queries in PowerBuilder.
-
Connect FreeAgent to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FreeAgent with IBM WebSphere for seamless data integration and connectivity.
-
Configure the CData JDBC Driver for TigerGraph in a Connection Pool in Tomcat
Connect to TigerGraph from a connection pool in Tomcat.
-
ETL Microsoft Teams in Oracle Data Integrator
This article shows how to transfer Microsoft Teams into a data warehouse using Oracle Data Integrator.
-
How to connect to ChartMogul Data in DBVisualizer
Integrate ChartMogul with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Work with Mistral AI Data in AWS Glue Jobs Using JDBC
Connect to Mistral AI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Twilio-Connected Nintex Workflows
Use CData Connect AI to connect to Twilio Data from Nintex Workflow Cloud and build custom workflows using live Twilio.
-
Connect to Zoho Inventory Data in Ruby
Connect to Zoho Inventory in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with live Salesforce Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce & Force.com in Jitterbit.
-
Integrate Real-Time Access to Outreach.io in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Outreach.io in real time.
-
Use ChatGPT to Talk to Your Klaviyo 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 Klaviyo for you.
-
Use the CData ODBC Driver for Dynamics 365 Business Central from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dynamics 365 Business Central in Excel.
-
How to Access Slack Data Using Entity Framework
This article shows how to access Slack using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Live Freshservice Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshservice to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Configure the CData JDBC Driver for Planio in a Connection Pool in Tomcat
Connect to Planio from a connection pool in Tomcat.
-
Automated Continuous ZohoMarketingHub Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Amazon Redshift.
-
Query MariaDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MariaDB and perform CRUD operations on MariaDB from Node.js.
-
Build AI/ML Models with Live Superchat Data using Dataiku
Connect Superchat Data with Dataiku using the CData API Driver for JDBC.