CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on LDAP Objects
Create Python applications that use pandas and Dash to build LDAP-connected web apps.
-
Natively Connect to ZarMoney Data in PHP
The CData ODBC driver for ZarMoney enables you to create PHP applications with connectivity to ZarMoney. Leverage the native support for ODBC in PHP.
-
Automated Continuous Phoenix Replication to Databricks
Use CData Sync for automated, continuous, customizable Phoenix replication to Databricks.
-
How to Connect to Live Asana Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Asana for you.
-
Design BIRT Reports on Perigon Data
Provide current Perigon to your embedded analytics.
-
Create GitLab-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GitLab Data from Klipfolio and build custom visualizations using live GitLab.
-
Integrating Claude Code CLI with IBM Cloud Object Storage 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.
-
Visualize Live Dynamics CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics CRM.
-
Integrate Azure Analysis Services Data in the Pentaho Report Designer
Publish reports based on Azure Analysis Services in the Pentaho BI tool.
-
Build Automated Workflows with Live Google Calendar Data in Workato
Use CData Connect AI to connect to live Google Calendar and build automated workflows in Workato.
-
Integrate Real-Time Access to HCL Domino in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HCL Domino in real time.
-
Integrate Goose with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Odoo ERP from within the local AI agent.
-
Easily Integrate LeadDesk Data in Lazarus Pascal IDE
Learn how to easily integrate live LeadDesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with VWO Data in ETL Validator JDBC
Connect to VWO from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Microsoft Planner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Planner and visualize Microsoft Planner in SAP Analytics Cloud.
-
Integrating Spark Data in Talend Cloud Data Management Platform
Connect Spark Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Spark.
-
Use the CData Software ODBC Driver for xBase in MicroStrategy Desktop
Connect to xBase in MicroStrategy Desktop using the CData Software ODBC Driver for xBase.
-
Validate HubDB Data with QuerySurge
Access and validate HubDB in QuerySurge using the CData JDBC Driver.
-
How to Build an ETL App for NetSuite Data in Python with CData Connect AI
Build ETL pipelines that read and write live NetSuite CRM & ERP in Python with petl and the CData Connect AI Python SDK.
-
Connecting GenSpark with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Couchbase without any replication or custom integration required.
-
Automate SharePoint Excel Services Data Replication to Couchbase
Use CData Sync to Customize and automate SharePoint Excel Services replication to Couchbase.
-
Connect to SAP HANA XS Advanced Data in Aqua Data Studio
Access SAP HANA XS Advanced from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create a Data Access Object for SurveyMonkey Data using JDBI
A brief overview of creating a SQL Object API for SurveyMonkey in JDBI.
-
Build MariaDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MariaDB and build visualizations in Tableau.
-
Import Real-Time WordPress Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use WordPress in ColdFusion.
-
Integrate Live SAS Data Sets Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAS Data Sets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAS Data Sets.
-
Create Data Visualizations Based On SQL Analysis Services Data in Mode
Use CData Connect AI to connect to SQL Analysis Services Data from Mode and build visualizations using live
-
Connect to Slack Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Slack.
-
Query Redis Data in DataGrip
Create a Data Source for Redis in DataGrip and use SQL to query live Redis.
-
Stream Pipeline CRM Data into Apache Kafka Topics
Access and stream Pipeline CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Live Gmail Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Gmail for you.
-
Build Charts with Auth0 Data in Clear Analytics
Create dynamic charts and perform analytics based on Auth0 in Clear Analytics.
-
Integrate Cursor with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Dynamics CRM from within the editor.
-
Access Google Cloud Storage Data from MySQL in PHP
Connect to Google Cloud Storage through the standard MySQL libraries in PHP.
-
Connect to Anaplan Data from a Connection Pool in JBoss
Integrate Anaplan into Java servlets: Use the Management Console in JBoss to install the Anaplan JDBC Driver.
-
How to Seamlessly Import HCL Domino Data into IBM SPSS Modeler
Integrate HCL Domino data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Exa Data in TIBCO Spotfire through ADO.NET
Integrate Exa into dashboards in TIBCO Spotfire.
-
Import and Visualize Opsgenie Data in Power View
Create data visualizations based on Opsgenie in Excel.
-
Import and Visualize Highrise Data in Power View
Create data visualizations based on Highrise CRM in Excel.
-
Connecting Pipedream with FreshBooks 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 FreshBooks data in real time.
-
Query Bitly Data in DataGrip
Create a Data Source for Bitly in DataGrip and use SQL to query live Bitly.
-
Process & Analyze PagerDuty Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PagerDuty Data.
-
Visualize Epicor Kinetic 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 Epicor Kinetic into TIBCO Spotfire.
-
Connect to Excel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to import SAP Netweaver Gateway Data into Apache Solr
Use the CData Software JDBC Driver for SAP Netweaver Gateway in Data Import Handler and create an automated import of SAP Netweaver Gateway to Apache Solr Enterprise Search platform.
-
A PostgreSQL Interface for Google Tasks Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Tasks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for Moosend Data using JDBI
A brief overview of creating a SQL Object API for Moosend in JDBI.
-
Build an OLAP Cube in SSAS from Mouseflow Data
Establish a connection to Mouseflow data from SQL Server Analysis Services, and use the Mouseflow Data Provider to build OLAP cubes for use in analytics and reporting.
-
Stream Active Directory Data into Apache Kafka Topics
Access and stream Active Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Codat Data in DBVisualizer
Integrate Codat with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Jumpseller Data Replication to Couchbase
Use CData Sync to Customize and automate Jumpseller replication to Couchbase.
-
Build Visualizations of FreshBooks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FreshBooks in Birst.
-
Deploy the ADO.NET Provider for Salesforce Pardot on an SSRS Report Server
Connect to Salesforce Pardot 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.
-
Integrating GitHub Copilot CLI with Deel 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 Connect the Power BI Service to Email: Complete Guide
Connect to the CData Software Power BI Connector for Email from PowerBI.com to provide real-time Email across the organization.
-
Integrate Live EmailOctopus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EmailOctopus to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode Terminal with FormSite 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.
-
How to Connect DBeaver to RSS via a JDBC Driver
Manage RSS Feeds with visual tools in DBeaver like the query browser.
-
Automated Continuous Pipeline CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to SingleStore.
-
Automated Continuous Oracle Service Cloud Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Databricks.
-
How to Query Live SingleStore Data in Perplexity MacOS Desktop
Connect to and query live SingleStore Data in Perplexity Desktop using CData MCP Server.
-
How to connect to ShipEngine Data from Spring Boot
Connect to ShipEngine in a Spring Boot Application using the CData API Driver for JDBC
-
Choosing the Best Method to Connect Toggl to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Toggl from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Stream ConvertKit Data into Apache Kafka Topics
Access and stream ConvertKit in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Trello.
-
Connect to Blackbaud FE NXT Data from AWS Glue
Use CData Connect AI to gain access to live Blackbaud FE NXT from your AWS Glue jobs.
-
Create Informatica Mappings From/To an ODBC Data Source for Adobe Analytics
Create an ODBC connection to Adobe Analytics in Informatica and browse and transfer Adobe Analytics.
-
Use the CData ODBC Driver for Xero from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Xero Accounting in Excel.
-
Query FTP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your FTP Servers and perform CRUD operations on FTP from Node.js.
-
Build Dashboards with Templated Data in Dundas BI
Create dynamic dashboards and perform analytics based on Templated in Dundas BI.
-
How to Access Live AlloyDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AlloyDB enables you to integrate Google AlloyDB into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Sybase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase.
-
Integrate Cline with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Gong from within your IDE.
-
Build Google Ad Manager Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Ad Manager and build visualizations in Tableau Cloud.
-
Getting Started with the CData JDBC Driver for Zuora
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zuora.
-
Connect to and Query Neo4J Data in QlikView over ODBC
Create data visualizations with Neo4J in QlikView.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy Desktop
Connect to Jodoo in MicroStrategy Desktop using the CData Software JDBC Driver for Jodoo.
-
Automated Continuous Xero Replication to Vertica
Use CData Sync for automated, continuous, customizable Xero replication to Vertica.
-
Query Salesforce Marketing Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesforce Marketing Cloud and perform CRUD operations on Salesforce Marketing from Node.js.
-
Getting Started with the CData Excel Add-In for AgileCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AgileCRM.
-
Replicate Azure Synapse Data from PowerShell
Write a quick PowerShell script to query Azure Synapse. Use connectivity to the live data to replicate Azure Synapse to SQL Server.
-
JDBC-ODBC Bridge Reporting in OBIEE with the JDBC-ODBC Bridge JDBC Driver
Deploy the JDBC-ODBC Bridge JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Build an ETL App for MarkLogic Data in Python with CData
Create ETL applications and real-time data pipelines for MarkLogic in Python with petl.
-
Connect to Neo4J Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Neo4J.
-
Bidirectional Access to Simplesat Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Simplesat in Filemaker Pro for Mac or Windows.
-
Query Clari Data in ColdFusion
Write standard ColdFusion data access code to connect to Clari.
-
Build a PostgreSQL Interface for OnePageCrm Data using the CData JDBC Driver
Use the Remoting features of the OnePageCrm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for IBM Informix Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for IBM Informix.
-
Build Cosmos DB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Cosmos DB to explore live Cosmos DB Data in Cursor to assist with building Cosmos DB-powered applications.
-
Getting Started with the CData Excel Add-In for FormSite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FormSite.
-
How to Work with JDBC-ODBC Bridge Data in AWS Glue Jobs Using JDBC
Connect to JDBC-ODBC Bridge from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Sybase IQ Data from AWS Glue
Use CData Connect AI to gain access to live Sybase IQ from your AWS Glue jobs.
-
Integrate Cline with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MySQL from within your IDE.
-
Migrating data from OneNote to Google BigQuery using CData SSIS Components.
Easily push Microsoft OneNote to Google BigQuery using the CData SSIS Tasks for OneNote and Google BigQuery.
-
Connect to Email Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Email from Filemaker Pro on Mac.
-
Analyze Dropbox Data in Looker
Use CData Connect AI to connect to Dropbox Data from Looker and build custom apps using live Dropbox.
-
Access Missive Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Missive.
-
Connect to WordPress Data in Claris FileMaker Pro
Use the CData ODBC Driver for WordPress in FileMaker Pro to connect to WordPress and work with WordPress in your FileMaker applications.
-
Connect to Shortcut Data in DBArtisan
Use wizards in DBArtisan to configure Shortcut as a data source.
-
Import Real-Time NetSuite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use NetSuite CRM & ERP in ColdFusion.