CData Software - Knowledge Base
Recent Articles
-
Connect to Neo4J Data in ACL Analytics
Connect to Neo4J via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Neo4J.
-
Integrating OpenCode Terminal with ZohoExpense 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 LinkedIn Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for Splunk
Create Splunk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Real-Time Okta Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Okta and Dataflow to import and use Okta in Power Apps.
-
Access Box Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Box from HeidiSQL.
-
Integrate AgileCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AgileCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AgileCRM.
-
Create a Data Access Object for Okta Data using JDBI
A brief overview of creating a SQL Object API for Okta in JDBI.
-
Automated Continuous Teamwork Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teamwork replication to Amazon Redshift.
-
How to connect to PhantomBuster Data from Spring Boot
Connect to PhantomBuster in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Ontraport Data from PowerBuilder via ADO.NET
This article demonstrates how to access Ontraport from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating LangGraph with Freshservice Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Freshservice within automated workflows.
-
Access Live GitHub Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GitHub into the statistical analysis tools available in SAS JMP. This article shows how to use GitHub in the Graph Builder and Query Builder.
-
Back Up Google Cloud Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Cloud Storage. In this article, we will employ an SSIS workflow to populate a database with Google Cloud Storage data.
-
Analyze ElevenLabs Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ElevenLabs from Power Pivot. You will use the Table Import Wizard to load ElevenLabs. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Microsoft Entra ID Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Entra ID.
-
Visualize Live Typeform Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Typeform using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Explore Geographical Relationships in ClickUp Data with Power Map
Create data visualizations with ClickUp in Power Map.
-
Connect to ZohoSubscriptions from Asprova with CData Software ODBC Driver for ZohoSubscriptions
This article shows how to connect faster to ZohoSubscriptions data from Asprova.
-
Prepare, Blend, and Analyze Gong Data in Alteryx Designer (ODBC)
Build workflows to access live Gong for self-service data analytics.
-
Connect to SAP Netweaver Gateway Data in HULFT Integrate
Connect to SAP Netweaver Gateway as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for Sentry from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sentry to connect to Sentry from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sentry in Excel.
-
Integrate Cline with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Planner from within your IDE.
-
Enable the Printify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Printify.
-
Connect to Excel Online Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Excel Online in DBeaver.
-
Automated Continuous ChargeOver Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Kafka.
-
Operational Reporting on Gumroad Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gumroad.
-
Integrate Theia IDE with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
DataBind Controls to EmailOctopus Data in Delphi
DataBind to EmailOctopus in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy Desktop
Connect to Simplesat in MicroStrategy Desktop using the CData Software ODBC Driver for Simplesat.
-
Access Live Presto Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Presto from your Excel spreadsheets.
-
How to load Bright Data data into Elasticsearch via Logstash
Introducing a simple method to load Bright Data data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze BambooHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BambooHR with the CData JDBC Driver for BambooHR.
-
How to Work with Demio Data in ETL Validator JDBC
Connect to Demio from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate SQL Analysis Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Analysis Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SQL Analysis Services.
-
Create Monday.com-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Monday.com Data from Klipfolio and build custom visualizations using live Monday.com.
-
Create Facebook Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Facebook Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Cursor CLI with Blackbaud FE NXT 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.
-
Create Datasets from Cloudant in Domo Workbench and Build Visualizations of Cloudant Data in Domo
Use the CData Software ODBC Driver for Cloudant to create datasets from IBM Cloudant in Domo Workbench and then build visualizations in the Domo service.
-
Integrate GraphQL Data in Pentaho Data Integration
Build ETL pipelines based on GraphQL in the Pentaho Data Integration tool.
-
Automated Continuous SAP ByDesign Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to MySQL.
-
How to Query Telegram Data in MySQL Workbench
Execute MySQL queries against live Telegram from MySQL Workbench.
-
Visualize Billsby Data in Tableau
The CData ODBC driver for Billsby enables you integrate Billsby into Tableau dashboards.
-
Bridge Sybase IQ Connectivity with Apache NiFi
Access and process Sybase IQ in Apache NiFi using the CData JDBC Driver.
-
Build Semantic Layer Views for Avaza Data in APOS Live Data Gateway
Use the CData Connector for Avaza in APOS Live Data Gateway to build Semantic Layer Views for Avaza.
-
Connect to Invoiced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Invoiced using standard SQL.
-
Create BigCommerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BigCommerce Data from OutSystems and build custom enterprise apps using live BigCommerce.
-
Build MVC Applications with Connectivity to Google Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Ads from an ASP.NET MVC application.
-
Connect to Kintone Data in Google Apps Script via Connect AI
Use CData Connect AI to access Kintone in Google Apps Script.
-
How to Connect to Live Epicor Kinetic 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 Epicor Kinetic through natural language.
-
Getting Started with the CData JDBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Superchat.
-
Bind Live SurveyMonkey Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SurveyMonkey data
-
Xero Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero Accounting through CData Connect AI using different applications and tools.
-
Build Charts with Mixpanel Data in Clear Analytics
Create dynamic charts and perform analytics based on Mixpanel in Clear Analytics.
-
Prepare, Blend, and Analyze Moosend Data in Alteryx Designer (ODBC)
Build workflows to access live Moosend for self-service data analytics.
-
Access Live Azure DevOps Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure DevOps from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Impala 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 Apache Impala through MCP integration.
-
Working with Act-On Data in LINQPad
Execute LINQ queries to Act-On in LINQPad.
-
Access Live Email Data in AWS Lambda
Connect to live Email in AWS Lambda using the CData JDBC Driver.
-
Analyze SAS xpt Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAS XPORT with the CData JDBC Driver for SAS xpt.
-
Publish Reports with Aha! Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aha!.
-
DataBind Controls to Asana Data in C++Builder
DataBind to Asana in C++Builder with standard components and controls.
-
Publish Crystal Reports on Teradata Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teradata.
-
Object-Relational Mapping (ORM) with Moosend 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 Moosend into a Java-based ORM framework, Hibernate.
-
How to Connect to & Open Aweber Data in Microsoft Excel
This article uses the CData ODBC driver for Aweber to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access LinkedIn Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn from HeidiSQL.
-
Integrate Lakebase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Lakebase and integrate live Lakebase into your Power Automate tasks.
-
Connect to SAP Ariba Procurement in SpagoBI
Create reports featuring live SAP Ariba Procurement in SpagoBI Studio. Host SAP Ariba Procurement reports on SpagoBI Server.
-
How to create an RPA flow for SAP Ariba Source Data in UiPath Studio
Use the SAP Ariba Source ODBC Driver to create workflows that access real-time SAP Ariba Source without any coding.
-
Build Visualizations of Redshift Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Redshift in Birst.
-
Getting Started with the CData ADO.NET Provider for Jumpseller
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live Impala Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Apache Impala for you.
-
Integrate Cline with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache Impala from within your IDE.
-
Replicate Multiple GitHub Accounts
Replicate multiple GitHub accounts to one or many databases.
-
Rapidly Develop Codat-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 Codat.
-
How to Connect to & Open Sugar CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Sugar CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating GitHub Copilot CLI with SAP HANA XS Advanced 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Square
Provide connectivity to Square through an SAP BusinessObjects universe.
-
Integrating Codex CLI with Highrise CRM 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.
-
Use Dash to Build to Web Apps on Hacker News Data
Create Python applications that use pandas and Dash to build Hacker News-connected web apps.
-
Automated Continuous Oracle Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle replication to MongoDB.
-
Replicate Keap Data in Heroku for Use in Salesforce Connect
Replicate Keap to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Outreach.io Data in TIBCO Spotfire through OData
Integrate Outreach.io into dashboards in TIBCO Spotfire.
-
Connect to and Query Certinia Data in QlikView over ODBC
Create data visualizations with Certinia in QlikView.
-
Integrating Codex CLI with SAP Ariba Source 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 GitHub Copilot CLI with SharePoint Excel Services 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.
-
Bidirectional Access to HDFS Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache HDFS in Filemaker Pro for Mac or Windows.
-
Connect Landbot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Landbot with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to & Open Reply.io Data in Microsoft Excel
This article uses the CData ODBC driver for Reply.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Add Landbot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Landbot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Authorize.Net Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Authorize.Net replication to OneLake in Microsoft Fabric.
-
Automate ZohoSubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoSubscriptions replication to SAP HANA.
-
Object-Relational Mapping (ORM) with BigCommerce 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 BigCommerce into a Java-based ORM framework, Hibernate.
-
Design BIRT Reports on YouTube Analytics Data
Provide current YouTube Analytics to your embedded analytics.
-
Getting Started with the CData Power BI Connector for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PostgreSQL.
-
Analyze Pinecone Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinecone in Microsoft R Open.
-
Use Grok to Talk to Your Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Dropbox for you.
-
Integrating Claude Code CLI with Perplexity 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 create an RPA flow for Chargebee Data in UiPath Studio
Use the Chargebee ODBC Driver to create workflows that access real-time Chargebee without any coding.
-
Create Data Visualizations Based On Greenplum Data in Mode
Use CData Connect AI to connect to Greenplum Data from Mode and build visualizations using live