CData Software - Knowledge Base
Recent Articles
-
Automate Salesforce Pardot Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Pardot and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to XML Data in Aqua Data Studio
Access XML Files from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live FHIR Data in AWS Lambda
Connect to live FHIR in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy Web
Connect to Oracle Database in MicroStrategy Web using the CData Software ODBC Driver for Oracle.
-
Automate Pipedrive Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pipedrive replication to Azure Data Lake.
-
Import Real-Time Sugar CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sugar CRM in ColdFusion.
-
Automate Microsoft Dataverse Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to Azure Data Lake.
-
Connect to Codat Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Rapidly Develop NASA-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 NASA.
-
How to update Quickbase from Excel
This article explains how to transfer data from Excel to Quickbase using the Excel Add-In for Quickbase.
-
Connect to Zoho Books from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Books, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Data Flows from Aircall to SQL Server using SSIS
Easily back up Aircall to SQL Server using the SSIS components for Aircall.
-
Connect to PhantomBuster Data from PowerBuilder via JDBC
This article demonstrates how to access PhantomBuster from PowerBuilder using the PhantomBuster JDBC Driver.
-
Analyze Live Amazon Athena Data in SAS Viya
Use CData Connect AI to connect to Amazon Athena from SAS Viya and deploy self-service analytics using live Amazon Athena.
-
LINQ to Microsoft Dataverse 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 Microsoft Dataverse Data Provider.
-
Visualize BigQuery Data in TIBCO Spotfire through OData
Integrate Google BigQuery into dashboards in TIBCO Spotfire.
-
Validate ActiveCampaign Data with QuerySurge
Access and validate ActiveCampaign in QuerySurge using the CData JDBC Driver.
-
Integrate with SAP BusinessObjects BI Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP BusinessObjects BI in SnapLogic.
-
DataBind Charts to Zuora Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zuora 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.
-
Freshsales Reporting in OBIEE with the Freshsales JDBC Driver
Deploy the Freshsales JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Zendesk Data in TIBCO Data Virtualization
Use the Zendesk Tibco DV Adapter to create a Zendesk data source in TIBCO Data Virtualization Studio and gain access to live Zendesk from your TDV Server.
-
Process & Analyze SAP Hybris C4C Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Hybris C4C Data.
-
Visualize RabbitMQ Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to RabbitMQ.
-
Use Dash to Build Web Apps on Azure Table Data via CData Connect AI
Build interactive Dash web apps on live Azure Table Storage using pandas and the CData Connect AI Python SDK.
-
Connecting Pipedream with Cassandra Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Cassandra data in real time.
-
Design BIRT Reports on Teamgate Data
Provide current Teamgate to your embedded analytics.
-
How to create an RPA flow for SAP Business Warehouse Data in UiPath Studio
Use the SAP Business Warehouse ODBC Driver to create workflows that access real-time SAP Business Warehouse without any coding.
-
Build AI/ML Models with Live Perplexity Data using Dataiku
Connect Perplexity Data with Dataiku using the CData API Driver for JDBC.
-
Work with ZohoExpense Data in FoxPro
Load ZohoExpense into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with Apache HBase 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAS xpt
Provide connectivity to SAS XPORT through an SAP BusinessObjects universe.
-
Connect to Codat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Codat to connect to Codat and execute queries in PowerBuilder.
-
Query Contentful Data in DataGrip
Create a Data Source for Contentful in DataGrip and use SQL to query live Contentful.
-
Consume Redis OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Redis feeds that reflect any changes in SAP Lumira.
-
How to integrate Hacker News with Apache Airflow
Access and process Hacker News in Apache Airflow using the CData JDBC Driver.
-
Connect to Azure Analysis Services Data in DBArtisan
Use wizards in DBArtisan to configure Azure Analysis Services as a data source.
-
Build Dashboards with Zoho Creator Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Creator in Dundas BI.
-
Rapidly Develop MailerSend-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 MailerSend.
-
How to Visualize Cassandra Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Cassandra in Python.
-
Getting Started with the CData Tableau Connector for Sybase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sybase.
-
Automated Continuous Google Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Analytics replication to Databricks.
-
How to create Visio diagrams from Greenplum Data
Automatically update Pivotal GreenPlum with the changes you make to Visio master shapes.
-
Process & Analyze Jodoo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Jodoo Data.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy Web
Connect to SAP ERP/NetWeaver in MicroStrategy Web using the CData Software ODBC Driver for SAP.
-
Connecting Moonlit Workflow with Google Cloud Storage 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 Google Cloud Storage in real time.
-
WordPress Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to WordPress through CData Connect AI using different applications and tools.
-
Use Grok to Talk to Your Box 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 Box for you.
-
Connect to Hacker News Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hacker News as an External Source in Dremio.
-
Analyze QuickBooks Online Data in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Online Data from Cognos Analytics and analyze live QuickBooks Online.
-
Visualize Vimeo Data in Tableau
The CData ODBC driver for Vimeo enables you integrate Vimeo into Tableau dashboards.
-
Integrating GitHub Copilot CLI with Veeva Vault & Vault CRM 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.
-
Connect to Act CRM Data in NetBeans
Connect to Act CRM in NetBeans with the data source configuration wizard.
-
Load SpaceX Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SpaceX to a database.
-
How to use SQLAlchemy ORM to access Samanage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Samanage.
-
Access Live Stripe Data in TIBCO Data Virtualization
Use the Stripe Tibco DV Adapter to create a Stripe data source in TIBCO Data Virtualization Studio and gain access to live Stripe from your TDV Server.
-
ETL Google Forms in Oracle Data Integrator
This article shows how to transfer Google Forms into a data warehouse using Oracle Data Integrator.
-
Access Live Salesforce CRM Analytics Data in Excel 365 Online (Excel for the web)
Connect to Salesforce CRM Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SendGrid to Power BI dashboards. Simply drag and drop SendGrid into data visuals on the Power BI canvas.
-
Automated Continuous Excel Replication to SingleStore
Use CData Sync for automated, continuous, customizable Excel replication to SingleStore.
-
Building Dynamic Web Pages with Microsoft Ads Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Ads using the CData API Server.
-
Consume BigCommerce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BigCommerce feeds that reflect any changes in SAP Lumira.
-
Extract, Transform, and Load HubSpot Data in Informatica PowerCenter
Create a simple Workflow for HubSpot in Informatica PowerCenter.
-
Connect to Mode in SpagoBI
Create reports featuring live Mode in SpagoBI Studio. Host Mode reports on SpagoBI Server.
-
Use Biml to Build SSIS Tasks to Replicate Guru Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Guru to SQL Server.
-
Build Apps with Live Nuclia Data Using the Low-Code Development Platform of Mendix
Connect Nuclia with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Controls to Elorus Data in C++Builder
DataBind to Elorus in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time IBM Cloud Object Storage Data
Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop.
-
Build Lakebase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Lakebase to explore live Lakebase Data in Gemini Code Assist to assist with building Lakebase-powered applications.
-
Automated Continuous Copper Replication to MySQL
Use CData Sync for automated, continuous, customizable Copper replication to MySQL.
-
Replicate Multiple Discord Accounts via the CData Sync CLI
Replicate multiple Discord accounts to one or many databases.
-
Configure the CData JDBC Driver for Microsoft Exchange in a Connection Pool in Tomcat
Connect to Microsoft Exchange from a connection pool in Tomcat.
-
How to connect and process FTP Servers from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FTP Servers.
-
Integrate LibreChat with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Instagram from within the chat interface.
-
Connect to MariaDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MariaDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Highrise CRM within intelligent workflows.
-
Query Discord Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Discord from Node.js.
-
Use Dash to Build to Web Apps on Brex Data
Create Python applications that use pandas and Dash to build Brex-connected web apps.
-
Establish a Live Connection with ServiceNow Data using Tableau Bridge
The CData ODBC Driver for ServiceNow enables you to integrate live ServiceNow into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Phoenix Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Phoenix.
-
Excel Spreadsheet Automation on Sybase IQ Data with the QUERY Formula
Pull data from Sybase IQ, automate spreadsheets, and more with the QUERY formula.
-
How to Easily Query Retently Data in OpenOffice Base
Connect to Retently data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to CloudConvert Data in NetBeans
Connect to CloudConvert in NetBeans with the data source configuration wizard.
-
Create Apps from SAP HANA Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP HANA Data and build apps from live SAP HANA in Qlik Sense Cloud.
-
Provide OData Services of Miro Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Miro by developing a WCF Service Application.
-
How to Access Power BI XMLA Data Using Entity Framework
This article shows how to access Power BI XMLA using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for Freshteam
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Codat Data in JRuby
Create a simple JRuby app with access to live Codat.
-
Integrate Theia IDE with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Facebook Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Facebook Ads in FileMaker Pro to connect to Facebook Ads and work with Facebook Ads in your FileMaker applications.
-
Analyze Bitly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bitly in Microsoft R Open.
-
How to connect to QuickBooks Online Data from IntelliJ
Integrate connectivity to QuickBooks Online with wizards in IntelliJ.
-
Connect Jodoo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jodoo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Load Coda Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Coda to a database.
-
Connect to SuiteCRM Data from a Connection Pool in JBoss
Integrate SuiteCRM into Java servlets: Use the Management Console in JBoss to install the SuiteCRM JDBC Driver.
-
Enable the Parallel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Parallel.
-
ETL Miro in Oracle Data Integrator
This article shows how to transfer Miro into a data warehouse using Oracle Data Integrator.
-
Connect to Mouseflow Data in NetBeans
Connect to Mouseflow in NetBeans with the data source configuration wizard.
-
DataBind Jumpseller Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Jumpseller to a chart.
-
Build Semantic Layer Views for SAP Netweaver Gateway Data in APOS Live Data Gateway
Use the CData Connector for SAP Netweaver Gateway in APOS Live Data Gateway to build Semantic Layer Views for SAP Netweaver Gateway.
-
LINQ to MySQL 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 MySQL Data Provider.