CData Software - Knowledge Base
Recent Articles
-
Connect to Intercom Data in Jaspersoft Studio
Execute SQL to remote Intercom data in Jaspersoft Studio.
-
Build Salesforce Pardot-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Pardot Data from Zoho Analytics and import live Salesforce Pardot data.
-
Visualize Live Salesforce Marketing Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Marketing data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Highrise in SAS for Real-Time Reporting and Analytics
Connect to real-time Highrise data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Highrise.
-
Automated Continuous ShipStation Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Cassandra.
-
Use Dash to Build Web Apps on Bitly Data via CData Connect AI
Build interactive Dash web apps on live Bitly data using pandas and the CData Connect AI Python SDK.
-
Use Biml to Build SSIS Tasks to Replicate ClickTime Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ClickTime data to SQL Server.
-
Integrate with Salesforce Pardot Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Pardot data in SnapLogic.
-
Import Real-Time Sendwithus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sendwithus data in ColdFusion.
-
Visualize Vault CRM 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 Vault CRM data into TIBCO Spotfire.
-
A PostgreSQL Interface for Short.io Data (MySQL Remoting via JDBC)
Use the Remoting features of the Short.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Beeminder Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Beeminder data 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.
-
How to use SQLAlchemy ORM to access Spark Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Spark data.
-
Publish Active Directory-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Active Directory data.
-
How to connect Amazon QuickSight to Microsoft OneDrive Data
Create a connection to Microsoft OneDrive data in CData Connect AI and insert Microsoft OneDrive data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Agents in Relevance AI with Access to Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on NetSuite data within intelligent agent workflows.
-
A PostgreSQL Interface for Twitter Ads Data using the CData ODBC Driver
Use the SQL Gateway and Twitter Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Teamwork Data from a Connection Pool in Jetty
The Teamwork JDBC Driver supports connection pooling: This article shows how to connect faster to Teamwork data from Web apps in Jetty.
-
Automated Certinia Data Replication to Teradata
Use CData Sync to Customize and automate Certinia data replication to Teradata.
-
Replicate REST Data from PowerShell
Write a quick PowerShell script to query REST data. Use connectivity to the live data to replicate REST data to SQL Server.
-
Build SAS xpt Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAS xpt data and build visualizations in Tableau.
-
Consume SAP OData Feeds in PowerBuilder
This article demonstrates how to consume SAP data as OData feeds from PowerBuilder using the API Server.
-
Integrate Cline with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live OData services from within your IDE.
-
Bidirectional Access to Google Directory Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Directory data in Filemaker Pro for Mac or Windows.
-
Connecting Moonlit Workflow with Sendwithus Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sendwithus data in real time.
-
Automated Continuous SAP Ariba Procurement Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Snowflake.
-
Automated Continuous GraphQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GraphQL replication to Google BigQuery.
-
Analyze Bitly Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Bitly data and visualize live Bitly data in Infragistics Reveal.
-
Visualize VWO Data in Sisense
Create an ElastiCube in Sisense app with access to VWO data.
-
Use the CData Software ODBC Driver for MessageBird in SAS for Real-Time Reporting and Analytics
Connect to real-time MessageBird data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MessageBird.
-
Integrate Open WebUI with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live OData services from within the chat interface.
-
Connect to Adobe Experience Manager Data in Ruby
Connect to Adobe Experience Manager data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Live Zendesk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zendesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zendesk data.
-
Access Bitbucket Data from MySQL in PHP
Connect to Bitbucket through the standard MySQL libraries in PHP.
-
Build a Simple VCL Application for MailerLite Data
How to build a simple VCL Application to view MailerLite data in RAD Studio using the CData ODBC Driver for MailerLite.
-
Build a PostgreSQL Interface for Elorus Data using the CData JDBC Driver
Use the Remoting features of the Elorus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Freshteam Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshteam data and integrate live Freshteam data into apps built in Microsoft Power Apps.
-
Import SAP Hybris C4C Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Hybris C4C Data and provide access to live SAP Hybris C4C data for custom reports in the Power BI Service.
-
Migrating data from SendGrid to Snowflake using CData SSIS Components.
Easily push SendGrid data to Snowflake using the CData SSIS Tasks for SendGrid and Snowflake.
-
Interact with Live Zoho Books Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho Books data.
-
Connect Highrise to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Highrise with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneDrive data in real time.
-
Getting Started with the CData Power BI Connector for Outlook
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Redis Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Redis replication to PostgreSQL.
-
Create DB2 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for DB2 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Oracle Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle data through MCP integration.
-
Automated Continuous eBay Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Vertica.
-
Integrate Live Okta Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Okta data to Blue Prism using the CData ODBC Driver for Okta to create automated workflows for repetitive business tasks.
-
Integrate Microsoft Exchange with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Exchange with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Exchange data.
-
Connect and Visualize Live Typeform Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Typeform data into the Databricks platform and create visualization dashboards with real-time Typeform data.
-
How to Connect SageHR Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SageHR data in real time using natural language.
-
Automated Discourse Data Replication to Teradata
Use CData Sync to Customize and automate Discourse data replication to Teradata.
-
Build MVC Applications with Connectivity to SAS xpt Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAS xpt from an ASP.NET MVC application.
-
Enable the HBase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HBase data.
-
Connecting Moonlit Workflow with Freshdesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Freshdesk data in real time.
-
Use the CData ODBC Driver for YouTube Analytics in Microsoft Power Query
You can use the CData YouTube Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import YouTube Analytics data into Microsoft Power Query.
-
Automated Continuous Sugar CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.
-
Publish Crystal Reports on Zoom Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoom data.
-
Analyze DB2 Data in Looker
Use CData Connect AI to connect to DB2 Data from Looker and build custom apps using live DB2 data.
-
Connect to Bugsnag Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bugsnag data.
-
Integrating Claude Code CLI with MessageBird 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.
-
ETL Kafka in Oracle Data Integrator
This article shows how to transfer Kafka data into a data warehouse using Oracle Data Integrator.
-
Connect to Adobe Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Analytics data as a data source.
-
Integrating OpenCode with Customer.io 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.
-
Object-Relational Mapping (ORM) with Pushbullet 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 Pushbullet data into a Java-based ORM framework, Hibernate.
-
How to connect to Workday Data with Squirrel SQL client
Connect to Workday data and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for Oracle Financials Cloud Data in UiPath Studio
Use the Oracle Financials Cloud ODBC Driver to create workflows that access real-time Oracle Financials Cloud data without any coding.
-
Connect to Real-Time Mocean Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mocean data in Power Apps.
-
Integrate Devin with Live Couchbase Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Couchbase data.
-
Work with Live SAS Data Sets Data in Power Query
Use CData Connect AI to connect to SAS Data Sets data and work with live SAS Data Sets data in Microsoft Power Query.
-
Connect to Reckon Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon data.
-
How to Visualize Procore Data in Python with pandas
Use pandas and other modules to analyze and visualize live Procore data in Python.
-
Connect to Notion Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Notion to connect to Notion data and execute queries in PowerBuilder.
-
Write a Simple Go Application to work with Google Tasks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Tasks data.
-
How to Connect to Live Campaigner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Campaigner data securely in real time.
-
Connect to LDAP Objects as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LDAP objects.
-
How to Visualize Azure DevOps Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure DevOps data in Python.
-
Moving Data from SAP SuccessFactors LMS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP SuccessFactors LMS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Shortcut Data as a SQL Server Database in Node.js
Execute SQL Server queries against Shortcut data from Node.js.
-
Replicate HDFS Data to Multiple Databases
Replicate HDFS data to disparate databases with a point-and-click configuration.
-
Use Dash to Build Web Apps on Azure Data Lake Storage Data via CData Connect AI
Build interactive Dash web apps on live Azure Data Lake Storage data using pandas and the CData Connect AI Python SDK.
-
Connect to Aweber Data from PowerBuilder via JDBC
This article demonstrates how to access Aweber data from PowerBuilder using the Aweber JDBC Driver.
-
Search External Authorize.Net Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Authorize.Net data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Authorize.Net Data objects that you can access from apps and the dashboard.
-
Use Dash to Build to Web Apps on Office 365 Data
Create Python applications that use pandas and Dash to build Office 365-connected web apps.
-
Establish a Live Connection with Billsby Data using Tableau Bridge
The CData ODBC Driver for Billsby enables you to integrate live Billsby data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Anaplan with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Anaplan with External Services.
-
How to Connect DBeaver to Missive via a JDBC Driver
Manage Missive data with visual tools in DBeaver like the query browser.
-
Build MVC Applications with Connectivity to Freshteam Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshteam from an ASP.NET MVC application.
-
Visualize Live Mouseflow Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mouseflow data.
-
Integrating OpenCode with Todoist 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.
-
DataBind Controls to Postmark Data in Delphi
DataBind to Postmark data in Delphi with standard data access components and controls.
-
Access Blackbaud FE NXT Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Blackbaud FE NXT data from HeidiSQL.
-
How to Query Microsoft Exchange Data in MySQL Workbench
Execute MySQL queries against live Microsoft Exchange data from MySQL Workbench.
-
Use the CData ODBC Driver for Microsoft Dataverse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dataverse data in Excel.
-
Using the CData Software ODBC Driver for Teamwork in PyCharm
Connect to Teamwork as an ODBC data source in PyCharm using the CData Software ODBC Driver for Teamwork.
-
Connect to WooCommerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to WooCommerce as an External Source in Dremio.
-
CapsuleCRM Reporting in OBIEE with the CapsuleCRM JDBC Driver
Deploy the CapsuleCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate GraphQL Data in Lazarus Pascal IDE
Learn how to easily integrate live GraphQL data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Zoho CRM Data using JDBI
A brief overview of creating a SQL Object API for Zoho CRM data in JDBI.
-
Build Testmonitor-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Testmonitor data.