CData Software - Knowledge Base
Recent Articles
-
How to load ADP data into Elasticsearch via Logstash
Introducing a simple method to load ADP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Choosing the Best Method to Connect Twilio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Twilio data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Datasets from ZarMoney in Domo Workbench and Build Visualizations of ZarMoney Data in Domo
Use the CData Software ODBC Driver for ZarMoney to create datasets from ZarMoney data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Desktop
Connect to Mixpanel data in MicroStrategy Desktop using the CData Software JDBC Driver for Mixpanel.
-
LINQ to Google Campaign Manager 360 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 Google Campaign Manager 360 Data Provider.
-
Create ShipEngine Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ShipEngine data access from reports, embedded analytics, and more.
-
Connect to Accelo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Accelo to connect to Accelo data from Web applications running on WebLogic.
-
Integrating OpenCode with Strava 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.
-
Analyze Brex Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Brex from Power Pivot. You will use the Table Import Wizard to load Brex data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate with ZohoInvoice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoInvoice data to a JSON file on disk.
-
Integrate with Procore Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Procore data in SnapLogic.
-
Automate Teradata Data Replication to Azure Synapse
Use CData Sync to customize and automate Teradata data replication to Azure Synapse.
-
Connect to Scrapfly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Scrapfly as an External Source in Dremio.
-
Add Postmark Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Postmark with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Excel Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Excel Online data and integrate live Excel Online data into apps built in Microsoft Power Apps.
-
Integrate Workday Data into Power Automate Desktop using CData Connect
CData Connect for Workday Data enables you to integrate Workday data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Smartsheet 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 Smartsheet data for you.
-
Import Acumatica Data Using Azure Data Factory
Use CData Connect AI to connect to Acumatica Data from Azure Data Factory and import live Acumatica data.
-
Integrate BigCommerce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BigCommerce with External Services.
-
Build AI Agents with Google Analytics Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Analytics data through CData Connect AI.
-
Integrate YouTube Analytics Data in the Pentaho Report Designer
Publish reports based on YouTube Analytics data in the Pentaho BI tool.
-
How to Easily Query MarkLogic Data in OpenOffice Base
Connect to MarkLogic data in OpenOffice Base using the CData ODBC Driver for MarkLogic and generate reports with live data insights.
-
Analyze Cloudant Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Cloudant data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connecting Mastra with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Okta data, no replication required.
-
Connect to Webex from a Connection Pool in WebLogic
Use the CData JDBC Driver for Webex to connect to Webex data from Web applications running on WebLogic.
-
Automated Continuous Beeminder Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Beeminder replication to PostgreSQL.
-
Build Agents in Relevance AI with Access to Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SparkPost data within intelligent agent workflows.
-
Build Data Flows from Instantly to SQL Server using SSIS
Easily back up Instantly data to SQL Server using the SSIS components for Instantly.
-
Integrate Egnyte Data in Pentaho Data Integration
Build ETL pipelines based on Egnyte data in the Pentaho Data Integration tool.
-
Integrating Kiro with Sage Cloud Accounting 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.
-
Integrating Claude Code with Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon Marketplace data within assisted coding and automated development workflows.
-
Automated Continuous Microsoft OneLake Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to MongoDB.
-
Connect to ZohoExpense Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ZohoExpense data in Airbyte.
-
Use the CData Software ODBC Driver for Close in MicroStrategy Desktop
Connect to Close data in MicroStrategy Desktop using the CData Software ODBC Driver for Close.
-
How to Easily Query Salesforce Marketing Data in OpenOffice Base
Connect to Salesforce Marketing data in OpenOffice Base using the CData ODBC Driver for Salesforce Marketing and generate reports with live data insights.
-
Integrate Theia IDE with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Slack data from within the development environment.
-
Connect to Sybase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sybase data.
-
Working with Mistral AI Data in LINQPad
Execute LINQ queries to Mistral AI data in LINQPad.
-
Build Automated ClickUp-Connected Workflows in Zapier
Use CData Connect AI to connect to live ClickUp data and build automated workflows in Zapier.
-
Integrating LangChain with Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Instagram data within automated workflows.
-
Integrating GitHub Copilot with Invoiced 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 Live NASA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate NASA data into the statistical analysis tools available in SAS JMP. This article shows how to use NASA data in the Graph Builder and Query Builder.
-
How to Connect to Nuclia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Nuclia data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple CapsuleCRM Accounts
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Connect to Azure Data Lake Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Azure Data Lake Storage.
-
Connect to Google Contacts Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Contacts data from Crystal Reports.
-
Create Pingdom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pingdom data access from reports, embedded analytics, and more.
-
Use Azure AI Foundry to Talk to Your Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Sugar CRM data for you.
-
Access Live Acumatica Data in Coginiti Pro
Connect to and query live Acumatica data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize MariaDB Data in Sisense
Create an ElastiCube in Sisense app with access to MariaDB data.
-
Create SSAS Tabular Models from ConvertAPI Data
How to build a SQL Server Analysis Service Tabular Model from ConvertAPI data using CData drivers.
-
Import BambooHR Data Using Azure Data Factory
Use CData Connect AI to connect to BambooHR Data from Azure Data Factory and import live BambooHR data.
-
Choosing the Best Method to Connect Sendwithus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sendwithus data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to PhantomBuster Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PhantomBuster data in the Denodo Virtual DataPort Administrator.
-
How to Work with Postmark Data in AWS Glue Jobs Using JDBC
Connect to Postmark from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Feed Zoho Creator Data into FineReport
How to set Zoho Creator data as a JDBC data source in FineReport.
-
Analyze SQL Analysis Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SQL Analysis Services from Power Pivot. You will use the Table Import Wizard to load SQL Analysis Services data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk data in MicroStrategy Desktop using the CData Software ODBC Driver for Freshdesk.
-
Build a Singer.io Tap for ShipEngine With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ShipEngine data using the CData Python Connector.
-
Connect to AlloyDB Data in Jaspersoft Studio
Execute SQL to remote AlloyDB data in Jaspersoft Studio.
-
Automated Continuous Microsoft Dataverse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Amazon Redshift.
-
How to connect and process Oracle SCM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle SCM data.
-
Connect to WooCommerce Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with WooCommerce Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to API Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for API Data and connect to API data in Akorbi Digital RunMyProcess.
-
How to Connect to Live Moosend 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 Moosend data for you.
-
Connect to Live Epicor Kinetic Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Epicor Kinetic in CData Connect AI and connect to your Epicor Kinetic data from PostgreSQL.
-
Create Salesloft-Connected Business Apps in AppSheet
Connect to Salesloft Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesloft data.
-
How to create JobNimbus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JobNimbus data in MySQL .
-
Connect to Tickspot Data in NetBeans
Connect to Tickspot data in NetBeans with the data source configuration wizard.
-
Automated Continuous Supabase Replication to SQLite
Use CData Sync for automated, continuous, customizable Supabase replication to SQLite.
-
Migrating data from Zendesk to Google BigQuery using CData SSIS Components.
Easily push Zendesk data to Google BigQuery using the CData SSIS Tasks for Zendesk and Google BigQuery.
-
Connect to Sage 300 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 300 data.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy Desktop
Connect to Freshservice data in MicroStrategy Desktop using the CData Software ODBC Driver for Freshservice.
-
Automated Continuous Pipeliner CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to delimited files (CSV/TSV).
-
Replicate ZeroBounce Data from PowerShell
Write a quick PowerShell script to query ZeroBounce data. Use connectivity to the live data to replicate ZeroBounce data to SQL Server.
-
Build Zoho Projects-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Projects Data from Zoho Analytics and import live Zoho Projects data.
-
Connect to Bugsnag Data in JRuby
Create a simple JRuby app with access to live Bugsnag data.
-
Deploy the ADO.NET Provider for FreeAgent on an SSRS Report Server
Connect to FreeAgent 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.
-
Add Microsoft OneDrive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft OneDrive with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize Freshteam Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Freshteam data in Python.
-
Access Live ChargeOver Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ChargeOver data into the statistical analysis tools available in SAS JMP. This article shows how to use ChargeOver data in the Graph Builder and Query Builder.
-
Integrate Devin with Live Azure Data Catalog 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 Azure Data Catalog data.
-
How to Create Power BI Visual Reports with Real-Time AfterShip Data
Use CData Power BI Connectors to visualize AfterShip data in Power BI.
-
Import Real-Time Vault CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vault CRM data in ColdFusion.
-
Build AI Agents with Xero Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Xero data through CData Connect AI.
-
Access Redis Data from MySQL in Amazon QuickSight
Connect to Redis and build visualizations of Redis data using a MySQL Connection in Amazon QuickSight.
-
Publish EmailOctopus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live EmailOctopus data.
-
Build Apps with Live IBM Informix Data Using the Low-Code Development Platform of Mendix
Connect IBM Informix data with Mendix to build apps using the CData JDBC Driver for IBM Informix.
-
Write a Simple Go Application to work with Raisers Edge NXT Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Raisers Edge NXT data.
-
Add MailChimp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MailChimp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SAS xpt Data in CloverDX (formerly CloverETL)
Transfer SAS xpt data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Python Connector for SendInBlue
Learn to install and license the CData Python Connector and configure a connection to live SendInBlue data.
-
How to Access Simplesat Data Using Entity Framework
This article shows how to access Simplesat data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Azure AI Foundry to Talk to Your Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Attio data for you.
-
Integrate Google's Antigravity Agent with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MarkLogic data using the Model Context Protocol.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy
Connect to JDBC-ODBC Bridge data in MicroStrategy Developer using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Build Zendesk-Connected Apps in Choreo
Use CData Connect AI to connect to Zendesk Data from Choreo and build custom apps using live Zendesk data.
-
Automated Continuous WooCommerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable WooCommerce replication to AlloyDB.
-
Integrating Cursor with Campaigner 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.
-
Query SAS Data Sets Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAS Data Sets data from Node.js.