CData Software - Knowledge Base
Recent Articles
-
Connect to Scrapfly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Scrapfly to connect to Scrapfly and execute queries in PowerBuilder.
-
Access Live Sentry Data in AWS Lambda
Connect to live Sentry in AWS Lambda using the CData JDBC Driver.
-
Connect to Amazon DynamoDB Data in RapidMiner
Integrate Amazon DynamoDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with SQL Server Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft SQL Server to a JSON file on disk.
-
Use Azure AI Foundry to Talk to Your Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Okta for you.
-
Connect to OData Services in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for OData Services and connect to OData in Akorbi Digital RunMyProcess.
-
Create Sage Intacct-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sage Intacct Data from Klipfolio and build custom visualizations using live Sage Intacct.
-
Access Delighted Data from MySQL in Amazon QuickSight
Connect to Delighted and build visualizations of Delighted using a MySQL Connection in Amazon QuickSight.
-
Rapidly Develop LinkedIn-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 LinkedIn.
-
Automated Continuous LightSpeedRetail Replication to Snowflake
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Snowflake.
-
Integrate Live SAP Business One Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Business One to Blue Prism using the CData ODBC Driver for SAP Business One to create automated workflows for repetitive business tasks.
-
Prepare, Blend, and Analyze Quickbase Data in Alteryx Designer (Connect AI)
Build workflows to access live Quickbase for self-service data analytics.
-
Replicate Multiple QuickBooks Online Accounts via the CData Sync CLI
Replicate multiple QuickBooks Online accounts to one or many databases.
-
Connect to Amazon DynamoDB 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 Amazon DynamoDB.
-
Build Data Flows from Oracle Service Cloud to SQL Server using SSIS
Easily back up Oracle Service Cloud to SQL Server using the SSIS components for Oracle Service Cloud.
-
Analyze HelloSign Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HelloSign from Power Pivot. You will use the Table Import Wizard to load HelloSign. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build to Web Apps on SuiteCRM Data
Create Python applications that use pandas and Dash to build SuiteCRM-connected web apps.
-
Use the CData Software ODBC Driver for Confluence in MicroStrategy Desktop
Connect to Atlassian Confluence in MicroStrategy Desktop using the CData Software ODBC Driver for Confluence.
-
Getting Started with the CData SSIS Components for Attio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Attio.
-
Access Live Adobe Analytics Data in Excel 365 Online (Excel for the web)
Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
DataBind Hacker News Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Hacker News to a chart.
-
Connect to Demio Data from PowerBuilder via JDBC
This article demonstrates how to access Demio from PowerBuilder using the Demio JDBC Driver.
-
Integrate Live Coda Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Coda to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Microsoft OneDrive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft OneDrive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with LinkedIn Ads Data in ETL Validator JDBC
Connect to LinkedIn Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Establish a Live Connection with Azure Analysis Services Data using Tableau Bridge
The CData ODBC Driver for Azure Analysis Services enables you to integrate live Azure Analysis Services into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting Pipedream with Vertica 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 Vertica data in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for PivotalTracker
Create PivotalTracker data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Zoho Inventory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Inventory and build Zoho Inventory-connected web apps with Axios.
-
Blackbaud FE NXT Reporting in OBIEE with the Blackbaud FE NXT JDBC Driver
Deploy the Blackbaud FE NXT JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating LangGraph with Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Monday.com within automated workflows.
-
Integrate ConstantContact with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConstantContact with External Services.
-
Query Dynamics CRM Data in DataGrip
Create a Data Source for Dynamics CRM in DataGrip and use SQL to query live Microsoft Dynamics CRM.
-
Automated Continuous Facebook Replication to SQL Server
Use CData Sync for automated, continuous, customizable Facebook replication to SQL Server.
-
Explore Geographical Relationships in Contentful Data with Power Map
Create data visualizations with Contentful in Power Map.
-
How to Connect to & Open YouTube Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for YouTube Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build MVC Applications with Connectivity to ServiceNow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ServiceNow from an ASP.NET MVC application.
-
Design BIRT Reports on Google Drive Data
Provide current Google Drive to your embedded analytics.
-
Integrate with IBM Informix Data in JReport Designer
Create charts and reports based on IBM Informix in JReport Designer.
-
Connect to ClickUp Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ClickUp and work with ClickUp in your FileMaker application.
-
Connect to Zoho Projects Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Projects Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Elorus Data in MySQL Workbench
Execute MySQL queries against live Elorus from MySQL Workbench.
-
Use Dash to Build to Web Apps on MessageBird Data
Create Python applications that use pandas and Dash to build MessageBird-connected web apps.
-
Connect to SAS Data Sets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAS Data Sets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Live Egnyte Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Egnyte.
-
Automated Continuous Timely Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Timely replication to Apache Cassandra.
-
Automated Continuous eBay Replication to AlloyDB
Use CData Sync for automated, continuous, customizable eBay replication to AlloyDB.
-
How to Build an ETL App for Impala Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache Impala in Python with petl and the CData Connect AI Python SDK.
-
Build Visualizations of Moosend Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Moosend in Birst.
-
Use the CData Software ODBC Driver for Datadog in MicroStrategy
Connect to Datadog in MicroStrategy Developer using the CData Software ODBC Driver for Datadog.
-
Connect to Chargebee Data in Jaspersoft Studio
Execute SQL to remote Chargebee in Jaspersoft Studio.
-
Replicate Scrapfly Data from PowerShell
Write a quick PowerShell script to query Scrapfly. Use connectivity to the live data to replicate Scrapfly to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Acumatica
Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.
-
Access Live Paylocity Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Paylocity into the statistical analysis tools available in SAS JMP. This article shows how to use Paylocity in the Graph Builder and Query Builder.
-
Integrating GitHub Copilot CLI with Epicor Kinetic 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 Informatica Mappings From/To a JDBC Data Source for Redis
Create Redis data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Charts to SageHR Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SageHR 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.
-
Use Biml to Build SSIS Tasks to Replicate PDFMonkey Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PDFMonkey to SQL Server.
-
Connect Oracle Service Cloud to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Service Cloud with IBM WebSphere for seamless data integration and connectivity.
-
Model, Search, and Visualize Live MariaDB Data in ThoughtSpot
Use CData Connect AI to connect to live MariaDB for modeling, searching, and visualizing.
-
Connect to SQL Server Data in CloverDX (formerly CloverETL)
Transfer Microsoft SQL Server using the visual workflow in the CloverDX data integration tool.
-
Access IBM Cloud Object Storage Data from MySQL in Amazon QuickSight
Connect to IBM Cloud Object Storage and build visualizations of IBM Cloud Object Storage using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for Odoo in MicroStrategy
Connect to Odoo ERP in MicroStrategy Developer using the CData Software ODBC Driver for Odoo.
-
Getting Started with the CData Excel Add-In for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConvertAPI.
-
Automated Continuous Bitbucket Replication to Vertica
Use CData Sync for automated, continuous, customizable Bitbucket replication to Vertica.
-
Automated Continuous Oracle Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle replication to Apache Kafka.
-
Use Microsoft Copilot Studio to talk to your Adobe Commerce 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 Adobe Commerce for you.
-
How to publish and share Productboard Data dashboards with Tableau Server
The CData ODBC driver for Productboard enables you integrate Productboard into Tableau dashboards.
-
Publish Drip-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Drip.
-
Bridge Odoo Connectivity with Apache NiFi
Access and process Odoo ERP in Apache NiFi using the CData JDBC Driver.
-
Connecting Agentforce with Google Analytics 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 Google Analytics for you.
-
How to Connect to Live HCL Domino Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your HCL Domino for you.
-
Model, Search, and Visualize Live SharePoint Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft SharePoint for modeling, searching, and visualizing.
-
Use Manus AI to Talk to Your Google Contacts 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 Google Contacts.
-
How to connect to SQL Server Data from IntelliJ
Integrate connectivity to Microsoft SQL Server with wizards in IntelliJ.
-
Integrate Theia IDE with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Establish a Live Connection with Act-On Data using Tableau Bridge
The CData ODBC Driver for Act-On enables you to integrate live Act-On into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Avalara AvaTax Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avalara AvaTax from your Excel spreadsheets.
-
Visualize Sybase Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Sybase into TIBCO Spotfire.
-
Query TaxJar Data as a MySQL Database in Node.js
Execute MySQL queries against TaxJar from Node.js.
-
Access Live Spotify Data in AWS Lambda
Connect to live Spotify in AWS Lambda using the CData JDBC Driver.
-
Import Microsoft Teams Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Teams. In this article, you will use the OData format to import Microsoft Teams into Microsoft Power Query.
-
Work with ChartMogul Data in FoxPro
Load ChartMogul into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Teradata Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teradata replication to IBM DB2.
-
Automated Continuous Salesforce Marketing Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to MongoDB.
-
Build a PostgreSQL Interface for Klaviyo Data using the CData JDBC Driver
Use the Remoting features of the Klaviyo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with Greenhouse via CData CLI
Connect Greenhouse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build LinkedIn Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for LinkedIn Ads Data and create custom apps in Mendix.
-
Build Automated Workflows with Live Procore Data in Workato
Use CData Connect AI to connect to live Procore and build automated workflows in Workato.
-
Analyze Confluence Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Atlassian Confluence in Microsoft R Open.
-
Integrate Trello Data in Pentaho Data Integration
Build ETL pipelines based on Trello in the Pentaho Data Integration tool.
-
How to Seamlessly Import ClickUp Data into IBM SPSS Modeler
Integrate ClickUp data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Seamlessly Import ElevenLabs Data into IBM SPSS Modeler
Integrate ElevenLabs data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Instagram 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 Instagram for you.
-
Visualize Autopilot Data in TIBCO Spotfire through ADO.NET
Integrate Autopilot into dashboards in TIBCO Spotfire.
-
Connect to Phoenix Data from a Connection Pool in Jetty
The Phoenix JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Phoenix from Web apps in Jetty.
-
Analyze Bitbucket Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitbucket from Power Pivot. You will use the Table Import Wizard to load Bitbucket. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Rebilly Data in Aqua Data Studio
Access Rebilly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Attio in SpagoBI
Create reports featuring live Attio in SpagoBI Studio. Host Attio reports on SpagoBI Server.
-
DataBind Jira Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Jira with the DevExpress Windows Forms and Web controls to provide Atlassian Jira to a chart.