CData Software - Knowledge Base
Recent Articles
-
Automate Codat Data Replication to SAP HANA
Use CData Sync to customize and automate Codat replication to SAP HANA.
-
Consume Zoho Books OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Books as OData feeds from PowerBuilder using the API Server.
-
Integrating LlamaIndex with Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache Spark SQL in real time.
-
A PostgreSQL Interface for Kafka Data (MySQL Remoting via JDBC)
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model Power BI XMLA Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Power BI XMLA, enabling the direct import of real-time Power BI XMLA.
-
Deploy the ADO.NET Provider for Shopify on an SSRS Report Server
Connect to Shopify 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.
-
Build a Singer.io Tap for Sugar CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sugar CRM data using
-
Connect GitLab to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GitLab using the CData Python MCP Server.
-
Replicate Multiple Google Spanner Accounts via the CData Sync CLI
Replicate multiple Google Spanner accounts to one or many databases.
-
Viewing Dynamics NAV Data in RAD Studio Data Explorer
How to view Microsoft Dynamics NAV in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics NAV.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live QuickBooks Online using the Model Context Protocol.
-
Validate Harvest Data with QuerySurge
Access and validate Harvest in QuerySurge using the CData JDBC Driver.
-
Integrate HubDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubDB with External Services.
-
Feed HubDB Data into FineReport
How to set HubDB as a JDBC data source in FineReport.
-
Getting Started with the CData JDBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Typeform.
-
How to Access Live Figshare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Figshare enables you to integrate Figshare into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access ClickTime Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ClickTime.
-
Automate Bugsnag Data Replication to Couchbase
Use CData Sync to Customize and automate Bugsnag replication to Couchbase.
-
Automated Continuous BenchmarkEmail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Apache Cassandra.
-
Integrate Theia IDE with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Publish CSV-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CSV/TSV Files.
-
Integrating LangGraph with Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Sales within automated workflows.
-
Use the CData ODBC Driver for Optimizely from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Optimizely to connect to Optimizely from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Optimizely in Excel.
-
Access Live SAP Concur Data in TIBCO Data Virtualization
Use the SAP Concur Tibco DV Adapter to create a SAP Concur data source in TIBCO Data Virtualization Studio and gain access to live SAP Concur from your TDV Server.
-
Build FHIR-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for FHIR to explore live FHIR Data in Cursor to assist with building FHIR-powered applications.
-
Validate CockroachDB Data with QuerySurge
Access and validate CockroachDB in QuerySurge using the CData JDBC Driver.
-
How to Connect to Exa Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Exa. Leverage the pyodbc module for ODBC in Python.
-
DataBind SingleStore Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SingleStore with the DevExpress Windows Forms and Web controls to provide SingleStore to a chart.
-
Process & Analyze SpaceX Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SpaceX Data.
-
Integrating Cursor CLI with CockroachDB 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 with Live Okta Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Okta from the MuleSoft Anypoint Platform to integrate live Okta into custom reports and dashboards.
-
Automated Continuous Notion Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Notion replication to AlloyDB.
-
Create Square Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Square data access from reports, embedded analytics, and more.
-
Integrating Codex CLI with IBM Cloudant 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 Calendly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Calendly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (ODBC)
Build workflows to access live ADP for self-service data analytics.
-
Bridge BenchmarkEmail Connectivity with Apache NiFi
Access and process BenchmarkEmail in Apache NiFi using the CData JDBC Driver.
-
Work with Drip Data in FoxPro
Load Drip into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build an OLAP Cube in SSAS from Gmail Data
Establish a connection to Gmail data from SQL Server Analysis Services, and use the Gmail Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Easily Query Sentry Data in OpenOffice Base
Connect to Sentry data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Back Up Workday to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Workday. In this article, we will employ an SSIS workflow to populate a database with Workday data.
-
How to Query Live Cohere Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cohere data in natural language using Python.
-
Getting Started with the CData Tableau Connector for Freshservice
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to work with Zoho Books Data in Apache Spark using SQL
Access and process Zoho Books Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Redshift Data in DBeaver
Use the CData ODBC Driver to connect to Amazon Redshift in DBeaver.
-
Manage Shopify Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shopify.
-
HCL Domino REST API Part 4: Connecting from Tableau using CData Tableau Connector
The last article in an article series that goes over the HCL Domino REST API. This article is an overview and guide for the CData HCL Domino Drivers and Connectors.
-
Access Amazon DynamoDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon DynamoDB from your Oracle system.
-
Add Oracle Eloqua Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Live Microsoft Entra ID Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Entra ID from the MuleSoft Anypoint Platform to integrate live Microsoft Entra ID into custom reports and dashboards.
-
Build Zoho CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho CRM Data from Choreo and build custom apps using live Zoho CRM.
-
Configure the CData JDBC Driver for Adobe Analytics in a Connection Pool in Tomcat
Connect to Adobe Analytics from a connection pool in Tomcat.
-
Build Semantic Layer Views for Microsoft Entra ID Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Entra ID.
-
Connect to Deel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Deel to connect to Deel from Web applications running on WebLogic.
-
How to Import Data from Highrise into Google Sheets
Import Highrise CRM into a Google spreadsheet that is automatically refreshed.
-
Configure the CData JDBC Driver for Act CRM in a Connection Pool in Tomcat
Connect to Act CRM from a connection pool in Tomcat.
-
Back Up Teamwork to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Teamwork data.
-
Work with Live PostgreSQL Data in Power Query
Use CData Connect AI to connect to PostgreSQL and work with live PostgreSQL in Microsoft Power Query.
-
Build MarkLogic-Connected Apps in Choreo
Use CData Connect AI to connect to MarkLogic Data from Choreo and build custom apps using live MarkLogic.
-
Add Impala Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Impala with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software JDBC Driver for Eventbrite in MicroStrategy Web
Connect to Eventbrite in MicroStrategy Web using the CData Software JDBC Driver for Eventbrite.
-
Integrating Claude Code CLI with CockroachDB 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 Calendly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Calendly from your Oracle system.
-
How to Connect to Live Microsoft Teams Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Teams for you.
-
Automated Continuous SendGrid Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SendGrid replication to Apache Cassandra.
-
Access Live Vault CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Veeva Vault & Vault CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Adobe Commerce Data in CloverDX (formerly CloverETL)
Transfer Adobe Commerce using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Factorial Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Factorial. Leverage the pyodbc module for ODBC in Python.
-
Connect EmailOctopus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your EmailOctopus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create SharePoint-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SharePoint Data from Klipfolio and build custom visualizations using live Microsoft SharePoint.
-
How to Access Email Data Using Entity Framework
This article shows how to access Email using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for SharePoint in MicroStrategy Desktop
Connect to Microsoft SharePoint in MicroStrategy Desktop using the CData Software ODBC Driver for SharePoint.
-
Access Live Oracle HCM Cloud Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle HCM Cloud from your Excel spreadsheets.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Trello using the Model Context Protocol.
-
A PostgreSQL Interface for Sage Intacct Data using the CData ODBC Driver
Use the SQL Gateway and Sage Intacct ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Freshdesk actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use Dash to Build Web Apps on Amazon DynamoDB Data via CData Connect AI
Build interactive Dash web apps on live Amazon DynamoDB using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Elasticsearch Replication to Databricks
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Databricks.
-
Use the CData Software JDBC Driver for Rebilly in MicroStrategy
Connect to Rebilly in MicroStrategy Developer using the CData Software JDBC Driver for Rebilly.
-
Integrate Live OnePageCrm Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live OnePageCrm to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build MVC Applications with Connectivity to SuiteCRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SuiteCRM from an ASP.NET MVC application.
-
How to update Jira Assets from Excel
This article explains how to transfer data from Excel to Jira Assets using the Excel Add-In for Jira Assets.
-
Automated Continuous Salesforce Marketing Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Snowflake.
-
Explore Geographical Relationships in Paymo Data with Power Map
Create data visualizations with Paymo in Power Map.
-
Use CData Connect AI to Access Gong Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Gong in the Power Pivot business intelligence tool.
-
Visualize Excel Data in TIBCO Spotfire through OData
Integrate Microsoft Excel into dashboards in TIBCO Spotfire.
-
Build Apps with Live Harvest Data Using the Low-Code Development Platform of Mendix
Connect Harvest with Mendix to build apps using the CData API Driver for JDBC.
-
Working with Stripe Data in LINQPad
Execute LINQ queries to Stripe in LINQPad.
-
Connect to ConstantContact Data in DBArtisan
Use wizards in DBArtisan to configure ConstantContact as a data source.
-
Use the CData Software ODBC Driver for HelloSign in MicroStrategy Desktop
Connect to HelloSign in MicroStrategy Desktop using the CData Software ODBC Driver for HelloSign.
-
How to integrate Metabase with Tally Data
Use CData Connect AI to connect to live Tally ERP and create an interactive dashboard in Metabase from Tally ERP.
-
Connect to ZohoDesk Data in NetBeans
Connect to ZohoDesk in NetBeans with the data source configuration wizard.
-
Build Kafka-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Kafka and build web apps with connectivity to live Apache Kafka.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Xero
Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.
-
Integrate AlloyDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google AlloyDB and integrate live Google AlloyDB into your Power Automate tasks.
-
Access CapsuleCRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CapsuleCRM from your Oracle system.
-
Connect to and Visualize Live Toggl Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Toggl.
-
Connect to Access Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Access as an External Source in Dremio.
-
Connect to Discord Data in RazorSQL
Connect to Discord from wizards and query Discord from the GUI in the RazorSQL database management tool.
-
How to Visualize SAP Business One Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Business One in Python.