CData Software - Knowledge Base
Recent Articles
-
Query Exact Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Exact Online.
-
Replicate Multiple Zoho Projects Accounts
Replicate multiple Zoho Projects accounts to one or many databases.
-
Import Dynamics 365 Business Central Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Dynamics 365 Business Central. In this article, you will use the OData format to import Dynamics 365 Business Central into Microsoft Power Query.
-
Connect to Tally Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Tally Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous NetSuite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite replication to Azure SQL Database.
-
Visualize Aha! Data in TIBCO Spotfire through ADO.NET
Integrate Aha! into dashboards in TIBCO Spotfire.
-
How to Easily Query Teamgate Data in OpenOffice Base
Connect to Teamgate data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Smartsheet-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Smartsheet Data from OutSystems and build custom enterprise apps using live Smartsheet.
-
How to Connect Flowise AI Agents to Live Microsoft Entra ID Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Entra ID without replication.
-
Automated Continuous Excel Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel Online replication to AlloyDB.
-
Back Up Auth0 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 Auth0 data.
-
Access SendPulse Data from MySQL in Amazon QuickSight
Connect to SendPulse and build visualizations of SendPulse using a MySQL Connection in Amazon QuickSight.
-
How to work with Zoho Recruit Data in Apache Spark using SQL
Access and process Zoho Recruit Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize AgileCRM Data in Tableau
The CData ODBC driver for AgileCRM enables you integrate AgileCRM into Tableau dashboards.
-
How to import Sentry Data into Apache Solr
Use the CData Software JDBC Driver for Sentry in Data Import Handler and create an automated import of Sentry to Apache Solr Enterprise Search platform.
-
Integrating Antigravity CLI with SAP Concur via CData CLI
Connect SAP Concur to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Using the CData Software ODBC Driver for Salesforce CRM Analytics in PyCharm
Connect to Salesforce CRM Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Replicate Multiple Sage Intacct Accounts via the CData Sync CLI
Replicate multiple Sage Intacct accounts to one or many databases.
-
Use the CData ODBC Driver for Workable in Microsoft Power Query
You can use the CData Workable ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Workable into Microsoft Power Query.
-
How to Connect to Live OData Services 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 OData through natural language.
-
Publish Reports with Dynamics CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics CRM.
-
Query Google Campaign Manager 360 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Campaign Manager 360 from Node.js.
-
Use the CData Software ODBC Driver for Hugging Face in MicroStrategy Desktop
Connect to Hugging Face in MicroStrategy Desktop using the CData Software ODBC Driver for Hugging Face.
-
How to connect SharePoint with IBM Informix Data through external lists
Provide IBM Informix to SharePoint users as an external list.
-
Automated Continuous Adobe Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Amazon Redshift.
-
Use the CData ODBC Driver for Zoho Creator from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Creator in Excel.
-
Automated Continuous ConvertKit Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ConvertKit replication to Apache Kafka.
-
Automate Azure Blob Storage Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Blob Storage replication to Couchbase.
-
How to Connect to Live Google Spanner Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Spanner for you.
-
How to integrate Metabase with Office 365 Data
Use CData Connect AI to connect to live Microsoft Office 365 and create an interactive dashboard in Metabase from Microsoft Office 365.
-
Connect to GraphQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GraphQL from Filemaker Pro on Mac.
-
Create Apps from Vertica Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vertica Data and build apps from live Vertica in Qlik Sense Cloud.
-
Automated Continuous Blackbaud FE NXT Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to OneLake in Microsoft Fabric.
-
Automated Continuous Zoho Projects Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Google Cloud SQL.
-
Integrating Antigravity CLI with Salesloft via CData CLI
Connect Salesloft to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Migrating data from Tally to Snowflake using CData SSIS Components.
Easily push Tally ERP to Snowflake using the CData SSIS Tasks for Tally and Snowflake.
-
How to Access CSV Data Using Entity Framework
This article shows how to access CSV/TSV Files using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to LinkedIn Ads Data in RazorSQL
Connect to LinkedIn Ads from wizards and query LinkedIn Ads from the GUI in the RazorSQL database management tool.
-
Automated Continuous LightSpeedRetail Replication to SQL Server
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to SQL Server.
-
Connect to Dynamics CRM Data in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics CRM.
-
Build Automated Stripe-Connected Workflows in Zapier
Use CData Connect AI to connect to live Stripe and build automated workflows in Zapier.
-
Create Dynamic ZeroBounce Grids Using the Infragistics XamDataGrid
Learn how you can connect ZeroBounce to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Snapchat Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Voice Agents in ElevenLabs with access to Live Raisers Edge NXT Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Raisers Edge NXT.
-
Connecting Moonlit Workflow with SAP HANA Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP HANA in real time.
-
Integrating Gumloop with Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache Cassandra within automated workflows.
-
How to Connect the Power BI Service to Mailgun: Complete Guide
Connect to the CData Software Power BI Connector for Mailgun from PowerBI.com to provide real-time Mailgun across the organization.
-
Build Flowlu-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Flowlu.
-
Prepare, Blend, and Analyze Elorus Data in Alteryx Designer (ODBC)
Build workflows to access live Elorus for self-service data analytics.
-
Access WordPress Data from MySQL in Amazon QuickSight
Connect to WordPress and build visualizations of WordPress using a MySQL Connection in Amazon QuickSight.
-
Automate Epicor Kinetic Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Epicor Kinetic and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Bright Data Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bright Data using standard SQL.
-
Connect to Real-Time Lakebase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Lakebase and Dataflow to import and use Lakebase in Power Apps.
-
Create Exact Online-Connected Applications in Appsmith
Connect to Exact Online Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Exact Online.
-
Connect to BambooHR Data from HeidiSQL
Use CData Connect AI to connect to and query live BambooHR from HeidiSQL.
-
How to Visualize Gong 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 Gong in Python.
-
Automated Continuous AgileCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable AgileCRM replication to Vertica.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy Web
Connect to Apache Phoenix in MicroStrategy Web using the CData Software ODBC Driver for Phoenix.
-
Integrating Codex CLI with Aircall 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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Exchange using the Model Context Protocol.
-
Automate FreshBooks Data Replication to Couchbase
Use CData Sync to Customize and automate FreshBooks replication to Couchbase.
-
Automated Continuous Neo4J Replication to SQLite
Use CData Sync for automated, continuous, customizable Neo4J replication to SQLite.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SageHR
Provide connectivity to SageHR through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to Mouseflow: Complete Guide
Connect to the CData Software Power BI Connector for Mouseflow from PowerBI.com to provide real-time Mouseflow across the organization.
-
How to create RabbitMQ federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for RabbitMQ in MySQL .
-
Configure the CData JDBC Driver for HubDB in a Connection Pool in Tomcat
Connect to HubDB from a connection pool in Tomcat.
-
Stream Oracle Financials Cloud Data into Apache Kafka Topics
Access and stream Oracle Financials Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect and process FormSite from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FormSite.
-
Access Live Okta Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Okta in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Power BI Reports on Real-Time Acumatica Data
Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop.
-
Integrate with live Microsoft OneDrive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft OneDrive in Jitterbit.
-
Connect to Real-Time YouTube Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for YouTube Analytics and Dataflow to import and use YouTube Analytics in Power Apps.
-
Access Live CouchDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live CouchDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Pipeline CRM Data in RapidMiner
Integrate Pipeline CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Build an ETL App for Azure Table Data in Python with CData Connect AI
Build ETL pipelines that read and write live Azure Table Storage in Python with petl and the CData Connect AI Python SDK.
-
Getting Started with the CData JDBC Driver for SAP Concur
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Concur.
-
Integrating Smartsheet Data in Talend Cloud Data Management Platform
Connect Smartsheet Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Smartsheet.
-
Connect to Reckon Data in NetBeans
Connect to Reckon in NetBeans with the data source configuration wizard.
-
Use the CData API Server to Access SAP BusinessObjects BI Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP BusinessObjects BI in the Power Pivot business intelligence tool.
-
Connect to Google Drive Data in RapidMiner
Integrate Google Drive with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Semantic Layer Views for BigCommerce Data in APOS Live Data Gateway
Use the CData Connector for BigCommerce in APOS Live Data Gateway to build Semantic Layer Views for BigCommerce.
-
How to Connect DBeaver to Snapchat Ads via a JDBC Driver
Manage Snapchat Ads with visual tools in DBeaver like the query browser.
-
Analyze MySQL Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MySQL and visualize live MySQL in Infragistics Reveal.
-
Build Dynamics 365 Business Central-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dynamics 365 Business Central.
-
Integrating GitHub Copilot CLI with Oracle Eloqua 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.
-
Perform Batch Operations with Acumatica Data in Apache NiFi
Connect to Acumatica ERP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with Slack 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 Slack into a Java-based ORM framework, Hibernate.
-
Connect to Sage 200 Data in CloverDX (formerly CloverETL)
Transfer Sage 200 using the visual workflow in the CloverDX data integration tool.
-
Query Live Google Ads Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Ads directly from the development environment.
-
Create Amazon S3-Connected Business Apps in AppSheet
Connect to Amazon S3 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon S3.
-
Getting Started with the CData Power BI Connector for FormSite
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate with live Cvent Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cvent in Jitterbit.
-
How to connect to OneNote Data in DBVisualizer
Integrate Microsoft OneNote with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Paylocity using the Model Context Protocol.
-
Establish a Live Connection with Aha! Data using Tableau Bridge
The CData ODBC Driver for Aha! enables you to integrate live Aha! into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Azure Analysis Services Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Analysis Services securely in real time.
-
Import Real-Time Google Sheets Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Sheets in ColdFusion.
-
Automate Qualaroo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Qualaroo from PowerShell? This article demonstrates how to utilize the Qualaroo Cmdlets for tasks like connecting to Qualaroo, automating operations, downloading data, and more.
-
Replicate IBM Informix Data to Multiple Databases
Replicate IBM Informix to disparate databases with a point-and-click configuration.
-
Access Live Dynamics CRM 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 Microsoft Dynamics CRM through MCP integration.