CData Software - Knowledge Base
Recent Articles
-
Automate Certinia Data Replication to Azure Synapse
Use CData Sync to customize and automate Certinia data replication to Azure Synapse.
-
Access Live Klipfolio Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klipfolio data from your Excel spreadsheets.
-
How to Build an ETL App for eBay Data in Python with CData Connect AI
Build ETL pipelines that read and write live eBay data in Python with petl and the CData Connect AI Python SDK.
-
Build QuickBooks-Connected Apps in Choreo
Use CData Connect AI to connect to QuickBooks Data from Choreo and build custom apps using live QuickBooks data.
-
Build Apps with Live Greenhouse Data Using the Low-Code Development Platform of Mendix
Connect Greenhouse data with Mendix to build apps using the CData JDBC Driver for Greenhouse.
-
Build Semantic Layer Views for Freshdesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshdesk data.
-
Replicate Sybase Data in Heroku for Use in Salesforce Connect
Replicate Sybase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Controls to Rootly Data in C++Builder
DataBind to Rootly data in C++Builder with standard components and controls.
-
Enable the SFTP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SFTP data.
-
Getting Started with the CData Tableau Connector for Aweber
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Live QuickBooks Online Data in AWS Lambda
Connect to live QuickBooks Online data in AWS Lambda using the CData JDBC Driver.
-
Write a Simple Go Application to work with Azure Analysis Services Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Analysis Services data.
-
Integrate Trae with Live Xero Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Xero data from within the AI-powered IDE.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Web
Connect to Zoho Inventory data in MicroStrategy Web using the CData Software JDBC Driver for Zoho Inventory.
-
How to Query Live LDAP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LDAP objects 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 Dynamics 365 data 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 Dynamics 365 data data.
-
Integrating Cursor 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.
-
Access Live Aweber Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Aweber data from your Excel spreadsheets.
-
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 Parquet data to Apache Solr Enterprise Search platform.
-
Create Supabase-Connected Applications in Appsmith
Connect to Supabase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Supabase data.
-
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 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Data 360 data.
-
Visualize Live Paylocity Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paylocity data 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.
-
Automate Instantly Data Replication to Couchbase
Use CData Sync to Customize and automate Instantly data replication to Couchbase.
-
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 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Acumatica data into the Adalo platform and build custom mobile and web applications with real-time Acumatica data.
-
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 data 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 data 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 data.
-
Publish Crystal Reports on Bitbucket Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bitbucket data.
-
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 data 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 data.
-
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 data 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.
-
Connect to Databricks Data in JRuby
Create a simple JRuby app with access to live Databricks data.
-
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 data via CData CLI
Connect FTP data 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 data into a Java-based ORM framework, Hibernate.
-
Import SFTP Data Using Azure Data Factory
Use CData Connect AI to connect to SFTP Data from Azure Data Factory and import live SFTP data.
-
Establish a Live Connection with Clari Data using Tableau Bridge
The CData ODBC Driver for Clari enables you to integrate live Clari data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Neo4J Data in Jaspersoft Studio
Execute SQL to remote Neo4J data 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 data.
-
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 data.
-
Connect to Drip in SpagoBI
Create reports featuring live Drip data 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 data 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 data.
-
Connect to BigCommerce Data in Jaspersoft Studio
Execute SQL to remote BigCommerce data in Jaspersoft Studio.
-
Automated Continuous ConvertAPI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ConvertAPI replication to AlloyDB.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Phoenix
Provide connectivity to Phoenix data through an SAP BusinessObjects universe.
-
Connect to Avalara AvaTax Data in JRuby
Create a simple JRuby app with access to live Avalara AvaTax data.
-
Integrate Live SendPulse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SendPulse data 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 data 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 data for you.
-
Back Up Salesforce Pardot data 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 data.
-
Migrating data from Zuora to Databricks using CData SSIS Components.
Easily push Zuora data 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 data 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 data 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 data with standard DB-API 2.0 Python code.
-
Visualize Access Data in TIBCO Spotfire through OData
Integrate Access data into dashboards in TIBCO Spotfire.
-
DataBind Charts to DocuSign Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to DocuSign data 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 data.
-
Automated Continuous Avro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avro data replication to OneLake in Microsoft Fabric.
-
Integrating Codex with Outreach.io 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 Automated Exact Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live Exact Online data and build automated workflows in Zapier.
-
Connect to Stripe Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Stripe.
-
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.
-
Automated Continuous Deel Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Deel replication to Google Cloud SQL.
-
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 data in Python.
-
DataBind Controls to Zoho Recruit Data in Delphi
DataBind to Zoho Recruit data in Delphi with standard data access components and controls.
-
Stream Flowlu Data into Apache Kafka Topics
Access and stream Flowlu data 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 data in Power Apps.
-
Stream Todoist Data into Apache Kafka Topics
Access and stream Todoist data 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 data from Informatica Cloud.
-
Automate Snowflake Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Snowflake data from PowerShell? This article demonstrates how to utilize the Snowflake Cmdlets for tasks like connecting to Snowflake data, automating operations, downloading data, and more.
-
Getting Started with the CData Python Connector for Drip
Learn to install and license the CData Python Connector and configure a connection to live Drip data.
-
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 data and integrate live Tally data 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 data in real time.
-
Visualize OpenWeatherMap Data in Tableau
The CData ODBC driver for OpenWeatherMap enables you integrate OpenWeatherMap data into Tableau dashboards.
-
Replicate Multiple Mistral AI Accounts via the CData Sync CLI
Replicate multiple Mistral AI accounts to one or many databases.
-
How to Access Square Data Using Entity Framework
This article shows how to access Square data 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 data for you.
-
Migrating data from Slack to Snowflake using CData SSIS Components.
Easily push Slack data 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 data to a database.
-
Integrate Dify with Live SAP Business Warehouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP Business Warehouse data.
-
How to Build an ETL App for FHIR Data in Python with CData Connect AI
Extract and transform live FHIR data 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 Confluence data and visualize Confluence data in SAP Analytics Cloud.