CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Twilio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Twilio and Dataflow to import and use Twilio data in Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for ServiceDesk Plus
Create an ODBC connection to ServiceDesk Plus in Informatica and browse and transfer ServiceDesk Plus data.
-
DataBind Invoiced Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Invoiced data to a chart.
-
Connect to QuickBooks Time Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for QuickBooks Time data in Airbyte.
-
Query Oracle Sales Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Sales data from Node.js.
-
Query Live Egnyte 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 Egnyte data directly from the development environment.
-
Build MVC Applications with Connectivity to Printful Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printful from an ASP.NET MVC application.
-
Prepare, Blend, and Analyze Missive Data in Alteryx Designer (ODBC)
Build workflows to access live Missive data for self-service data analytics.
-
Integrating Boomi Agentstudio with Redshift Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Redshift data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Highrise Data from HeidiSQL
Use CData Connect AI to connect to and query live Highrise data from HeidiSQL.
-
Choosing the Best Method to Connect Dynamics 365 Business Central to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dynamics 365 Business Central data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
View Reports on Real-Time Zoho CRM Data in Power BI Report Server
Use the CData ODBC Driver for Zoho CRM to visualize Zoho CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
Search External Perplexity Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Perplexity data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Perplexity Data objects that you can access from apps and the dashboard.
-
Access Live Acumatica 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 Acumatica data through MCP integration.
-
Integrate Sage Cloud Accounting Data in Pentaho Data Integration
Build ETL pipelines based on Sage Cloud Accounting data in the Pentaho Data Integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Power BI XMLA
Provide connectivity to Power BI XMLA data through an SAP BusinessObjects universe.
-
Visualize Bugsnag Data in Sisense
Create an ElastiCube in Sisense app with access to Bugsnag data.
-
Integrate Clockify Data in Pentaho Data Integration
Build ETL pipelines based on Clockify data in the Pentaho Data Integration tool.
-
How to Query Live Google Cloud Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Cloud Storage data data in natural language using Python.
-
Use Databricks Agent Bricks to Talk to Your Microsoft OneDrive Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft OneDrive data for you.
-
Integrating Claude Code CLI with Sentry 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 Rebilly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Rebilly data from PowerShell? This article demonstrates how to utilize the Rebilly Cmdlets for tasks like connecting to Rebilly data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy
Connect to Stripe data in MicroStrategy Developer using the CData Software JDBC Driver for Stripe.
-
Build Dashboards with Invoiced Data in Dundas BI
Create dynamic dashboards and perform analytics based on Invoiced data in Dundas BI.
-
Integrating LangGraph with LDAP Objects via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LDAP objects within automated workflows.
-
Getting Started with the CData ODBC Driver for Humanity
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Humanity.
-
Visualize Retently Data in Sisense
Create an ElastiCube in Sisense app with access to Retently data.
-
DataBind SAP Hybris C4C Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Hybris C4C with the DevExpress Windows Forms and Web controls to provide SAP Hybris C4C data to a chart.
-
How to Connect to Live MailChimp 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 MailChimp data for you.
-
Analyze ClickTime Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ClickTime data with the CData JDBC Driver for ClickTime.
-
Analyze Reckon Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reckon from Power Pivot. You will use the Table Import Wizard to load Reckon data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Excel Add-In for Calendly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Calendly.
-
Automated Continuous Salesloft Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesloft replication to MySQL.
-
Connect to Aircall Data in Ruby
Connect to Aircall data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Charts with Stripe Data in Clear Analytics
Create dynamic charts and perform analytics based on Stripe data in Clear Analytics.
-
Create Power BI Reports on Real-Time Microsoft Ads Data
Use the CData ODBC Driver for Microsoft Ads to visualize Microsoft Ads data in Power BI Desktop.
-
Create WooCommerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to WooCommerce Data from Klipfolio and build custom visualizations using live WooCommerce data.
-
Automated Continuous Monday.com Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Monday.com data replication to OneLake in Microsoft Fabric.
-
Integrating Cursor with SQL Analysis 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.
-
Automated Continuous Reckon Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reckon replication to SingleStore.
-
Integrating LangGraph with ConstantContact Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ConstantContact data within automated workflows.
-
Build a Singer.io Tap for Google Spanner With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Spanner data using the CData Python Connector.
-
Create SpaceX Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SpaceX from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Couchbase Data in Pentaho Data Integration
Build ETL pipelines based on Couchbase data in the Pentaho Data Integration tool.
-
ETL Office 365 in Oracle Data Integrator
This article shows how to transfer Office 365 data into a data warehouse using Oracle Data Integrator.
-
How to Build an ETL App for Typeform Data in Python with CData Connect AI
Extract and transform live Typeform data in Python with petl and the CData Connect AI Python SDK.
-
DataBind Controls to Google Tasks Data in C++Builder
DataBind to Google Tasks data in C++Builder with standard components and controls.
-
How to publish and share SingleStore Data dashboards with Tableau Server
The CData ODBC driver for SingleStore enables you integrate SingleStore data into Tableau dashboards.
-
Access Live OData Services in AWS Lambda (with IntelliJ IDEA)
Connect to live OData services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Visualize Everhour Data in Python with pandas
Use pandas and other modules to analyze and visualize live Everhour data in Python.
-
How to Connect the Power BI Service to Cohere: Complete Guide
Connect to the CData Software Power BI Connector for Cohere from PowerBI.com to provide real-time Cohere data across the organization.
-
How to Access Live Azure Synapse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Synapse enables you to integrate Azure Synapse data into workflows built using Microsoft Power Automate Desktop.
-
Bright Data Reporting in OBIEE with the Bright Data JDBC Driver
Deploy the Bright Data JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous NASA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NASA replication to Google BigQuery.
-
Connect to TigerGraph Data from a Connection Pool in JBoss
Integrate TigerGraph data into Java servlets: Use the Management Console in JBoss to install the TigerGraph JDBC Driver.
-
Automated Continuous Exact Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Exact Online replication to Google Cloud SQL.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Fieldglass data.
-
Connect to Aweber Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Aweber data in the Denodo Virtual DataPort Administrator.
-
Integrating Bugsnag Data in Talend Cloud Data Management Platform
Connect Bugsnag Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Visualizations of Codat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Codat data in Birst.
-
Analyze Azure Analysis Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Analysis Services data in Microsoft R Open.
-
How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Create Dashboards and Visualize Live XML Data in Geckoboard
Use CData Connect AI to connect to live XML data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Dashboards with Avro Data in DBxtra
Create dynamic dashboards and perform analytics based on Avro data in DBxtra.
-
Use Microsoft Copilot Studio to talk to your Bitbucket 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 Bitbucket data for you.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Netweaver Gateway data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Netweaver Gateway.
-
Replicate Bitbucket Data to Multiple Databases via the CData Sync CLI
Replicate Bitbucket data to disparate databases with a single configuration.
-
Connect to Google Calendar from Asprova with CData Software ODBC Driver for Google Calendar
This article shows how to connect faster to Google Calendar data from Asprova.
-
Create Sage Intacct-Connected Applications in Appsmith
Connect to Sage Intacct Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage Intacct data.
-
Configuring ODBC Connections in Informatica on Linux
To connect to CData ODBC Drivers from Informatica on Linux, set the Driver Manager for Linux to unixODBC 2.3.x
-
Feed CampaignMonitor Data into FineReport
How to set CampaignMonitor data as a JDBC data source in FineReport.
-
Replicate Freshteam Data from PowerShell
Write a quick PowerShell script to query Freshteam data. Use connectivity to the live data to replicate Freshteam data to SQL Server.
-
Build Data Flows from SQL Server to MySQL through SSIS
Easily push SQL Server data to MySQL using the CData SSIS Tasks for MySQL.
-
Use the CData ODBC Driver for Cosmos DB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cosmos DB to connect to Cosmos DB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cosmos DB data in Excel.
-
Connect to Monday.com Data in NetBeans
Connect to Monday.com data in NetBeans with the data source configuration wizard.
-
Connect to ZeroBounce Data in Ruby
Connect to ZeroBounce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Real-Time Optimizely Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Optimizely data in Power Apps.
-
How to Access Vault CRM Data Using Entity Framework
This article shows how to access Vault CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData SSIS Components for Intercom
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Intercom.
-
Create Apps from Dynamics CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics CRM Data and build apps from live Dynamics CRM data in Qlik Sense Cloud.
-
Establish a Live Connection with Snowflake Data using Tableau Bridge
The CData ODBC Driver for Snowflake enables you to integrate live Snowflake data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Confluence Data in ACL Analytics
Connect to Confluence data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Confluence data.
-
Build MVC Applications with Connectivity to Sage 200 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage 200 from an ASP.NET MVC application.
-
Migrating data from Marketo to Google BigQuery using CData SSIS Components.
Easily push Marketo data to Google BigQuery using the CData SSIS Tasks for Marketo and Google BigQuery.
-
Integrating Gumloop with Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Xero data within automated workflows.
-
Automate Hive Data Replication to Azure Data Lake
Use CData Sync to customize and automate Hive data replication to Azure Data Lake.
-
Replicate Multiple NetSuite Accounts via the CData Sync CLI
Replicate multiple NetSuite accounts to one or many databases.
-
Build a Singer.io Tap for Zoho Creator With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Creator data using the CData Python Connector.
-
Connect to HubSpot Data from a Connection Pool in JBoss
Integrate HubSpot data into Java servlets: Use the Management Console in JBoss to install the HubSpot JDBC Driver.
-
Build AI Agents with Microsoft Exchange Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Exchange data through CData Connect AI.
-
How to Build an ETL App for Reckon Data in Python with CData
Create ETL applications and real-time data pipelines for Reckon data in Python with petl.
-
Build Mailgun Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Mailgun data and build visualizations in Tableau.
-
Query Lakebase Data in DataGrip
Create a Data Source for Lakebase in DataGrip and use SQL to query live Lakebase data.
-
Automated Continuous Close Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Close data replication to OneLake in Microsoft Fabric.
-
Connect to Opsgenie Data in DBeaver
Use the CData ODBC Driver to connect to Opsgenie data in DBeaver.
-
Configure the CData JDBC Driver for MariaDB in a Connection Pool in Tomcat
Connect to MariaDB data from a connection pool in Tomcat.
-
Automated Continuous Oracle Sales Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Google Cloud SQL.
-
Create Dynamic Optimizely Grids Using the Infragistics XamDataGrid
Learn how you can connect Optimizely to Infragistics XamDataGrid to build dynamic grids.
-
Build Agents in Relevance AI with Access to Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Business One data within intelligent agent workflows.
-
Connect and Visualize Live Bitly Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Bitly data into the Databricks platform and create visualization dashboards with real-time Bitly data.