CData Software - Knowledge Base
Recent Articles
-
Build Impala-Connected Apps in Choreo
Use CData Connect AI to connect to Impala Data from Choreo and build custom apps using live Apache Impala.
-
Getting Started with the CData ADO.NET Provider for Power BI XMLA
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Power BI XMLA.
-
Integrate Cursor with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Act-On from within the editor.
-
Access Live Egnyte Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Egnyte into the statistical analysis tools available in SAS JMP. This article shows how to use Egnyte in the Graph Builder and Query Builder.
-
Connect Datadog Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Datadog using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting Agentforce with Vertica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Vertica for you.
-
Validate Pipedrive Data with QuerySurge
Access and validate Pipedrive in QuerySurge using the CData JDBC Driver.
-
Integrating Drip Data in Talend Cloud Data Management Platform
Connect Drip Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate Printful Data Replication to SAP HANA
Use CData Sync to customize and automate Printful replication to SAP HANA.
-
How to Access Dropbox Data Using Entity Framework
This article shows how to access Dropbox using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time Rootly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rootly in ColdFusion.
-
Build AI/ML Models with Live xBase Data using Dataiku
Connect xBase Data with Dataiku using the CData JDBC Driver for xBase.
-
Connect to Acumatica from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Acumatica ERP, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Phoenix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Phoenix replication to Azure SQL Database.
-
How to Easily Query Azure DevOps Data in OpenOffice Base
Connect to Azure DevOps data in OpenOffice Base using the CData ODBC Driver for Azure DevOps and generate reports with live data insights.
-
Automated Continuous Act CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Act CRM replication to delimited files (CSV/TSV).
-
Connect to and Query Okta Data in QlikView over ODBC
Create data visualizations with Okta in QlikView.
-
Prepare, Blend, and Analyze Bullhorn CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Bullhorn CRM for self-service data analytics.
-
How to Connect to Live Trello Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Trello for you.
-
Automated Continuous Smartsheet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Smartsheet replication to IBM DB2.
-
Migrating data from Azure Analysis Services to Snowflake using CData SSIS Components.
Easily push Azure Analysis Services to Snowflake using the CData SSIS Tasks for Azure Analysis Services and Snowflake.
-
Automate ChargeOver Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ChargeOver from PowerShell? This article demonstrates how to utilize the ChargeOver Cmdlets for tasks like connecting to ChargeOver, automating operations, downloading data, and more.
-
Build Microsoft Planner-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in Gemini Code Assist to assist with building Microsoft Planner-powered applications.
-
Visualize Wave Financial Data in TIBCO Spotfire through ADO.NET
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Integrating LangGraph with JSON Services via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on JSON within automated workflows.
-
Work with RabbitMQ Data in FoxPro
Load RabbitMQ into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live SAP Ariba Procurement Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Ariba Procurement.
-
Operational Reporting on Mouseflow Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mouseflow.
-
How to Connect to Live Box 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 Box for you.
-
Use Manus AI to Talk to Your Zoho Creator 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 Zoho Creator.
-
Connect to Acumatica Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP and execute queries in PowerBuilder.
-
How to Build an ETL App for DocuSign Data in Python with CData
Create ETL applications and real-time data pipelines for DocuSign in Python with petl.
-
How to connect to ShipStation Data with Squirrel SQL client
Connect to ShipStation and execute queries in the Squirrel SQL Client.
-
Visualize Flowlu Data in Tableau
The CData ODBC driver for Flowlu enables you integrate Flowlu into Tableau dashboards.
-
Create Workday-Connected Business Apps in AppSheet
Connect to Workday Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Workday.
-
Build Microsoft Planner-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Planner Data and create custom apps in Mendix.
-
Publish Crystal Reports on Freshsales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshsales.
-
Connect to Asana Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Asana Data and connect to Asana in Akorbi Digital RunMyProcess.
-
Connect to Freshdesk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk in FileMaker Pro to connect to Freshdesk and work with Freshdesk in your FileMaker applications.
-
How to connect to Google Drive Data from Spring Boot
Connect to Google Drive in a Spring Boot Application using the CData JDBC Driver for Google Drive
-
Visualize Live IBM Informix Data in the Power BI Service
Use CData Connect AI to connect to live IBM Informix and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Manus AI to Talk to Your Facebook 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 Facebook.
-
Integrate Live Monday.com Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Monday.com to Blue Prism using the CData ODBC Driver for Monday.com to create automated workflows for repetitive business tasks.
-
Publish Timely-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Timely.
-
Connect to Pinterest Data in RapidMiner
Integrate Pinterest with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Accelo Data in DBVisualizer
Integrate Accelo with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting and execute queries in PowerBuilder.
-
Connect to Auth0 Data in RazorSQL
Connect to Auth0 from wizards and query Auth0 from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ads
Provide connectivity to Google Ads through an SAP BusinessObjects universe.
-
Integrate with Salesloft Data in JReport Designer
Create charts and reports based on Salesloft in JReport Designer.
-
Integrate with Delighted Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Delighted to a JSON file on disk.
-
Back Up SAP Netweaver Gateway to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Netweaver Gateway. In this article, we will employ an SSIS workflow to populate a database with SAP Netweaver Gateway data.
-
Integrate Close Data in the Pentaho Report Designer
Publish reports based on Close in the Pentaho BI tool.
-
Integrate Jodoo Data in the Pentaho Report Designer
Publish reports based on Jodoo in the Pentaho BI tool.
-
Replicate Teradata Data in Heroku for Use in Salesforce Connect
Replicate Teradata to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Stripe 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 Stripe for you.
-
A PostgreSQL Interface for Mocean Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Asana Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Asana enables you to integrate Asana into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Google Analytics Data in PHP
The CData ODBC driver for Google Analytics enables you to create PHP applications with connectivity to Google Analytics. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (Connect AI)
Build workflows to access live Workday for self-service data analytics.
-
Connect to Tickspot Data in Jaspersoft Studio
Execute SQL to remote Tickspot in Jaspersoft Studio.
-
LinkedIn Ads Reporting in OBIEE with the LinkedIn Ads JDBC Driver
Deploy the LinkedIn Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to publish and share Apollo Data dashboards with Tableau Server
The CData ODBC driver for Apollo enables you integrate Apollo into Tableau dashboards.
-
Import Real-Time Teamwork Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teamwork in ColdFusion.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy
Connect to Lakebase in MicroStrategy Developer using the CData Software ODBC Driver for Lakebase.
-
Integrate Brex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Brex from Informatica Cloud.
-
Getting Started with the CData Connect AI Python SDK for SAP Concur
Install the CData Connect AI Python SDK to read and write live SAP Concur with standard DB-API 2.0 Python code.
-
Analyze iContact Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze iContact in Microsoft R Open.
-
Connect to Live Active Directory Data in MicroStrategy through CData Connect AI
Create a live connection to Active Directory Data in CData Connect AI and connect to your Active Directory from MicroStrategy.
-
Integrate with Greenhouse Data in JReport Designer
Create charts and reports based on Greenhouse in JReport Designer.
-
Automate Rebilly Data Replication to SAP HANA
Use CData Sync to customize and automate Rebilly replication to SAP HANA.
-
Access Live Oracle Data in AWS Lambda
Connect to live Oracle Database in AWS Lambda using the CData JDBC Driver.
-
Back Up Microsoft Teams to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Teams. In this article, we will employ an SSIS workflow to populate a database with Microsoft Teams data.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy
Connect to Mistral AI in MicroStrategy Developer using the CData Software ODBC Driver for Mistral AI.
-
Connect to Slack Data in DBArtisan
Use wizards in DBArtisan to configure Slack as a data source.
-
Build Vertica Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Vertica and build visualizations in Tableau Cloud.
-
Build a Simple VCL Application for Postmark Data
How to build a simple VCL Application to view Postmark in RAD Studio using the CData ODBC Driver for Postmark.
-
Analyze Clio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clio with the CData JDBC Driver for Clio.
-
Use the CData Software ODBC Driver for Cassandra in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Cassandra in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cassandra.
-
Analyze PabblySubscriptions Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PabblySubscriptions from Power Pivot. You will use the Table Import Wizard to load PabblySubscriptions. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData JDBC Driver for Anaplan
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Anaplan.
-
Build Dashboards with ChartMogul Data in DBxtra
Create dynamic dashboards and perform analytics based on ChartMogul in DBxtra.
-
Connect to Pipeline CRM Data in RazorSQL
Connect to Pipeline CRM from wizards and query Pipeline CRM from the GUI in the RazorSQL database management tool.
-
Integrate SQL Analysis Services Data in the Pentaho Report Designer
Publish reports based on SQL Analysis Services in the Pentaho BI tool.
-
Build Semantic Layer Views for SAP Concur Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Concur.
-
Connect to Exa Data in DBArtisan
Use wizards in DBArtisan to configure Exa as a data source.
-
How to Visualize Airtable 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 Airtable in Python.
-
Build Semantic Layer Views for Act-On Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Act-On.
-
Build AI Agents with Reckon Accounts Hosted 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 Reckon Accounts Hosted through CData Connect AI.
-
Use the CData SSIS Components to Insert New or Update Existing Bitbucket Records from SQL Server
Easily push SQL Server data to Bitbucket using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bitbucket or update existing records with data from a SQL Server database.
-
Access Live DocuSign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DocuSign from your Excel spreadsheets.
-
Replicate DocuSign Data to Multiple Databases
Replicate DocuSign to disparate databases with a point-and-click configuration.
-
Connect to Facebook Ads in SpagoBI
Create reports featuring live Facebook Ads in SpagoBI Studio. Host Facebook Ads reports on SpagoBI Server.
-
Connect to Shopify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shopify in the Denodo Virtual DataPort Administrator.
-
Connect to Figshare Data in Aqua Data Studio
Access Figshare from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Edit and Search Zoho CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zoho CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zoho CRM objects that you can access from apps and the dashboard.
-
Build Data Flows from Epicor Kinetic to SQL Server using SSIS
Easily back up Epicor Kinetic to SQL Server using the SSIS components for Epicor Kinetic.
-
Migrating data from Aircall to Databricks using CData SSIS Components.
Easily push Aircall to Databricks using the CData SSIS Tasks for Aircall and Databricks.
-
Natively Connect to WooCommerce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
Connect Oracle Eloqua Reporting to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Eloqua Reporting with IBM WebSphere for seamless data integration and connectivity.