CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Gorgias Data in OpenOffice Base
Connect to Gorgias data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Live Azure Table Data in SAS Viya
Use CData Connect AI to connect to Azure Table Storage from SAS Viya and deploy self-service analytics using live Azure Table Storage.
-
Connect to FormSite from a Connection Pool in WebLogic
Use the CData JDBC Driver for FormSite to connect to FormSite from Web applications running on WebLogic.
-
How to Connect to Live MYOB AccountRight 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 MYOB AccountRight for you.
-
How to connect SharePoint with Klaviyo Data through external lists
Provide Klaviyo to SharePoint users as an external list.
-
Import Databricks Data Using Azure Data Factory
Use CData Connect AI to connect to Databricks Data from Azure Data Factory and import live Databricks.
-
Automated Continuous Avalara AvaTax Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Apache Kafka.
-
Analyze Live ShipStation Data in SAS Viya
Use CData Connect AI to connect to ShipStation from SAS Viya and deploy self-service analytics using live ShipStation.
-
Replicate Cassandra Data from PowerShell
Write a quick PowerShell script to query Apache Cassandra. Use connectivity to the live data to replicate Apache Cassandra to SQL Server.
-
Create Google Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Directory from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Square 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 Square for you.
-
Access Amazon S3 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon S3 from HeidiSQL.
-
Build Visualizations of Eventbrite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Eventbrite in Birst.
-
Connect to Gumroad in SpagoBI
Create reports featuring live Gumroad in SpagoBI Studio. Host Gumroad reports on SpagoBI Server.
-
Automated Continuous Jira Assets Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Jira Assets replication to Amazon S3.
-
Automated Continuous Jodoo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jodoo replication to IBM DB2.
-
Create Paddle Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Paddle from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect the Power BI Service to Avalara AvaTax: Complete Guide
Connect to the CData Software Power BI Connector for Avalara AvaTax from PowerBI.com to provide real-time Avalara AvaTax across the organization.
-
Create a Data Access Object for Teamgate Data using JDBI
A brief overview of creating a SQL Object API for Teamgate in JDBI.
-
Connecting Mastra with IBM Cloud Object Storage 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 IBM Cloud Object Storage, no replication required.
-
Connect to Placid Data from PowerBuilder via ADO.NET
This article demonstrates how to access Placid from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to xBase Data from a Connection Pool in Jetty
The xBase JDBC Driver supports connection pooling: This article shows how to connect faster to xBase from Web apps in Jetty.
-
Query Snapchat Ads Data in DataGrip
Create a Data Source for Snapchat Ads in DataGrip and use SQL to query live Snapchat Ads.
-
Connect to NetSuite from Asprova with CData Software ODBC Driver for NetSuite
This article shows how to connect faster to NetSuite data from Asprova.
-
Connect to Sendwithus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sendwithus to connect to Sendwithus and execute queries in PowerBuilder.
-
Connect to Bannerbear Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bannerbear using standard SQL.
-
Connect to Real-Time Azure Synapse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Synapse and Dataflow to import and use Azure Synapse in Power Apps.
-
Process & Analyze Vault CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Vault CRM Data.
-
Excel Spreadsheet Automation on SAP Netweaver Gateway Data with the QUERY Formula
Pull data from SAP Netweaver Gateway, automate spreadsheets, and more with the QUERY formula.
-
Use Dash to Build to Web Apps on QuickBooks Time Data
Create Python applications that use pandas and Dash to build QuickBooks Time-connected web apps.
-
Automate CockroachDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live CockroachDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Dashboards and Visualize Live Monday.com Data in Geckoboard
Use CData Connect AI to connect to live Monday.com and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze SendInBlue Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendInBlue in Microsoft R Open.
-
Connect to Google Sheets Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Sheets from Appeon PowerBuilder using the CData ADO.NET Provider for Google Sheets.
-
How to work with Greenplum Data in Apache Spark using SQL
Access and process Greenplum Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for Calendly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Calendly.
-
Build Apps with Live Presto in Adalo using CData Connect AI
Use CData Connect AI to integrate live Presto into the Adalo platform and build custom mobile and web applications with real-time Presto.
-
How to load Exa data into Elasticsearch via Logstash
Introducing a simple method to load Exa data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Mocean Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mocean from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Keap Data in MySQL Workbench
Execute MySQL queries against live Keap from MySQL Workbench.
-
Zoho Inventory Reporting in OBIEE with the Zoho Inventory JDBC Driver
Deploy the Zoho Inventory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Real-Time Browserless Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Browserless in ColdFusion.
-
Build an OLAP Cube in SSAS from Harvest Data
Establish a connection to Harvest data from SQL Server Analysis Services, and use the Harvest Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Chargebee Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Chargebee replication to IBM DB2.
-
Visualize Live ShipStation Data in the Power BI Service
Use CData Connect AI to connect to live ShipStation and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with SingleStore Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SingleStore to a JSON file on disk.
-
Use the CData SSIS Components to Insert New or Update Existing HubDB Records from SQL Server
Easily push SQL Server data to HubDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HubDB or update existing records with data from a SQL Server database.
-
Load GetResponse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GetResponse to a database.
-
Connect to AlloyDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Semantic Layer Views for SharePoint Data in APOS Live Data Gateway
Use the CData Connector for SharePoint in APOS Live Data Gateway to build Semantic Layer Views for Microsoft SharePoint.
-
Create Informatica Mappings From/To an ODBC Data Source for Xero
Create an ODBC connection to Xero in Informatica and browse and transfer Xero Accounting.
-
Automated Continuous eBay Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable eBay replication to Google Cloud SQL.
-
Automated Continuous PivotalTracker Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PivotalTracker replication to AlloyDB.
-
Access Live Printful Data in Coginiti Pro
Connect to and query live Printful from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating LangChain with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on LinkedIn within automated workflows.
-
Query Gumroad Data in DataGrip
Create a Data Source for Gumroad in DataGrip and use SQL to query live Gumroad.
-
LightSpeedRetail Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LightSpeedRetail facts in real time.
-
Design BIRT Reports on LightSpeedRetail Data
Provide current LightSpeedRetail to your embedded analytics.
-
Establish a Live Connection with Wrike Data using Tableau Bridge
The CData ODBC Driver for Wrike enables you to integrate live Wrike into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Shopify in Microsoft Power Query
You can use the CData Shopify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Shopify into Microsoft Power Query.
-
Integrating LlamaIndex with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BigCommerce in real time.
-
Access Printful Data from MySQL in PHP
Connect to Printful through the standard MySQL libraries in PHP.
-
Automated Continuous Sybase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sybase replication to OneLake in Microsoft Fabric.
-
Visualize PabblySubscriptions Data in Tableau
The CData ODBC driver for PabblySubscriptions enables you integrate PabblySubscriptions into Tableau dashboards.
-
Connecting GenSpark with Microsoft Planner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Planner without any replication or custom integration required.
-
Build Dropbox-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Dropbox to explore live Dropbox Data in Cursor to assist with building Dropbox-powered applications.
-
Getting Started with the CData ODBC Driver for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle SCM.
-
Import and Visualize Blackbaud FE NXT Data in Power View
Create data visualizations based on Blackbaud FE NXT in Excel.
-
Use the CData Software JDBC Driver for Bitly in MicroStrategy Web
Connect to Bitly in MicroStrategy Web using the CData Software JDBC Driver for Bitly.
-
Automated Continuous Campaigner Replication to Snowflake
Use CData Sync for automated, continuous, customizable Campaigner replication to Snowflake.
-
Connect to Pipeliner CRM from Asprova with CData Software ODBC Driver for Pipeliner CRM
This article shows how to connect faster to Pipeliner CRM data from Asprova.
-
Use the CData Software JDBC Driver for DocuSign in MicroStrategy
Connect to DocuSign in MicroStrategy Developer using the CData Software JDBC Driver for DocuSign.
-
Use the CData Software JDBC Driver for iContact in MicroStrategy Desktop
Connect to iContact in MicroStrategy Desktop using the CData Software JDBC Driver for iContact.
-
Integrating Cursor CLI with Typeform 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.
-
A PostgreSQL Interface for Google Campaign Manager 360 Data using the CData ODBC Driver
Use the SQL Gateway and Google Campaign Manager 360 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Bridge Google Ad Manager Connectivity with Apache NiFi
Access and process Google Ad Manager in Apache NiFi using the CData JDBC Driver.
-
Create Reports with Contentful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Contentful.
-
Automated Continuous Oracle Service Cloud Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Amazon Redshift.
-
Query CSV Data as a MySQL Database in Node.js
Execute MySQL queries against CSV/TSV Files from Node.js.
-
Connecting Agentforce with Google Campaign Manager 360 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 Google Campaign Manager 360 for you.
-
View Reports on Real-Time eBay Data in Power BI Report Server
Use the CData ODBC Driver for eBay to visualize eBay in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect Certinia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Certinia using the CData Python MCP Server.
-
Integrate Live Strava Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Strava to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy Desktop
Connect to Blackbaud FE NXT in MicroStrategy Desktop using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Replicate Neo4J Data to Multiple Databases via the CData Sync CLI
Replicate Neo4J to disparate databases with a single configuration.
-
Object-Relational Mapping (ORM) with Parquet Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Parquet into a Java-based ORM framework, Hibernate.
-
Build Charts with Excel Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Excel in Clear Analytics.
-
Publish Crystal Reports on ScrapingBee Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ScrapingBee.
-
Access Webex 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 Webex.
-
How to Work with ZarMoney Data in AWS Glue Jobs Using JDBC
Connect to ZarMoney from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Semantic Layer Views for Avalara AvaTax Data in APOS Live Data Gateway
Use the CData Connector for Avalara AvaTax in APOS Live Data Gateway to build Semantic Layer Views for Avalara AvaTax.
-
Natively Connect to BigCommerce Data in PHP
The CData ODBC driver for BigCommerce enables you to create PHP applications with connectivity to BigCommerce. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Opsgenie in MicroStrategy
Connect to Opsgenie in MicroStrategy Developer using the CData Software ODBC Driver for Opsgenie.
-
Access Live Redis Data in Excel 365 Online (Excel for the web)
Connect to Redis from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Miro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Miro with External Services.
-
Connect to Email Data in Jaspersoft Studio
Execute SQL to remote Email in Jaspersoft Studio.
-
How to Connect to Live Slack Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Slack through natural language.
-
Automated Continuous Raisers Edge NXT Replication to Snowflake
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Snowflake.
-
Connecting Mastra with Redshift 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 Amazon Redshift, no replication required.
-
Access Live CouchDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache CouchDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.