CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon DynamoDB.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Business One
Create SAP Business One data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect and Query Live SAP Ariba Source Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source into Databricks
-
Build a Simple VCL Application for Testmonitor Data
How to build a simple VCL Application to view Testmonitor in RAD Studio using the CData ODBC Driver for Testmonitor.
-
Integrate Theia IDE with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Build an ETL App for Shippo Data in Python with CData
Create ETL applications and real-time data pipelines for Shippo in Python with petl.
-
Integrating Codex CLI with Elasticsearch 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.
-
Automate Jodoo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Jodoo replication to Azure Data Lake.
-
How to Seamlessly Import Vimeo Data into IBM SPSS Modeler
Integrate Vimeo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Tickspot in SAS for Real-Time Reporting and Analytics
Connect to real-time Tickspot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tickspot.
-
Load Office 365 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Office 365 to a database.
-
Automate DB2 Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM DB2 replication to Azure Synapse.
-
How to Connect DBeaver to Hugging Face via a JDBC Driver
Manage Hugging Face with visual tools in DBeaver like the query browser.
-
Import BigCommerce Data Using Azure Data Factory
Use CData Connect AI to connect to BigCommerce Data from Azure Data Factory and import live BigCommerce.
-
DataBind Charts to RabbitMQ Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to RabbitMQ from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Query Live Google Calendar Data in Claude Desktop
Connect to and query live Google Calendar Data in Claude Desktop using CData MCP Server.
-
Rapidly Develop Okta-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 Okta.
-
Access Live MariaDB Data in AWS Lambda
Connect to live MariaDB in AWS Lambda using the CData JDBC Driver.
-
Explore Geographical Relationships in Presto Data with Power Map
Create data visualizations with Presto in Power Map.
-
How to Build an ETL App for Stripe Data in Python with CData
Create ETL applications and real-time data pipelines for Stripe in Python with petl.
-
Integrate with NASA Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy NASA to a JSON file on disk.
-
Model, Search, and Visualize Live CouchDB Data in ThoughtSpot
Use CData Connect AI to connect to live Apache CouchDB for modeling, searching, and visualizing.
-
Automated Continuous SendPulse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SendPulse replication to AlloyDB.
-
Analyze EmailOctopus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze EmailOctopus with the CData JDBC Driver for EmailOctopus.
-
Feed Drift Data into FineReport
How to set Drift as a JDBC data source in FineReport.
-
Access TigerGraph 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 TigerGraph.
-
Automated Continuous Reckon Accounts Hosted Replication to Vertica
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Vertica.
-
Build Voice Agents in ElevenLabs with access to Live SAP ByDesign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Business ByDesign.
-
Import and Visualize WordPress Data in Power View
Create data visualizations based on WordPress in Excel.
-
Replicate Multiple Excel Online Accounts
Replicate multiple Excel Online accounts to one or many databases.
-
Bidirectional Access to Pinterest Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pinterest in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Airtable Data using the CData ODBC Driver
Use the SQL Gateway and Airtable ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for Pinterest
Create Pinterest data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with Vercel Data in AWS Glue Jobs Using JDBC
Connect to Vercel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Live Splunk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Splunk and integrate live Splunk into apps built in Microsoft Power Apps.
-
Create Dashboards and Visualize Live Lakebase Data in Geckoboard
Use CData Connect AI to connect to live Lakebase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Vercel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Vercel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to FHIR Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FHIR and the SQL Gateway to access FHIR from Google Apps Script.
-
Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300
This article shows how to connect faster to Sage 300 data from Asprova.
-
Create Power BI Reports on Real-Time Mixpanel Data
Use the CData ODBC Driver for Mixpanel to visualize Mixpanel in Power BI Desktop.
-
How to Work with PayPal Data in ETL Validator JDBC
Connect to PayPal from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate PabblySubscriptions with Apache Airflow
Access and process PabblySubscriptions in Apache Airflow using the CData JDBC Driver.
-
Query Oracle Eloqua Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Eloqua from Node.js.
-
Access Live Nethunt Data in AWS Lambda
Connect to live Nethunt in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Amazon Marketplace Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Snowflake.
-
Build Dashboards with OnePageCrm Data in DBxtra
Create dynamic dashboards and perform analytics based on OnePageCrm in DBxtra.
-
Integrate Microsoft Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Ads and integrate live Microsoft Ads into your Power Automate tasks.
-
Access Live Google Search Results in Excel 365 Online (Excel for the web)
Connect to Google Search from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for Redis from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Redis to connect to Redis from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Redis in Excel.
-
Use Microsoft Copilot Studio to talk to your Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Salesforce CRM Analytics for you.
-
Replicate Front Data from PowerShell
Write a quick PowerShell script to query Front. Use connectivity to the live data to replicate Front to SQL Server.
-
Use the CData Software JDBC Driver for SingleStore in MicroStrategy Web
Connect to SingleStore in MicroStrategy Web using the CData Software JDBC Driver for SingleStore.
-
Automated Continuous SendInBlue Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SendInBlue replication to IBM DB2.
-
Build Pipelines with Live Google Directory Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Directory from Google Cloud Data Fusion, enabling the integration of live Google Directory into the building and management of effective data pipelines.
-
Build Data Flows from XML to SQL Server using SSIS
Easily back up XML Files to SQL Server using the SSIS components for XML.
-
Use JayDeBeApi to access PolarTeamPro Data in Python
Use standard Python scripting and the development environment of your choice to access live PolarTeamPro.
-
Connect to Zoho Recruit Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate SAP Hybris C4C Data to Multiple Databases
Replicate SAP Hybris C4C to disparate databases with a point-and-click configuration.
-
Analyze FTP Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of FTP Servers and visualize live FTP Servers in Infragistics Reveal.
-
Integrate Google Translate Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Translate from Informatica Cloud.
-
Create Close Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Close from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to load Onfleet data into Elasticsearch via Logstash
Introducing a simple method to load Onfleet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Aircall-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aircall.
-
Consume Sage 200 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage 200 feeds that reflect any changes in SAP Lumira.
-
Natively Connect to Printify Data in PHP
The CData ODBC driver for Printify enables you to create PHP applications with connectivity to Printify. Leverage the native support for ODBC in PHP.
-
Analyze ADP Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ADP in Microsoft R Open.
-
Extract, Transform, and Load Avaza Data in Informatica PowerCenter
Create a simple Workflow for Avaza in Informatica PowerCenter.
-
Connecting GenSpark with Trello Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Trello without any replication or custom integration required.
-
Access Tavily 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 Tavily.
-
Use the CData API Server to Access Neo4J Data in Microsoft PowerPivot
Use the CData API Server to connect to live Neo4J in the Power Pivot business intelligence tool.
-
Visualize Humanity 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 Humanity into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy Desktop
Connect to SAP Fieldglass in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Fieldglass.
-
Access Live Sybase Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Sybase through MCP integration.
-
Integrate BenchmarkEmail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live BenchmarkEmail from Informatica Cloud.
-
Create Data Visualizations Based On Azure Table Data in Mode
Use CData Connect AI to connect to Azure Table Data from Mode and build visualizations using live
-
Choosing the Best Method to Connect CircleCI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CircleCI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Cloudant Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live IBM Cloudant.
-
Query Certinia Data as a MySQL Database in Node.js
Execute MySQL queries against Certinia from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Paylocity Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paylocity to SQL Server.
-
Connect to SAP HANA Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP HANA from Appeon PowerBuilder using the CData ADO.NET Provider for SAP HANA.
-
Viewing Vimeo Data in RAD Studio Data Explorer
How to view Vimeo in RAD Studio Data Explorer using the CData ODBC Driver for Vimeo.
-
Process & Analyze Klaviyo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Klaviyo Data.
-
ETL AfterShip in Oracle Data Integrator
This article shows how to transfer AfterShip into a data warehouse using Oracle Data Integrator.
-
Connect to SAP Concur Data from AWS Glue
Use CData Connect AI to gain access to live SAP Concur from your AWS Glue jobs.
-
Connect to Acumatica Data in RapidMiner
Integrate Acumatica ERP with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect YouTube Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect YouTube Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Query Excel Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Excel and perform CRUD operations on Excel from Node.js.
-
Use Azure AI Foundry to Talk to Your GitLab 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 GitLab for you.
-
Build Facebook-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Facebook to explore live Facebook Data in Gemini Code Assist to assist with building Facebook-powered applications.
-
Getting Started with the CData Python Connector for LionDesk
Learn to install and license the CData Python Connector
-
How to import Zoho Creator Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Creator in Data Import Handler and create an automated import of Zoho Creator to Apache Solr Enterprise Search platform.
-
Connect to Notion Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Notion and the SQL Gateway to access Notion from Google Apps Script.
-
Getting Started: Connect ChatGPT to Your Data with CData Connect AI
Learn how to connect ChatGPT to your live data sources using CData Connect AI and start asking questions about your data in natural language.
-
How to connect Amazon QuickSight to Certinia Data
Create a connection to Certinia in CData Connect AI and insert Certinia into Amazon QuickSight SPICE to build interactive dashboards.
-
Excel Spreadsheet Automation on Short.io Data with the QUERY Formula
Pull data from Short.io, automate spreadsheets, and more with the QUERY formula.
-
Publish Reports with Bugsnag Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bugsnag.
-
How to Connect the Power BI Service to MarkLogic: Complete Guide
Connect to the CData Software Power BI Connector for MarkLogic from PowerBI.com to provide real-time MarkLogic across the organization.
-
Replicate Cloudflare Data to Multiple Databases
Replicate Cloudflare to disparate databases with a point-and-click configuration.
-
Build Apps with Live eBay in Adalo using CData Connect AI
Use CData Connect AI to integrate live eBay into the Adalo platform and build custom mobile and web applications with real-time eBay.
-
Replicate Multiple Raisers Edge NXT Accounts
Replicate multiple Raisers Edge NXT accounts to one or many databases.