CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Jira Assets data in real time.
-
Stream Teamgate Data into Apache Kafka Topics
Access and stream Teamgate data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect the Power BI Service to Pipedrive: Complete Guide
Connect to the CData Software Power BI Connector for Pipedrive from PowerBI.com to provide real-time Pipedrive data across the organization.
-
Publish Sybase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sybase data.
-
Automated Continuous Jira Assets Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jira Assets replication to Snowflake.
-
Connect to Guru Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Guru as an External Source in Dremio.
-
Connect to Codat 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 Codat and work with Codat data in your FileMaker application.
-
How to connect to ZohoPeople Data in DBVisualizer
Integrate ZohoPeople data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous ZohoDesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoDesk replication to delimited files (CSV/TSV).
-
How to Connect to TaxJar Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TaxJar data. Leverage the pyodbc module for ODBC in Python.
-
Build a Simple VCL Application for Zoom Data
How to build a simple VCL Application to view Zoom data in RAD Studio using the CData ODBC Driver for Zoom.
-
Moving Data from LDAP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LDAP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy
Connect to Zoho Inventory data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Inventory.
-
Build Visualizations of Chargebee Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Chargebee data in Birst.
-
Connect SQL Server to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SQL Server data using the CData Python MCP Server.
-
Replicate Multiple Oracle HCM Cloud Accounts
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
DataBind Controls to Supabase Data in Delphi
DataBind to Supabase data in Delphi with standard data access components and controls.
-
Automated BenchmarkEmail Data Replication to Teradata
Use CData Sync to Customize and automate BenchmarkEmail data replication to Teradata.
-
Bridge Zuora Connectivity with Apache NiFi
Access and process Zuora data in Apache NiFi using the CData JDBC Driver.
-
Working with Planio Data in LINQPad
Execute LINQ queries to Planio data in LINQPad.
-
Integrate with MariaDB Data in JReport Designer
Create charts and reports based on MariaDB data in JReport Designer.
-
Publish Crystal Reports on Freshservice Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshservice data.
-
Automated Continuous Zoho CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Amazon Redshift.
-
Create Google Drive-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Drive Data from OutSystems and build custom enterprise apps using live Google Drive data.
-
Connect to Landbot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Landbot data using standard SQL.
-
Migrating data from WooCommerce to Databricks using CData SSIS Components.
Easily push WooCommerce data to Databricks using the CData SSIS Tasks for WooCommerce and Databricks.
-
How to Easily Query TigerGraph Data in OpenOffice Base
Connect to TigerGraph data in OpenOffice Base using the CData ODBC Driver for TigerGraph and generate reports with live data insights.
-
Use Manus AI to Talk to Your Salesforce 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 Salesforce data.
-
Easily Integrate Hacker News Data in Lazarus Pascal IDE
Learn how to easily integrate live Hacker News data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to work with XML Data in Apache Spark using SQL
Access and process XML Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze ZohoExpense Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoExpense data for self-service data analytics.
-
Use the CData Software ODBC Driver for PhantomBuster in SAS for Real-Time Reporting and Analytics
Connect to real-time PhantomBuster data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PhantomBuster.
-
Automated Continuous Google Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Analytics replication to Oracle.
-
Connect Phoenix to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Phoenix with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to SendPulse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SendPulse data. Leverage the pyodbc module for ODBC in Python.
-
Build Charts with Wave Financial Data in Clear Analytics
Create dynamic charts and perform analytics based on Wave Financial data in Clear Analytics.
-
Object-Relational Mapping (ORM) with Certinia 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 Certinia data into a Java-based ORM framework, Hibernate.
-
DataBind Charts to Redis Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Redis 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.
-
Integrate Google's Vertex AI Agent with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Eloqua data within intelligent workflows.
-
Build Dashboards with Highrise Data in DBxtra
Create dynamic dashboards and perform analytics based on Highrise data in DBxtra.
-
Build a Singer.io Tap for Calendly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Calendly data using the CData Python Connector.
-
How to Connect to Live Zoom Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Zoom data for you.
-
Build Dashboards with Google Spanner Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Spanner data in Dundas BI.
-
Connect AlloyDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AlloyDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to work with ZohoMarketingHub Data in Apache Spark using SQL
Access and process ZohoMarketingHub Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live BenchmarkEmail Data in Coginiti Pro
Connect to and query live BenchmarkEmail data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Working with Clio Data in LINQPad
Execute LINQ queries to Clio data in LINQPad.
-
Automated Continuous EnterpriseDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to delimited files (CSV/TSV).
-
Automated Continuous Google Cloud Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to MySQL.
-
How to create an RPA flow for Impala Data in UiPath Studio
Use the Impala ODBC Driver to create workflows that access real-time Impala data without any coding.
-
Integrate with Amazon DynamoDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon DynamoDB data to a JSON file on disk.
-
Visualize PagerDuty Data in Sisense
Create an ElastiCube in Sisense app with access to PagerDuty data.
-
Build Semantic Layer Views for Samanage Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Samanage data.
-
Build Agents in Relevance AI with Access to Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PingOne data within intelligent agent workflows.
-
Getting Started with the CData Connect AI Python SDK for SAP SuccessFactors
Install the CData Connect AI Python SDK to read and write live SAP SuccessFactors data with standard DB-API 2.0 Python code.
-
Create Toggl-Connected Applications in Appsmith
Connect to Toggl Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Toggl data.
-
Analyze Elorus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Elorus data with the CData JDBC Driver for Elorus.
-
Automate Aha! Data Replication to Couchbase
Use CData Sync to Customize and automate Aha! data replication to Couchbase.
-
Connect and Query Live OData Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live OData services into Databricks and enable direct, live querying and analysis without replication.
-
Use Dash to Build Web Apps on Sage 300 Data via CData Connect AI
Build interactive Dash web apps on live Sage 300 data using pandas and the CData Connect AI Python SDK.
-
Access Live Adobe Experience Manager 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 Adobe Experience Manager data through MCP integration.
-
Getting Started with the CData Python Connector for Salesloft
Learn to install and license the CData Python Connector and configure a connection to live Salesloft data.
-
Access Live FHIR Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FHIR data from your Google Sheets.
-
Build Data Flows from SQL Server to Excel through SSIS
Easily push SQL Server data to Excel using the CData SSIS Tasks for Excel.
-
Visualize AdRoll Data in Sisense
Create an ElastiCube in Sisense app with access to AdRoll data.
-
Integrate Live Pipeline CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pipeline CRM data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData Excel Add-In for RSS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for RSS.
-
Seamlessly Bring IBM Informix Data into Retool Using CData Connect AI
Integrate IBM Informix data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect Amazon QuickSight to CSV Data
Create a connection to CSV data in CData Connect AI and insert CSV data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Desktop
Connect to PagerDuty data in MicroStrategy Desktop using the CData Software ODBC Driver for PagerDuty.
-
How to integrate Metabase with Microsoft Entra ID Data
Use CData Connect AI to connect to live Microsoft Entra ID data and create an interactive dashboard in Metabase from Microsoft Entra ID data.
-
Build Zoho CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho CRM data.
-
Connect to Exa from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Exa data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build an OLAP Cube in SSAS from Phoenix Data
Establish a connection to Phoenix data data from SQL Server Analysis Services, and use the Phoenix Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to ZendeskSell Data from a Connection Pool in JBoss
Integrate ZendeskSell data into Java servlets: Use the Management Console in JBoss to install the ZendeskSell JDBC Driver.
-
Integrating LangChain with GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GetResponse data within automated workflows.
-
Connect to Cloudant Data in Ruby
Connect to Cloudant data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Excel Add-In for Coda
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Coda.
-
Publish Crystal Reports on Redis Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Redis data.
-
Connect to Cassandra Data in ACL Analytics
Connect to Cassandra data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Cassandra data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Flowlu
Provide connectivity to Flowlu data through an SAP BusinessObjects universe.
-
Stream CockroachDB Data into Apache Kafka Topics
Access and stream CockroachDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Boomi Agentstudio with Acumatica Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Acumatica data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish Crystal Reports on HubDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubDB data.
-
LINQ to Sentry 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 Sentry Data Provider.
-
Feed HelloSign Data into FineReport
How to set HelloSign data as a JDBC data source in FineReport.
-
Connecting Agentforce with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your EnterpriseDB data for you.
-
Integrate SendPulse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SendPulse with External Services.
-
Create Reports with Zoom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoom data.
-
Create Retently Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Retently data access from reports, embedded analytics, and more.
-
Publish Crystal Reports on Copper Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Copper data.
-
Connect to YouTube Analytics Data in DBeaver
Use the CData ODBC Driver to connect to YouTube Analytics data in DBeaver.
-
Manage PayPal Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PayPal.
-
Integrating GitHub Copilot with BenchmarkEmail 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.
-
Connect to ShipEngine from Asprova with CData Software ODBC Driver for ShipEngine
This article shows how to connect faster to ShipEngine data from Asprova.
-
Create Informatica Mappings From/To an ODBC Data Source for Discourse
Create an ODBC connection to Discourse in Informatica and browse and transfer Discourse data.
-
Use Grok to Talk to Your BigQuery 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 BigQuery data for you.
-
How to publish and share Dropbox Data dashboards with Tableau Server
The CData ODBC driver for Dropbox enables you integrate Dropbox data into Tableau dashboards.
-
Integrate Goose with Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SuiteCRM data from within the local AI agent.
-
Automate QuickBooks Online Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks Online data replication to Azure Data Lake.