CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Procore Data in PHP
The CData ODBC driver for Procore enables you to create PHP applications with connectivity to Procore. Leverage the native support for ODBC in PHP.
-
How to load SAP Business One data into Elasticsearch via Logstash
Introducing a simple method to load SAP Business One data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use JayDeBeApi to access Impala Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache Impala.
-
Import Real-Time Float Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Float in ColdFusion.
-
Build Data Flows from Pinecone to SQL Server using SSIS
Easily back up Pinecone to SQL Server using the SSIS components for Pinecone.
-
Connect to and Visualize Live SAP Fieldglass Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Fieldglass.
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy Web
Connect to MarkLogic in MicroStrategy Web using the CData Software ODBC Driver for MarkLogic.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FTP Servers to Power BI dashboards. Simply drag and drop FTP Servers into data visuals on the Power BI canvas.
-
Integrating OpenCode Terminal with Outlook 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.
-
Build Semantic Layer Views for Stack Exchange Data in APOS Live Data Gateway
Use the CData Connector for Stack Exchange in APOS Live Data Gateway to build Semantic Layer Views for Stack Exchange.
-
Use Azure AI Foundry to Talk to Your SAP SuccessFactors 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 SAP SuccessFactors for you.
-
Build MVC Applications with Connectivity to SAP SuccessFactors LMS Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP SuccessFactors LMS from an ASP.NET MVC application.
-
Process & Analyze SendGrid Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendGrid Data.
-
Back Up Tickspot to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Tickspot data.
-
Automated Smartsheet Data Replication to Teradata
Use CData Sync to Customize and automate Smartsheet replication to Teradata.
-
Integrating Codex CLI with Zoho Recruit 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 Easily Query MySQL Data in OpenOffice Base
Connect to MySQL data in OpenOffice Base using the CData ODBC Driver for MySQL and generate reports with live data insights.
-
Use Manus AI to Talk to Your Active Directory 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 Active Directory.
-
Integrating Gumloop with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Ads within automated workflows.
-
Exact Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Exact Online facts in real time.
-
Integrating Codex CLI with Google Forms 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.
-
Connect Greenplum Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pivotal GreenPlum using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Dynamic ShipStation Grids Using the Infragistics XamDataGrid
Learn how you can connect ShipStation to Infragistics XamDataGrid to build dynamic grids.
-
How to Build an ETL App for Cloudflare Data in Python with CData
Create ETL applications and real-time data pipelines for Cloudflare in Python with petl.
-
Object-Relational Mapping (ORM) with Autopilot 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 Autopilot into a Java-based ORM framework, Hibernate.
-
Integrating Cursor CLI with SharePoint Excel Services 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 Seamlessly Import Notion Data into IBM SPSS Modeler
Integrate Notion data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to AdRoll Data in DBVisualizer
Integrate AdRoll with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Dash to Build to Web Apps on Sage Cloud Accounting Data
Create Python applications that use pandas and Dash to build Sage Cloud Accounting-connected web apps.
-
Design BIRT Reports on AlloyDB Data
Provide current Google AlloyDB to your embedded analytics.
-
How to connect and process Reply.io from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Reply.io.
-
Migrating data from Adobe Experience Manager to Google BigQuery using CData SSIS Components.
Easily push Adobe Experience Manager to Google BigQuery using the CData SSIS Tasks for Adobe Experience Manager and Google BigQuery.
-
Natively Connect to Tavily Data in PHP
The CData ODBC driver for Tavily enables you to create PHP applications with connectivity to Tavily. Leverage the native support for ODBC in PHP.
-
Automated Continuous Front Replication to SQLite
Use CData Sync for automated, continuous, customizable Front replication to SQLite.
-
Model, Search, and Visualize Live Snowflake Data in ThoughtSpot
Use CData Connect AI to connect to live Snowflake for modeling, searching, and visualizing.
-
Analyze Amazon Athena Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon Athena in Microsoft R Open.
-
Back Up MessageBird to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with MessageBird data.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy Desktop
Connect to Apache Parquet in MicroStrategy Desktop using the CData Software JDBC Driver for Parquet.
-
Publish Productboard-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Productboard.
-
Visualize Live Sybase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sybase into custom reports in Power BI.
-
Connect to Real-Time Google Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Ads and Dataflow to import and use Google Ads in Power Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for MailerSend
Create MailerSend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for SharePoint Excel Services in Microsoft Power Query
You can use the CData SharePoint Excel Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SharePoint Excel Services into Microsoft Power Query.
-
Automated Continuous Azure Data Catalog Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Amazon Redshift.
-
Build a Simple VCL Application for Snapchat Ads Data
How to build a simple VCL Application to view Snapchat Ads in RAD Studio using the CData ODBC Driver for Snapchat Ads.
-
Analyze NetSuite Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of NetSuite CRM & ERP and visualize live NetSuite CRM & ERP in Infragistics Reveal.
-
How to Query Live ElevenLabs Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ElevenLabs data in natural language using Python.
-
Build Microsoft Dataverse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Dataverse Data and create custom apps in Bubble.
-
Access Live Azure Table Data in TIBCO Data Virtualization
Use the Azure Table Tibco DV Adapter to create a Azure Table Storage data source in TIBCO Data Virtualization Studio and gain access to live Azure Table Storage from your TDV Server.
-
Query FreeAgent Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FreeAgent from Node.js.
-
Integrate Freshteam with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshteam with External Services.
-
Build Monday.com Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Monday.com and build visualizations in Tableau Cloud.
-
Explore Geographical Relationships in Sybase IQ Data with Power Map
Create data visualizations with Sybase IQ in Power Map.
-
ETL Google Translate in Oracle Data Integrator
This article shows how to transfer Google Translate into a data warehouse using Oracle Data Integrator.
-
Create Google Ad Manager Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Ad Manager from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Salesforce Marketing Data from MySQL in Amazon QuickSight
Connect to Salesforce Marketing and build visualizations of Salesforce Marketing Cloud using a MySQL Connection in Amazon QuickSight.
-
Build Adobe Target-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Adobe Target and build web apps with connectivity to live Adobe Target.
-
Integrate with Omnisend Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Omnisend to a JSON file on disk.
-
Create DB2-Connected Applications in Appsmith
Connect to DB2 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to IBM DB2.
-
Automated Continuous SAP Business One Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Business One replication to Databricks.
-
DataBind Microsoft OneDrive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft OneDrive with the DevExpress Windows Forms and Web controls to provide Microsoft OneDrive to a chart.
-
Analyze Aha! Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aha! in Microsoft R Open.
-
Connect to Brex Data from PowerBuilder via JDBC
This article demonstrates how to access Brex from PowerBuilder using the Brex JDBC Driver.
-
Integrating Kiro CLI with SpaceX 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.
-
Publish Reports with Intercom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Intercom.
-
Create Jira-Connected Applications in Appsmith
Connect to Jira Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Atlassian Jira.
-
Connect to Mocean Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mocean and the SQL Gateway to access Mocean from Google Apps Script.
-
Getting Started with the CData SSIS Components for Zoom
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoom.
-
Work with Live Redis Data in Power Query
Use CData Connect AI to connect to Redis and work with live Redis in Microsoft Power Query.
-
Connect Power BI XMLA Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Power BI XMLA using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to SparkPost Data from Spring Boot
Connect to SparkPost in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Recurly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Recurly in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData ODBC Driver for AfterShip
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for AfterShip.
-
Query Highrise Data as a SQL Server Database in Node.js
Execute SQL Server queries against Highrise CRM from Node.js.
-
How to Access Live Neo4J Data in Visual Studio Code via Cline
Run CData MCP Server for Neo4J on Windows Subsytem for Linux (WSL) and connect to live Neo4J from the Cline extension in Visual Studio Code.
-
Connect to SAP Netweaver Gateway Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create ClickUp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ClickUp from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live SAS xpt 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 SAS XPORT through MCP integration.
-
Access Live Hubstaff Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Hubstaff into the statistical analysis tools available in SAS JMP. This article shows how to use Hubstaff in the Graph Builder and Query Builder.
-
Automated Continuous Billsby Replication to Databricks
Use CData Sync for automated, continuous, customizable Billsby replication to Databricks.
-
Moving Data from Cassandra to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cassandra data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to FHIR Data from HeidiSQL
Use CData Connect AI to connect to and query live FHIR from HeidiSQL.
-
Connect to AlloyDB Data in JRuby
Create a simple JRuby app with access to live Google AlloyDB.
-
Connect to SQL Server Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft SQL Server in Airbyte.
-
Visualize Twitter Ads 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 Twitter Ads into TIBCO Spotfire.
-
Connect to Airtable Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Airtable and the Script function in FileMaker Pro to connect to Airtable and work with Airtable in your FileMaker application.
-
Enable the Blackbaud FE NXT JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Blackbaud FE NXT.
-
Build Zoho Projects-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zoho Projects to explore live Zoho Projects Data in Claude Code to assist with building Zoho Projects-powered applications.
-
Create SSAS Tabular Models from Dynamics NAV Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Dynamics NAV using CData drivers.
-
Access Live SAP Ariba Procurement 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 Ariba Procurement through MCP integration.
-
Connecting Pipedream with SAP BusinessObjects BI 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 SAP BusinessObjects BI data in real time.
-
Validate SAS xpt Data with QuerySurge
Access and validate SAS XPORT in QuerySurge using the CData JDBC Driver.
-
Connect to SAP Netweaver Gateway Data in ACL Analytics
Connect to SAP Netweaver Gateway via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Netweaver Gateway.
-
Create a Data Access Object for Hacker News Data using JDBI
A brief overview of creating a SQL Object API for Hacker News in JDBI.
-
Query ZendeskSell Data as a MySQL Database in Node.js
Execute MySQL queries against ZendeskSell from Node.js.
-
Integrate with Live NetSuite Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to NetSuite from the MuleSoft Anypoint Platform to integrate live NetSuite CRM & ERP into custom reports and dashboards.
-
How to connect to Wave Financial Data with Squirrel SQL client
Connect to Wave Financial and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData ODBC Driver for Aha!
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Aha!.
-
Integrating OpenCode Terminal with Bright Data 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.
-
Automate PagerDuty Data Replication to SAP HANA
Use CData Sync to customize and automate PagerDuty replication to SAP HANA.