CData Software - Knowledge Base
Recent Articles
-
Connect to EmailOctopus from Asprova with CData Software ODBC Driver for EmailOctopus
This article shows how to connect faster to EmailOctopus data from Asprova.
-
Create Reports from Twitter Ads Data in Looker Studio
Use CData Connect AI to gain access to live Twitter Ads and create custom reports in Looker Studio.
-
Building Dynamic Web Pages with Zendesk Data Using AngularJS
Create single-page applications with live connectivity to Zendesk using the CData API Server.
-
Build a Simple VCL Application for SAP Data
How to build a simple VCL Application to view SAP ERP/NetWeaver in RAD Studio using the CData ODBC Driver for SAP.
-
How to Work with PolarTeamPro Data in AWS Glue Jobs Using JDBC
Connect to PolarTeamPro from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Tableau Connector for Egnyte
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Gmail Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Gmail for you.
-
Publish SendGrid-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendGrid.
-
Access Live EnterpriseDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to EnterpriseDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to LinkedIn in SpagoBI
Create reports featuring live LinkedIn in SpagoBI Studio. Host LinkedIn reports on SpagoBI Server.
-
Access Live Apollo 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 Apollo through MCP integration.
-
Automated Continuous Humanity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Humanity replication to PostgreSQL.
-
Integrating Kiro CLI with Discourse 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.
-
DataBind Charts to Apollo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apollo 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.
-
Publish Reports with GitHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitHub.
-
How to Connect to Live Avro 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 Apache Avro for you.
-
Integrating LlamaIndex with Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Trello in real time.
-
Use the CData SSIS Components to Insert New or Update Existing MariaDB Records from SQL Server
Easily push SQL Server data to MariaDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MariaDB or update existing records with data from a SQL Server database.
-
Query, Visualize, and Share live eBay Data in Redash
Use CData Connect AI to connect to live eBay in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Sybase Data in Microsoft Excel
This article uses the CData ODBC driver for Sybase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SSAS Tabular Models from Freshservice Data
How to build a SQL Server Analysis Service Tabular Model from Freshservice using CData drivers.
-
Automated Continuous Act CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Act CRM replication to PostgreSQL.
-
Access Live OpenWeatherMap Data in Coginiti Pro
Connect to and query live OpenWeatherMap from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Instagram Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Instagram from your Excel spreadsheets.
-
Integrating Dataiku with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Shopify.
-
Integrating Gumloop with Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on IBM Cloudant within automated workflows.
-
Automated Continuous ShipEngine Replication to SQL Server
Use CData Sync for automated, continuous, customizable ShipEngine replication to SQL Server.
-
ScrapingBee Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ScrapingBee facts in real time.
-
Design BIRT Reports on HBase Data
Provide current Apache HBase to your embedded analytics.
-
Connect to Oracle Data in HULFT Integrate
Connect to Oracle as a JDBC data source in HULFT Integrate
-
Integrate with Live Oracle Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle from the MuleSoft Anypoint Platform to integrate live Oracle Database into custom reports and dashboards.
-
Explore Geographical Relationships in Microsoft Exchange Data with Power Map
Create data visualizations with Microsoft Exchange in Power Map.
-
Connect to Xero Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Xero Accounting from Filemaker Pro on Mac.
-
Choosing the Best Method to Connect Email to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Email from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MVC Applications with Connectivity to MarkLogic Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MarkLogic from an ASP.NET MVC application.
-
Connect to Google Campaign Manager 360 Data in JRuby
Create a simple JRuby app with access to live Google Campaign Manager 360.
-
Connect to Asana Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Asana.
-
Connect to Live Oracle Financials Cloud Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Financials Cloud in CData Connect AI and connect to your Oracle Financials Cloud from PostgreSQL.
-
How to work with CapsuleCRM Data in Apache Spark using SQL
Access and process CapsuleCRM Data in Apache Spark using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Bullhorn CRM Data
How to build a SQL Server Analysis Service Tabular Model from Bullhorn CRM using CData drivers.
-
Getting Started with the CData SSIS Components for Airtable
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Airtable.
-
How to Work with ShipEngine Data in ETL Validator JDBC
Connect to ShipEngine from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for EmailOctopus in MicroStrategy
Connect to EmailOctopus in MicroStrategy Developer using the CData Software JDBC Driver for EmailOctopus.
-
Access SAS Data Sets Data from MySQL in PHP
Connect to SAS Data Sets through the standard MySQL libraries in PHP.
-
Use Biml to Build SSIS Tasks to Replicate Parquet Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Parquet to SQL Server.
-
Integrating Cursor CLI with DocuSign 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.
-
Creating Monday.com-Connected Applications in Unqork
You can use CData Connect AI to feed Monday.com to Unqork and build custom business apps.
-
Visualize Live SingleStore Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SingleStore into custom reports in Power BI.
-
Connect to Oracle Service Cloud Data in Ruby
Connect to Oracle Service Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Pipeline CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pipeline CRM.
-
Design BIRT Reports on Azure Data Catalog Data
Provide current Azure Data Catalog to your embedded analytics.
-
Access Live PostgreSQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PostgreSQL from your Google Sheets.
-
How to Use a Microsoft Access Database to Update MySQL Data in Real Time
Update MySQL data by creating a linked table in Microsoft Access with the CData MySQL ODBC Driver.
-
Visualize Reply.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reply.io.
-
Natively Connect to Azure DevOps Data in PHP
The CData ODBC driver for Azure DevOps enables you to create PHP applications with connectivity to Azure DevOps. Leverage the native support for ODBC in PHP.
-
How to integrate Bannerbear with Apache Airflow
Access and process Bannerbear in Apache Airflow using the CData JDBC Driver.
-
Azure Synapse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Synapse facts in real time.
-
Create Dynamic ConstantContact Grids Using the Infragistics XamDataGrid
Learn how you can connect ConstantContact to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate ZohoExpense with Apache Airflow
Access and process ZohoExpense in Apache Airflow using the CData JDBC Driver.
-
Back Up Epicor Kinetic to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Epicor Kinetic. In this article, we will employ an SSIS workflow to populate a database with Epicor Kinetic data.
-
Import ActiveCampaign Data Using Azure Data Factory
Use CData Connect AI to connect to ActiveCampaign Data from Azure Data Factory and import live ActiveCampaign.
-
Seamlessly Bring Azure Data Lake Storage Data into Retool Using CData Connect AI
Integrate Azure Data Lake Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Zuora from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zuora to connect to Zuora from Web applications running on WebLogic.
-
Access ActiveCampaign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ActiveCampaign from your Oracle system.
-
DataBind Controls to CircleCI Data in C++Builder
DataBind to CircleCI in C++Builder with standard components and controls.
-
Connect Slack Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Slack using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Pipedrive Data Using Azure Data Factory
Use CData Connect AI to connect to Pipedrive Data from Azure Data Factory and import live Pipedrive.
-
Establish a Live Connection with MailerSend Data using Tableau Bridge
The CData ODBC Driver for MailerSend enables you to integrate live MailerSend into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Live SAP Concur Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Concur enables you to integrate SAP Concur into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for Confluence Data in APOS Live Data Gateway
Use the CData Connector for Confluence in APOS Live Data Gateway to build Semantic Layer Views for Atlassian Confluence.
-
Use CData Connect AI to Access Reckon Accounts Hosted Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Reckon Accounts Hosted in the Power Pivot business intelligence tool.
-
Integrate Bannerbear with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bannerbear with External Services.
-
Process & Analyze Invoiced Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Invoiced Data.
-
Viewing SendInBlue Data in RAD Studio Data Explorer
How to view SendInBlue in RAD Studio Data Explorer using the CData ODBC Driver for SendInBlue.
-
How to Connect to & Open IBM Informix Data in Microsoft Excel
This article uses the CData ODBC driver for IBM Informix to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Google Sheets Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Sheets replication to MySQL.
-
Integrate Wrike with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wrike with External Services.
-
Use Claude to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Dynamics CRM for you.
-
Connecting Moonlit Workflow with Elasticsearch 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 Elasticsearch in real time.
-
How to Visualize Act-On Data in Python with pandas
Use pandas and other modules to analyze and visualize live Act-On in Python.
-
Integrate SpaceX Data in the Pentaho Report Designer
Publish reports based on SpaceX in the Pentaho BI tool.
-
Build HubSpot-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to HubSpot Data from Zoho Analytics and import live HubSpot.
-
Connect to MailChimp Data in RapidMiner
Integrate MailChimp with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Authorize.Net Data from PowerBuilder via JDBC
This article demonstrates how to access Authorize.Net from PowerBuilder using the Authorize.Net JDBC Driver.
-
Integrate LibreChat with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Smartsheet from within the chat interface.
-
Connect to Real-Time MessageBird Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use MessageBird in Power Apps.
-
Build an OLAP Cube in SSAS from MailerLite Data
Establish a connection to MailerLite data from SQL Server Analysis Services, and use the MailerLite Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Azure Synapse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Synapse and build Azure Synapse-connected web apps with Axios.
-
Import Real-Time Templated Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Templated in ColdFusion.
-
Query OData Services as a SQL Server Database in Node.js
Execute SQL Server queries against OData from Node.js.
-
Integrate Real-Time Access to Oracle Eloqua in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Eloqua in real time.
-
Integrate LibreChat with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live DocuSign from within the chat interface.
-
Excel Spreadsheet Automation on SAP Ariba Procurement Data with the QUERY Formula
Pull data from SAP Ariba Procurement, automate spreadsheets, and more with the QUERY formula.
-
Connect to Cloudflare Data from PowerBuilder via JDBC
This article demonstrates how to access Cloudflare from PowerBuilder using the Cloudflare JDBC Driver.
-
LINQ to ZohoSubscriptions 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 ZohoSubscriptions Data Provider.
-
How to Access ActiveCampaign Data Using Entity Framework
This article shows how to access ActiveCampaign using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Datadog Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Datadog using standard SQL.
-
Create Data Visualizations in Cognos BI with WordPress Data
Access WordPress as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze WordPress Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of WordPress and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Facebook Ads 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 Facebook Ads through MCP integration.