CData Software - Knowledge Base
Recent Articles
-
Visualize Reply.io Data in TIBCO Spotfire through OData
Integrate Reply.io into dashboards in TIBCO Spotfire.
-
Connecting Agentforce with SAP Fieldglass 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 SAP Fieldglass for you.
-
Excel Spreadsheet Automation on Spark Data with the QUERY Formula
Pull data from Spark, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klaviyo
Provide connectivity to Klaviyo through an SAP BusinessObjects universe.
-
Query Zoom Data in DataGrip
Create a Data Source for Zoom in DataGrip and use SQL to query live Zoom.
-
Build a Singer.io Tap for Instagram With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Instagram data using
-
How to connect to Shopify Data in DBVisualizer
Integrate Shopify with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate ZarMoney Data in Heroku for Use in Salesforce Connect
Replicate ZarMoney to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Theia IDE with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to and Visualize Live Google Drive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Drive.
-
Analyze Mode Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Mode and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations in Cognos BI with Google Directory Data
Access Google Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Visualizations of Timely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Timely in Birst.
-
Automate Tanda Data Replication to SAP HANA
Use CData Sync to customize and automate Tanda replication to SAP HANA.
-
Work with Live Outreach.io Data in Power Query
Use CData Connect AI to connect to Outreach.io and work with live Outreach.io in Microsoft Power Query.
-
Query, Visualize, and Share live ShipStation Data in Redash
Use CData Connect AI to connect to live ShipStation in Redash for querying, visualizing, and sharing.
-
How to connect to Couchbase Data from Spring Boot
Connect to Couchbase in a Spring Boot Application using the CData JDBC Driver for Couchbase
-
Integrate Cline with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act-On from within your IDE.
-
Bind Live Xero Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Xero data
-
Connect to Highrise Data from PowerBuilder via ADO.NET
This article demonstrates how to access Highrise CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Highrise.
-
Automate Acumatica Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Acumatica ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Create Power BI Visual Reports with Real-Time Ontraport Data
Use CData Power BI Connectors to visualize Ontraport in Power BI.
-
Edit and Search External ShipStation Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ShipStation to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ShipStation Data objects that you can access from apps and the dashboard.
-
Visualize Gong Data in TIBCO Spotfire through ADO.NET
Integrate Gong into dashboards in TIBCO Spotfire.
-
Access Live Active Directory 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 Active Directory through MCP integration.
-
Connect to Amazon DynamoDB Data in JRuby
Create a simple JRuby app with access to live Amazon DynamoDB.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy
Connect to Reckon Accounts Hosted in MicroStrategy Developer using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Extend Google Sheets with Microsoft Teams Data
Make calls to Microsoft Teams from Google Apps Script via the API Server.
-
Connect to Zoom Data in DBeaver
Use the CData ODBC Driver to connect to Zoom in DBeaver.
-
Explore Geographical Relationships in Okta Data with Power Map
Create data visualizations with Okta in Power Map.
-
DataBind Controls to Toggl Data in C++Builder
DataBind to Toggl in C++Builder with standard components and controls.
-
Add WooCommerce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WooCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Facebook Ads Data into Power Automate Desktop using CData Connect
CData Connect for Facebook Ads Data enables you to integrate Facebook Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho CRM Data in DBeaver
Use the CData ODBC Driver to connect to Zoho CRM in DBeaver.
-
Access Live Authorize.Net Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Authorize.Net in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Postmark-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Postmark Data in Cursor to assist with building Postmark-powered applications.
-
Automate Oracle Eloqua Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua replication to Couchbase.
-
How to connect to Aha! Data from Spring Boot
Connect to Aha! in a Spring Boot Application using the CData API Driver for JDBC
-
Read and Modify Google Sheets Directly from Microsoft Access
Learn how to connect Microsoft Access with Google Sheets to read, update, and manage spreadsheet data in real time.
-
Build an OLAP Cube in SSAS from IBM Cloud Object Storage Data
Establish a connection to IBM Cloud Object Storage data from SQL Server Analysis Services, and use the IBM Cloud Object Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to PolarTeamPro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PolarTeamPro to connect to PolarTeamPro and execute queries in PowerBuilder.
-
Integrate Live CouchDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CouchDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache CouchDB.
-
Connect to Placid Data in Aqua Data Studio
Access Placid from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from ConstantContact to Snowflake using CData SSIS Components.
Easily push ConstantContact to Snowflake using the CData SSIS Tasks for ConstantContact and Snowflake.
-
Connect to Oracle Data in CloverDX (formerly CloverETL)
Transfer Oracle Database using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Python Connector for Zoom
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for ServiceNow in SAS for Real-Time Reporting and Analytics
Connect to real-time ServiceNow in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ServiceNow.
-
Create Datasets from Workday in Domo Workbench and Build Visualizations of Workday Data in Domo
Use the CData Software ODBC Driver for Workday to create datasets from Workday in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Codat Data in TIBCO Spotfire through ADO.NET
Integrate Codat into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with ZohoInvoice 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.
-
Use Dash to Build to Web Apps on ZohoSubscriptions Data
Create Python applications that use pandas and Dash to build ZohoSubscriptions-connected web apps.
-
Integrating Antigravity CLI with Apache Phoenix via CData CLI
Connect Apache Phoenix to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Real-Time Access to ClickUp in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ClickUp in real time.
-
Automate Marketo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Marketo from PowerShell? This article demonstrates how to utilize the Marketo Cmdlets for tasks like connecting to Marketo, automating operations, downloading data, and more.
-
How to create an RPA flow for Amplitude Data in UiPath Studio
Use the Amplitude ODBC Driver to create workflows that access real-time Amplitude without any coding.
-
Create Dynamic ConvertKit Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertKit to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Tableau Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for CouchDB.
-
Build Dashboards with Pushbullet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pushbullet in Dundas BI.
-
Analyze Shopify Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Shopify and visualize live Shopify in Infragistics Reveal.
-
Connect to SAP ByDesign Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business ByDesign in Google Apps Script.
-
Connect to and Visualize Live IBM Informix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM Informix.
-
Access Live Azure Synapse 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 Azure Synapse through MCP integration.
-
Connect to Parallel Data from a Connection Pool in Jetty
The Parallel JDBC Driver supports connection pooling: This article shows how to connect faster to Parallel from Web apps in Jetty.
-
Use Claude to Talk to Your eCommerce Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eCommerce data for you.
-
Use Biml to Build SSIS Tasks to Replicate Redshift Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Redshift to SQL Server.
-
Build Dashboards with Sybase Data in DBxtra
Create dynamic dashboards and perform analytics based on Sybase in DBxtra.
-
Build MVC Applications with Connectivity to BigCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigCommerce from an ASP.NET MVC application.
-
How to connect to Webex Data with Squirrel SQL client
Connect to Webex and execute queries in the Squirrel SQL Client.
-
Automated Continuous Optimizely Replication to Databricks
Use CData Sync for automated, continuous, customizable Optimizely replication to Databricks.
-
Connect to Live Azure Data Lake Storage Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Data Lake Storage Data in CData Connect AI and connect to your Azure Data Lake Storage from MicroStrategy.
-
Establish a Live Connection with Oracle Financials Cloud Data using Tableau Bridge
The CData ODBC Driver for Oracle Financials Cloud enables you to integrate live Oracle Financials Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Migrating data from FTP to Google BigQuery using CData SSIS Components.
Easily push FTP Servers to Google BigQuery using the CData SSIS Tasks for FTP and Google BigQuery.
-
Getting Started with the CData Tableau Connector for Onfleet
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Build an ETL App for MailerLite Data in Python with CData
Create ETL applications and real-time data pipelines for MailerLite in Python with petl.
-
How to Work with Raisers Edge NXT Data in AWS Glue Jobs Using JDBC
Connect to Raisers Edge NXT from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Extend Google Sheets with Auth0 Data
Make calls to Auth0 from Google Apps Script via the API Server.
-
Integrate Live Square Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Pipedrive Data in RazorSQL
Connect to Pipedrive from wizards and query Pipedrive from the GUI in the RazorSQL database management tool.
-
Connect to Slack Data in HULFT Integrate
Connect to Slack as a JDBC data source in HULFT Integrate
-
Use Azure AI Foundry to Talk to Your Azure DevOps 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 Azure DevOps for you.
-
How to Access Couchbase Data Using Entity Framework
This article shows how to access Couchbase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Multiple Oracle Eloqua Reporting Accounts
Replicate multiple Oracle Eloqua Reporting accounts to one or many databases.
-
Work with Zoho Projects Data in FoxPro
Load Zoho Projects into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Freshsales in SpagoBI
Create reports featuring live Freshsales in SpagoBI Studio. Host Freshsales reports on SpagoBI Server.
-
Create Apps from Google Drive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Drive Data and build apps from live Google Drive in Qlik Sense Cloud.
-
How to import PDFMonkey Data into Apache Solr
Use the CData Software JDBC Driver for PDFMonkey in Data Import Handler and create an automated import of PDFMonkey to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Factorial Data in Microsoft Excel
This article uses the CData ODBC driver for Factorial to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a PostgreSQL Interface for Freshteam Data using the CData JDBC Driver
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Google Translate Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Translate 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.
-
Build Pipelines with Live Salesforce Pardot Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Pardot from Google Cloud Data Fusion, enabling the integration of live Salesforce Pardot into the building and management of effective data pipelines.
-
Create Informatica Mappings From/To a JDBC Data Source for DB2
Create DB2 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate with SAP Fieldglass Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Fieldglass in SnapLogic.
-
Connect/Disconnect the QuickBooks Online Products
In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.
-
Access Live Stack Exchange Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Stack Exchange data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating OpenCode Terminal with Microsoft OneDrive 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.
-
Working with HCL Domino Data in LINQPad
Execute LINQ queries to HCL Domino in LINQPad.
-
Connect to Outlook Data from a Connection Pool in JBoss
Integrate Outlook into Java servlets: Use the Management Console in JBoss to install the Outlook JDBC Driver.
-
Query GitHub Data in DataGrip
Create a Data Source for GitHub in DataGrip and use SQL to query live GitHub.
-
Build Oracle-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Database and build Oracle-connected web apps with Axios.
-
Query Bitly Data in ColdFusion
Write standard ColdFusion data access code to connect to Bitly.