CData Software - Knowledge Base
Recent Articles
-
Integrate Live Pinecone Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pinecone data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Migrating data from Blackbaud FE NXT to Databricks using CData SSIS Components.
Easily push Blackbaud FE NXT data to Databricks using the CData SSIS Tasks for Blackbaud FE NXT and Databricks.
-
Analyze Live iContact Data in SAS Viya
Use CData Connect AI to connect to iContact data from SAS Viya and deploy self-service analytics using live iContact data.
-
Integrate Microsoft Ads Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Ads data in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for ChargeOver
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to integrate Metabase with Salesloft Data
Use CData Connect AI to connect to live Salesloft data and create an interactive dashboard in Metabase from Salesloft data.
-
Import Real-Time Pipeline CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pipeline CRM data in ColdFusion.
-
Create a Data Access Object for Clio Data using JDBI
A brief overview of creating a SQL Object API for Clio data in JDBI.
-
Use Dash to Build Web Apps on Typeform Data via CData Connect AI
Build interactive Dash web apps on live Typeform data using pandas and the CData Connect AI Python SDK.
-
Integrate LibreChat with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Reckon Accounts Hosted data from within the chat interface.
-
Build a PostgreSQL Interface for Oracle Service Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle Service Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to load Email data into Elasticsearch via Logstash
Introducing a simple method to load Email data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build HBase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live HBase data.
-
Access HubSpot Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HubSpot data from your Oracle system.
-
Deploy the ADO.NET Provider for Coinbase on an SSRS Report Server
Connect to Coinbase data 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 an OLAP Cube in SSAS from Microsoft Planner Data
Establish a connection to Microsoft Planner data data from SQL Server Analysis Services, and use the Microsoft Planner Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Paymo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Paymo replication to Apache Cassandra.
-
Connect to Pinterest Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Pinterest Data and connect to Pinterest data in Akorbi Digital RunMyProcess.
-
Build AI/ML Models with Live SurveyMonkey Data using Dataiku
Connect SurveyMonkey Data with Dataiku using the CData JDBC Driver for SurveyMonkey.
-
Use Agno to Talk to Your Google Campaign Manager 360 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 Google Campaign Manager 360 data for you.
-
How to work with Rootly Data in Apache Spark using SQL
Access and process Rootly Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Excel Online Data in Google Apps Script via Connect AI
Use CData Connect AI to access Excel Online data in Google Apps Script.
-
Automated Continuous Zendesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zendesk replication to delimited files (CSV/TSV).
-
Natively Connect to JSON Services in PHP
The CData ODBC driver for JSON enables you to create PHP applications with connectivity to JSON services. Leverage the native support for ODBC in PHP.
-
Work with Perplexity Data in FoxPro
Load Perplexity data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect Stripe 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 Stripe data in real time using natural language.
-
Connect to Stack Exchange Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Stack Exchange data in the Denodo Virtual DataPort Administrator.
-
How to create an RPA flow for Smartsheet Data in UiPath Studio
Use the Smartsheet ODBC Driver to create workflows that access real-time Smartsheet data without any coding.
-
Automated Continuous CampaignMonitor Replication to Snowflake
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Snowflake.
-
Getting Started with the CData ODBC Driver for Browserless
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Browserless.
-
Getting Started with the CData ODBC Driver for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Twitter Ads.
-
Visualize Live Splunk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Splunk data.
-
Enable the Confluence JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Confluence data.
-
Prepare, Blend, and Analyze Cvent Data in Alteryx Designer (Connect AI)
Build workflows to access live Cvent data for self-service data analytics.
-
Integrating Gumloop with Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Snowflake data within automated workflows.
-
Create Presto-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Presto Data from OutSystems and build custom enterprise apps using live Presto data.
-
Create Google Analytics-Connected Dashboards in Grafana
Connect to Google Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Analytics data.
-
Integrate with Basecamp Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Basecamp data in SnapLogic.
-
Visualize Google Directory Data in Sisense
Create an ElastiCube in Sisense app with access to Google Directory data.
-
Getting Started with the CData JDBC Driver for Pingdom
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pingdom.
-
Connect to MessageBird Data in CloverDX (formerly CloverETL)
Transfer MessageBird data using the visual workflow in the CloverDX data integration tool.
-
Access Live Sybase IQ Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sybase IQ data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Build an ETL App for Scrapfly Data in Python with CData
Create ETL applications and real-time data pipelines for Scrapfly data in Python with petl.
-
How to Connect Flowise AI Agents to Live Avalara AvaTax Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Avalara AvaTax data without replication.
-
Access Pushbullet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pushbullet data from your Oracle system.
-
Replicate Multiple Blackbaud FE NXT Accounts
Replicate multiple Blackbaud FE NXT accounts to one or many databases.
-
Use CData Connect AI to Access Moosend Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Moosend data in the Power Pivot business intelligence tool.
-
Automated Continuous CircleCI Replication to Oracle
Use CData Sync for automated, continuous, customizable CircleCI replication to Oracle.
-
Automated Continuous Simplesat Replication to Databricks
Use CData Sync for automated, continuous, customizable Simplesat replication to Databricks.
-
Create Sybase IQ-Connected Applications in Appsmith
Connect to Sybase IQ Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sybase IQ data.
-
Analyze Zoho Books Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Books data and visualize live Zoho Books data in Infragistics Reveal.
-
Automated Continuous Amplitude Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amplitude replication to Google Cloud SQL.
-
Integrate Live MongoDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MongoDB data and integrate live MongoDB data into apps built in Microsoft Power Apps.
-
Creating Square-Connected Applications in Unqork
You can use CData Connect AI to feed Square data to Unqork and build custom business apps.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange data for you.
-
Automated Continuous Microsoft Dataverse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to IBM DB2.
-
Connect to Kintone Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Kintone to connect to Kintone data and execute queries in PowerBuilder.
-
Working with LeadDesk Data in LINQPad
Execute LINQ queries to LeadDesk data in LINQPad.
-
Build MVC Applications with Connectivity to AfterShip Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access AfterShip from an ASP.NET MVC application.
-
Connect to Azure Analysis Services Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Analysis Services data.
-
Create Informatica Mappings From/To a JDBC Data Source for Planio
Create Planio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Manus AI to Talk to Your SAP Concur 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 SAP Concur data.
-
Create Reports from Tally Data in Looker Studio
Use CData Connect AI to gain access to live Tally data and create custom reports in Looker Studio.
-
Connect to BenchmarkEmail Data in Jaspersoft Studio
Execute SQL to remote BenchmarkEmail data in Jaspersoft Studio.
-
Design BIRT Reports on TigerGraph Data
Provide current TigerGraph data to your embedded analytics.
-
Stream Slack Data into Apache Kafka Topics
Access and stream Slack data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Devin with Live Notion 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 Notion data.
-
Access Live SAP Hybris C4C 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 SAP Hybris C4C data through MCP integration.
-
Query, Visualize, and Share live Reckon Data in Redash
Use CData Connect AI to connect to live Reckon data in Redash for querying, visualizing, and sharing.
-
Integrate Autopilot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Autopilot data from Informatica Cloud.
-
How to Connect to & Open Campaigner Data in Microsoft Excel
This article uses the CData ODBC driver for Campaigner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Live Dynamics 365 Business Central Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dynamics 365 Business Central data data in natural language using Python.
-
Access ServiceNow Data from MySQL in PHP
Connect to ServiceNow through the standard MySQL libraries in PHP.
-
Automated Continuous Dynamics NAV Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Amazon S3.
-
Visualize Azure Synapse Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Synapse data.
-
Extract, Transform, and Load Sage Intacct Data in Informatica PowerCenter
Create a simple Workflow for Sage Intacct data in Informatica PowerCenter.
-
Integrating Kiro with XML 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.
-
Automated Continuous Intercom Replication to SQLite
Use CData Sync for automated, continuous, customizable Intercom replication to SQLite.
-
Connecting Pipedream with Azure DevOps 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 Azure DevOps data in real time.
-
Getting Started with the CData Power BI Connector for Cohere
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Migrating data from SAP Concur to Snowflake using CData SSIS Components.
Easily push SAP Concur data to Snowflake using the CData SSIS Tasks for SAP Concur and Snowflake.
-
How to Visualize FreeAgent Data in Python with pandas
Use pandas and other modules to analyze and visualize live FreeAgent data in Python.
-
Moving Data from xBase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live xBase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Dashboards with Raisers Edge NXT Data in Dundas BI
Create dynamic dashboards and perform analytics based on Raisers Edge NXT data in Dundas BI.
-
How to connect to PDFMonkey Data with Squirrel SQL client
Connect to PDFMonkey data and execute queries in the Squirrel SQL Client.
-
Integrate Google's Vertex AI Agent with Live Acumatica 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 Acumatica data within intelligent workflows.
-
Create Dynamic PostgreSQL Grids Using the Infragistics XamDataGrid
Learn how you can connect PostgreSQL to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Neo4J Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Neo4J data.
-
Connect to Cloudant Data in DBArtisan
Use wizards in DBArtisan to configure Cloudant data as a data source.
-
Connect to and Visualize Live Discourse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Discourse data.
-
Integrate ShipStation with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ShipStation with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ShipStation data.
-
Build Flowlu-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Flowlu data and build web apps with connectivity to live Flowlu data.
-
Connect to Gorgias in SpagoBI
Create reports featuring live Gorgias data in SpagoBI Studio. Host Gorgias reports on SpagoBI Server.
-
Consume Quickbase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Quickbase feeds that reflect any changes in SAP Lumira.
-
Connect to SAP Concur Data from a Connection Pool in Jetty
The SAP Concur JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Concur data from Web apps in Jetty.
-
Import Real-Time Greenhouse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Greenhouse data in ColdFusion.
-
Connect to Dynamics NAV from a Connection Pool in WebLogic
Use the CData JDBC Driver for Dynamics NAV to connect to Dynamics NAV data from Web applications running on WebLogic.
-
Getting Started with the CData Excel Add-In for Moosend
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Moosend.
-
Connect to Zoom Data in ACL Analytics
Connect to Zoom data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoom data.
-
Create Datasets from Excel in Domo Workbench and Build Visualizations of Excel Data in Domo
Use the CData Software ODBC Driver for Excel to create datasets from Excel data in Domo Workbench and then build visualizations in the Domo service.