CData Software - Knowledge Base
Recent Articles
-
How to Query Live LDAP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LDAP data in natural language using Python.
-
Automated Continuous Microsoft Teams Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Apache Cassandra.
-
Integrating Oracle HCM Cloud Data in Talend Cloud Data Management Platform
Connect Oracle HCM Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle HCM Cloud.
-
Back Up Microsoft Dynamics 365 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics 365. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dynamics 365 data.
-
Integrating Cursor CLI with Elorus 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 import Parquet Data into Apache Solr
Use the CData Software JDBC Driver for Parquet in Data Import Handler and create an automated import of Apache Parquet to Apache Solr Enterprise Search platform.
-
Build Data Flows from SQL Server to Zoho CRM through SSIS
Easily push SQL Server data to Zoho CRM using the CData SSIS Tasks for Zoho CRM.
-
How to connect and process Salesforce Data 360 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Data 360.
-
Visualize Live Paylocity Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paylocity using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Planio Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Planio replication to IBM DB2.
-
Rapidly Develop Apollo-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 Apollo.
-
Build Apps with Live Acumatica ERP in Adalo using CData Connect AI
Use CData Connect AI to integrate live Acumatica ERP into the Adalo platform and build custom mobile and web applications with real-time Acumatica ERP.
-
Create Datasets from Wrike in Domo Workbench and Build Visualizations of Wrike Data in Domo
Use the CData Software ODBC Driver for Wrike to create datasets from Wrike in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with SQL Analysis Services Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SQL Analysis Services in SnapLogic.
-
Auth0 Reporting in OBIEE with the Auth0 JDBC Driver
Deploy the Auth0 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Paylocity Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Paylocity replication to Apache Kafka.
-
Use Manus AI to Talk to Your Bullhorn CRM 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 Bullhorn CRM.
-
Publish Crystal Reports on Bitbucket Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bitbucket.
-
Automated Continuous QuickBooks Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to PostgreSQL.
-
How to Work with Adobe Target Data in ETL Validator JDBC
Connect to Adobe Target from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy Web
Connect to SAP HANA XS Advanced in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Build Raisers Edge NXT-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Raisers Edge NXT Data from Zoho Analytics and import live Raisers Edge NXT.
-
Rapidly Develop Mixpanel-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 Mixpanel.
-
Connect to Mistral AI Data in RazorSQL
Connect to Mistral AI from wizards and query Mistral AI from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for Suadeo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Suadeo.
-
Build Teradata-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Teradata to explore live Teradata Data in GitHub Copilot to assist with building Teradata-powered applications.
-
Connect to Databricks Data in JRuby
Create a simple JRuby app with access to live Databricks.
-
A PostgreSQL Interface for Pushbullet Data using the CData ODBC Driver
Use the SQL Gateway and Pushbullet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with FTP Servers via CData CLI
Connect FTP Servers to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Object-Relational Mapping (ORM) with FTP 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 FTP Servers into a Java-based ORM framework, Hibernate.
-
Establish a Live Connection with Clari Data using Tableau Bridge
The CData ODBC Driver for Clari enables you to integrate live Clari into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Neo4J Data in Jaspersoft Studio
Execute SQL to remote Neo4J in Jaspersoft Studio.
-
Excel Spreadsheet Automation on Cosmos DB Data with the QUERY Formula
Pull data from Cosmos DB, automate spreadsheets, and more with the QUERY formula.
-
Write a Simple Go Application to work with Missive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Missive.
-
Build Salesforce Marketing-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Marketing Data from Zoho Analytics and import live Salesforce Marketing Cloud.
-
Connect to Drip in SpagoBI
Create reports featuring live Drip in SpagoBI Studio. Host Drip reports on SpagoBI Server.
-
Automated Continuous Acumatica Replication to MySQL
Use CData Sync for automated, continuous, customizable Acumatica replication to MySQL.
-
Automate Google Calendar Data Replication to SAP HANA
Use CData Sync to customize and automate Google Calendar replication to SAP HANA.
-
Consume Tally OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Tally feeds that reflect any changes in SAP Lumira.
-
Create Zuora-Connected Applications in Appsmith
Connect to Zuora Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zuora.
-
Connect to BigCommerce Data in Jaspersoft Studio
Execute SQL to remote BigCommerce in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Phoenix
Provide connectivity to Apache Phoenix through an SAP BusinessObjects universe.
-
Connect to Avalara AvaTax Data in JRuby
Create a simple JRuby app with access to live Avalara AvaTax.
-
Integrate Live SendPulse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SendPulse to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
LINQ to Auth0 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 Auth0 Data Provider.
-
Use the CData Software ODBC Driver for Adobe Target in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Target in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Target.
-
How to Connect to Live Apollo 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 Apollo for you.
-
Back Up Salesforce Pardot to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Pardot. In this article, we will employ an SSIS workflow to populate a database with Salesforce Pardot data.
-
Migrating data from Zuora to Databricks using CData SSIS Components.
Easily push Zuora to Databricks using the CData SSIS Tasks for Zuora and Databricks.
-
Import Acumatica Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Acumatica Data and provide access to live Acumatica ERP for custom reports in the Power BI Service.
-
How to Visualize Presto 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 Presto in Python.
-
Getting Started with the CData Connect AI Python SDK for Lakebase
Install the CData Connect AI Python SDK to read and write live Lakebase with standard DB-API 2.0 Python code.
-
Visualize Access Data in TIBCO Spotfire through OData
Integrate Microsoft Access into dashboards in TIBCO Spotfire.
-
DataBind Charts to DocuSign Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to DocuSign 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.
-
Query XML Data in DataGrip
Create a Data Source for XML in DataGrip and use SQL to query live XML Files.
-
Automated Continuous Avro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Avro replication to OneLake in Microsoft Fabric.
-
Integrating Codex CLI with Outreach.io 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 Automated Exact Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live Exact Online and build automated workflows in Zapier.
-
Connect to Stripe Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect Shopify Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Shopify data in real time using natural language.
-
How to Visualize Kintone 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 Kintone in Python.
-
DataBind Controls to Zoho Recruit Data in Delphi
DataBind to Zoho Recruit in Delphi with standard data access components and controls.
-
Stream Flowlu Data into Apache Kafka Topics
Access and stream Flowlu in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Teradata Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Teradata and Dataflow to import and use Teradata in Power Apps.
-
Stream Todoist Data into Apache Kafka Topics
Access and stream Todoist in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Blackbaud FE NXT Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Blackbaud FE NXT from Informatica Cloud.
-
Automate Snowflake Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Snowflake from PowerShell? This article demonstrates how to utilize the Snowflake Cmdlets for tasks like connecting to Snowflake, automating operations, downloading data, and more.
-
Getting Started with the CData Python Connector for Drip
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Zuora Data using the CData ODBC Driver
Use the SQL Gateway and Zuora ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Tally Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Tally ERP and integrate live Tally ERP into your Power Automate tasks.
-
Connect to SendPulse from Asprova with CData Software ODBC Driver for SendPulse
This article shows how to connect faster to SendPulse data from Asprova.
-
Integrate Real-Time Access to Twitter Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Twitter Ads in real time.
-
Visualize OpenWeatherMap Data in Tableau
The CData ODBC driver for OpenWeatherMap enables you integrate OpenWeatherMap into Tableau dashboards.
-
How to Access Square Data Using Entity Framework
This article shows how to access Square using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Microsoft Copilot Studio to talk to your Facebook Ads 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 Facebook Ads for you.
-
Query Zoho Creator Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Zoho Creator and perform CRUD operations on Zoho Creator from Node.js.
-
Migrating data from Slack to Snowflake using CData SSIS Components.
Easily push Slack to Snowflake using the CData SSIS Tasks for Slack and Snowflake.
-
Load IBM Informix Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Informix to a database.
-
How to Build an ETL App for FHIR Data in Python with CData Connect AI
Build ETL pipelines that read and write live FHIR in Python with petl and the CData Connect AI Python SDK.
-
Analyze Confluence Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Atlassian Confluence and visualize Atlassian Confluence in SAP Analytics Cloud.
-
Access Live OneNote Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft OneNote from your Excel spreadsheets.
-
Build Dashboards with Vimeo Data in DBxtra
Create dynamic dashboards and perform analytics based on Vimeo in DBxtra.
-
Import and Visualize SAP Concur Data in Power View
Create data visualizations based on SAP Concur in Excel.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Teams within intelligent workflows.
-
Create Data Visualizations in Cognos BI with Salesloft Data
Access Salesloft as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Mailgun Data in Aqua Data Studio
Access Mailgun from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build ADP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ADP.
-
Connect to Trello Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Trello in the Denodo Virtual DataPort Administrator.
-
Use Grok to Talk to Your Greenhouse 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 Greenhouse for you.
-
Integrate with Nuclia Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Nuclia to a JSON file on disk.
-
Access Teamwork Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teamwork from HeidiSQL.
-
Integrate SAP Ariba Procurement Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Ariba Procurement and integrate live SAP Ariba Procurement into your Power Automate tasks.
-
Use Dash to Build Web Apps on SAP HANA Data via CData Connect AI
Build interactive Dash web apps on live SAP HANA using pandas and the CData Connect AI Python SDK.
-
How to publish and share Planio Data dashboards with Tableau Server
The CData ODBC driver for Planio enables you integrate Planio into Tableau dashboards.
-
Build Tally-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Tally Data and create custom apps in Bubble.
-
Natively Connect to Klaviyo Data in PHP
The CData ODBC driver for Klaviyo enables you to create PHP applications with connectivity to Klaviyo. Leverage the native support for ODBC in PHP.
-
Connect to ZohoSubscriptions Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoSubscriptions from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Kiro CLI with Azure Data Lake Storage 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 Oracle SCM Data in AWS Lambda
Connect to live Oracle SCM in AWS Lambda using the CData JDBC Driver.
-
Trigger Microsoft Entra ID IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Entra ID with standard wizards in Logic Apps.