CData Software - Knowledge Base
Recent Articles
-
Integrate Live Guru Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Guru data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live SAP Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP data in the Graph Builder and Query Builder.
-
How to Create Power BI Visual Reports with Real-Time Cassandra Data
Use CData Power BI Connectors to visualize Cassandra data in Power BI.
-
How to Connect the Power BI Service to Jodoo: Complete Guide
Connect to the CData Software Power BI Connector for Jodoo from PowerBI.com to provide real-time Jodoo data across the organization.
-
Visualize LDAP Objects in Sisense
Create an ElastiCube in Sisense app with access to LDAP objects.
-
Natively Connect to Close Data in PHP
The CData ODBC driver for Close enables you to create PHP applications with connectivity to Close data. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Paymo-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Paymo.
-
How to connect to SQL Analysis Services Data in DBVisualizer
Integrate SQL Analysis Services data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Cohere Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Cohere data from PowerShell? This article demonstrates how to utilize the Cohere Cmdlets for tasks like connecting to Cohere data, automating operations, downloading data, and more.
-
Integrate Google's Vertex AI Agent with Live Sage 200 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 Sage 200 data within intelligent workflows.
-
Integrate with CockroachDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CockroachDB data to a JSON file on disk.
-
How to Work with Mistral AI Data in ETL Validator JDBC
Connect to Mistral AI from ETL Validator jobs using the CData Software JDBC Driver.
-
Natively Connect to Pipeliner CRM Data in PHP
The CData ODBC driver for Pipeliner CRM enables you to create PHP applications with connectivity to Pipeliner CRM data. Leverage the native support for ODBC in PHP.
-
Analyze Freshsales Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshsales data in Microsoft R Open.
-
How to Build an ETL App for Phoenix Data in Python with CData
Create ETL applications and real-time data pipelines for Phoenix data in Python with petl.
-
Google Directory Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Directory data through CData Connect AI using different applications and tools.
-
Access Live Tickspot Data in AWS Lambda
Connect to live Tickspot data in AWS Lambda using the CData JDBC Driver.
-
Build Coda-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Coda data.
-
Query BambooHR Data in DataGrip
Create a Data Source for BambooHR in DataGrip and use SQL to query live BambooHR data.
-
Create Oracle HCM Cloud-Connected Applications in Appsmith
Connect to Oracle HCM Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle HCM Cloud data.
-
Integrate Google's Antigravity Agent with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live YouTube Analytics data using the Model Context Protocol.
-
Use Claude to Talk to Your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your AlloyDB data for you.
-
How to Visualize Zuora Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zuora data in Python.
-
Getting Started with the CData ODBC Driver for WordPress
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for WordPress.
-
Connect and Visualize Live MongoDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MongoDB data into the Databricks platform and create visualization dashboards with real-time MongoDB data.
-
How to connect PolyBase to Cloudflare
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cloudflare data.
-
How to Connect to Live Excel Online Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Excel Online data securely in real time.
-
Integrating Claude Code CLI with Freshdesk 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.
-
Connecting GenSpark with Databricks Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Databricks data without any replication or custom integration required.
-
Integrate Superchat Data in Pentaho Data Integration
Build ETL pipelines based on Superchat data in the Pentaho Data Integration tool.
-
Query Beeminder Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Beeminder data from Node.js.
-
Integrating LangGraph with Salesforce Data 360 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Data 360 data within automated workflows.
-
Connect to Freshdesk Data from a Connection Pool in Jetty
The Freshdesk JDBC Driver supports connection pooling: This article shows how to connect faster to Freshdesk data from Web apps in Jetty.
-
Build an OLAP Cube in SSAS from Dynamics 365 Business Central Data
Establish a connection to Dynamics 365 Business Central data data from SQL Server Analysis Services, and use the Dynamics 365 Business Central Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Semantic Layer Views for SAS xpt Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAS xpt data.
-
Connect to Real-Time Codat Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Codat data in Power Apps.
-
Automated Continuous Factorial Replication to MongoDB
Use CData Sync for automated, continuous, customizable Factorial replication to MongoDB.
-
Create a Data Access Object for Amazon S3 Data using JDBI
A brief overview of creating a SQL Object API for Amazon S3 data in JDBI.
-
ZohoExpense Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ZohoExpense data through CData Connect AI using different applications and tools.
-
Create a Data Access Object for DocuSign Data using JDBI
A brief overview of creating a SQL Object API for DocuSign data in JDBI.
-
Use Agno to Talk to Your QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your QuickBooks data for you.
-
Automated Continuous ScrapingBee Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ScrapingBee data replication to OneLake in Microsoft Fabric.
-
Analyze Live AlloyDB Data in SAS Viya
Use CData Connect AI to connect to AlloyDB data from SAS Viya and deploy self-service analytics using live AlloyDB data.
-
Integrate Front Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Front data from Informatica Cloud.
-
Connect to Real-Time Pipeline CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pipeline CRM data in Power Apps.
-
How to connect to Sybase IQ Data with Squirrel SQL client
Connect to Sybase IQ data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Strava in MicroStrategy
Connect to Strava data in MicroStrategy Developer using the CData Software JDBC Driver for Strava.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via JDBC
This article demonstrates how to access SAP SuccessFactors LMS data from PowerBuilder using the SAP SuccessFactors LMS JDBC Driver.
-
Create Sybase IQ Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sybase IQ from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData ODBC Driver for Basecamp in Microsoft Power Query
You can use the CData Basecamp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Basecamp data into Microsoft Power Query.
-
How to connect to SAP BusinessObjects BI Data from IntelliJ
Integrate connectivity to SAP BusinessObjects BI data with wizards in IntelliJ.
-
Build Visualizations of ConvertAPI Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConvertAPI data in Birst.
-
Prepare, Blend, and Analyze Active Directory Data in Alteryx Designer (ODBC)
Build workflows to access live Active Directory data for self-service data analytics.
-
Build Data Flows from Codat to SQL Server using SSIS
Easily back up Codat data to SQL Server using the SSIS components for Codat.
-
ETL Asana in Oracle Data Integrator
This article shows how to transfer Asana data into a data warehouse using Oracle Data Integrator.
-
Connecting Agentforce with SAP HANA XS Advanced 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 SAP HANA XS Advanced data for you.
-
How to Access SAP ByDesign Data Using Entity Framework
This article shows how to access SAP ByDesign data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gorgias
Provide connectivity to Gorgias data through an SAP BusinessObjects universe.
-
Use Claude to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your WooCommerce data for you.
-
Connect to Simplesat Data in RapidMiner
Integrate Simplesat data with standard components and data source configuration wizards in RapidMiner Studio.
-
Process & Analyze QuickBooks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Data.
-
Integrating LlamaIndex with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Blackbaud FE NXT data in real time.
-
Integrating Claude Code with Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Blackbaud FE NXT data within assisted coding and automated development workflows.
-
Analyze Mixpanel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mixpanel data with the CData JDBC Driver for Mixpanel.
-
Prepare, Blend, and Analyze Adobe Experience Manager Data in Alteryx Designer (ODBC)
Build workflows to access live Adobe Experience Manager data for self-service data analytics.
-
Integrating Cursor with Printify 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 Toggl Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Toggl data from HeidiSQL.
-
Import Real-Time Oracle HCM Cloud Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle HCM Cloud data in ColdFusion.
-
Stream SingleStore Data into Apache Kafka Topics
Access and stream SingleStore data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from HCL Domino to Google BigQuery using CData SSIS Components.
Easily push HCL Domino data to Google BigQuery using the CData SSIS Tasks for HCL Domino and Google BigQuery.
-
Automate Apollo Data Replication to Azure Synapse
Use CData Sync to customize and automate Apollo data replication to Azure Synapse.
-
How to Build an ETL App for Act CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Act CRM data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Microsoft Ads Data in ACL Analytics
Connect to Microsoft Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Ads data.
-
Back Up Intercom data 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 Intercom data data.
-
Build Automated Marketo-Connected Workflows in Zapier
Use CData Connect AI to connect to live Marketo data and build automated workflows in Zapier.
-
How to Connect DBeaver to Amazon Marketplace via a JDBC Driver
Manage Amazon Marketplace data with visual tools in DBeaver like the query browser.
-
Automated Continuous Jumpseller Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jumpseller replication to Google BigQuery.
-
Build a PostgreSQL Interface for Sage Intacct Data using the CData JDBC Driver
Use the Remoting features of the Sage Intacct JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load Pipedrive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pipedrive data to a database.
-
Connect to Box Data in NetBeans
Connect to Box data in NetBeans with the data source configuration wizard.
-
Connect to REST Data in Aqua Data Studio
Access REST data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for VWO Data using the CData ODBC Driver
Use the SQL Gateway and VWO ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Snowflake data for you.
-
Work with Teradata Data in FoxPro
Load Teradata data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Back Up NetSuite data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for NetSuite. In this article, we will employ an SSIS workflow to populate a database with NetSuite data data.
-
Automated Continuous Google Contacts Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Contacts replication to Amazon Redshift.
-
Analyze Copper Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Copper data in Microsoft R Open.
-
How to publish and share Couchbase Data dashboards with Tableau Server
The CData ODBC driver for Couchbase enables you integrate Couchbase data into Tableau dashboards.
-
Connect to ChartMogul Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ChartMogul data in the Denodo Virtual DataPort Administrator.
-
Build Visualizations of HelloSign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HelloSign data in Birst.
-
Use Databricks Agent Bricks to Talk to Your Sage 300 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage 300 data for you.
-
How to Work with Zuora Data in ETL Validator JDBC
Connect to Zuora from ETL Validator jobs using the CData Software JDBC Driver.
-
How to update Oracle Service Cloud from Excel
This article explains how to transfer data from Excel to Oracle Service Cloud using the Excel Add-In for Oracle Service Cloud.
-
Build Agents in Relevance AI with Access to Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Hive data within intelligent agent workflows.
-
Getting Started with the CData Python Connector for SAP Business Warehouse
Learn to install and license the CData Python Connector and configure a connection to live SAP Business Warehouse data.
-
Use Manus AI to Talk to Your ShipEngine 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 ShipEngine data.
-
Integrating Claude Code CLI with Simplesat 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 to LinkedIn Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LinkedIn data. Leverage the pyodbc module for ODBC in Python.
-
How to work with TigerGraph Data in Apache Spark using SQL
Access and process TigerGraph Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Salesforce Marketing Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Marketing as an External Source in Dremio.