CData Software - Knowledge Base
Recent Articles
-
Import and Visualize LeadDesk Data in Power View
Create data visualizations based on LeadDesk in Excel.
-
How to Connect to Live Box 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 Box for you.
-
DataBind Controls to PivotalTracker Data in C++Builder
DataBind to PivotalTracker in C++Builder with standard components and controls.
-
Build Anaplan-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Anaplan and build web apps with connectivity to live Anaplan.
-
Automated Continuous Google Search Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Search replication to Google Cloud SQL.
-
Visualize Toggl 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 Toggl into TIBCO Spotfire.
-
Build ZohoDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoDesk.
-
Replicate Multiple AgileCRM Accounts via the CData Sync CLI
Replicate multiple AgileCRM accounts to one or many databases.
-
Manage Apollo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Apollo.
-
Operational Reporting on Samanage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Samanage.
-
Connect to and Visualize Live Phoenix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Phoenix.
-
How to Connect to Live ADP 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 ADP for you.
-
Analyze Live Zuora Data in SAS Viya
Use CData Connect AI to connect to Zuora from SAS Viya and deploy self-service analytics using live Zuora.
-
Extract, Transform, and Load Deel Data in Informatica PowerCenter
Create a simple Workflow for Deel in Informatica PowerCenter.
-
Use the CData API Server to Access EnterpriseDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live EnterpriseDB in the Power Pivot business intelligence tool.
-
Use Microsoft Copilot Studio to talk to your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Bind Live Sage Cloud Accounting Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Cloud Accounting data
-
Integrate AgileCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AgileCRM with External Services.
-
Query ShipStation Data in DataGrip
Create a Data Source for ShipStation in DataGrip and use SQL to query live ShipStation.
-
Connect to Jumpseller Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Jumpseller as an External Source in Dremio.
-
Build Webex-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Webex.
-
Connect to HubSpot Data from PowerBuilder via ADO.NET
This article demonstrates how to access HubSpot from Appeon PowerBuilder using the CData ADO.NET Provider for HubSpot.
-
Build Pipelines with Live MySQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MySQL from Google Cloud Data Fusion, enabling the integration of live MySQL into the building and management of effective data pipelines.
-
Connect to SAP Fieldglass Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Fieldglass Data and connect to SAP Fieldglass in Akorbi Digital RunMyProcess.
-
Integrating Claude Code CLI with SAP Business Warehouse 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.
-
How to Connect IBM Informix Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live IBM Informix data in real time using natural language.
-
DataBind Charts to Oracle Sales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Sales 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.
-
Extract, Transform, and Load EnterpriseDB Data in Informatica PowerCenter
Create a simple Workflow for EnterpriseDB in Informatica PowerCenter.
-
Access Live Sugar CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sugar CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Rapidly Develop Everhour-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 Everhour.
-
Analyze Live Monday.com Data in SAS Viya
Use CData Connect AI to connect to Monday.com from SAS Viya and deploy self-service analytics using live Monday.com.
-
Edit and Search External Xero Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero Data objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby in MicroStrategy Desktop using the CData Software JDBC Driver for Billsby.
-
Integrating OpenCode Terminal with Excel 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.
-
Connect to ConvertAPI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConvertAPI and work with ConvertAPI in your FileMaker applications.
-
Use JayDeBeApi to access Microsoft Planner Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Planner.
-
Import and Visualize JotForm Data in Power View
Create data visualizations based on JotForm in Excel.
-
Replicate QuickBooks Data from PowerShell
Write a quick PowerShell script to query QuickBooks Desktop. Use connectivity to the live data to replicate QuickBooks Desktop to SQL Server.
-
How to Access SpaceX Data Using Entity Framework
This article shows how to access SpaceX using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous PagerDuty Replication to Oracle
Use CData Sync for automated, continuous, customizable PagerDuty replication to Oracle.
-
Integrating Kiro CLI with Amazon Athena 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.
-
Publish Reports with GitLab Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitLab.
-
Access Clio Data from MySQL in PHP
Connect to Clio through the standard MySQL libraries in PHP.
-
How to connect to Cvent Data from IntelliJ
Integrate connectivity to Cvent with wizards in IntelliJ.
-
Automated Continuous IBM Informix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon S3.
-
Configure the CData JDBC Driver for Outreach.io in a Connection Pool in Tomcat
Connect to Outreach.io from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for Accelo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Accelo.
-
Build Apps with Live Google Contacts Data Using the Low-Code Development Platform of Mendix
Connect Google Contacts with Mendix to build apps using the CData JDBC Driver for Google Contacts.
-
Access Live Exact Online Data in AWS Lambda
Connect to live Exact Online in AWS Lambda using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Simplesat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Simplesat to SQL Server.
-
Connect to Google Directory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Directory using standard SQL.
-
How to connect Amazon QuickSight to Twitter Ads Data
Create a connection to Twitter Ads in CData Connect AI and insert Twitter Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Agents in Relevance AI with Access to Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zuora within intelligent agent workflows.
-
Use ChatGPT to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Freshservice for you.
-
Build CircleCI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CircleCI and build web apps with connectivity to live CircleCI.
-
Object-Relational Mapping (ORM) with HubSpot Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to HubSpot into a Java-based ORM framework, Hibernate.
-
Connect to Pipeliner CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeliner CRM.
-
Query Blackbaud FE NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Blackbaud FE NXT from Node.js.
-
Connect to Salesforce Marketing Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Marketing Cloud.
-
Replicate Sybase Data to Multiple Databases via the CData Sync CLI
Replicate Sybase to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Twitter Ads
Provide connectivity to Twitter Ads through an SAP BusinessObjects universe.
-
Integrate Live Customer.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Customer.io to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Publish Reports with Quickbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Quickbase.
-
A PostgreSQL Interface for MailChimp Data using the CData ODBC Driver
Use the SQL Gateway and MailChimp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Aircall Data in Pentaho Data Integration
Build ETL pipelines based on Aircall in the Pentaho Data Integration tool.
-
Connect to Microsoft Teams Data in Aqua Data Studio
Access Microsoft Teams from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Confluence 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 Atlassian Confluence through MCP integration.
-
Integrate Live Zoho Inventory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Inventory and integrate live Zoho Inventory into apps built in Microsoft Power Apps.
-
Publish Crystal Reports on CouchDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache CouchDB.
-
Connect to Jira Data in NetBeans
Connect to Atlassian Jira in NetBeans with the data source configuration wizard.
-
Build MVC Applications with Connectivity to LDAP Objects
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LDAP from an ASP.NET MVC application.
-
Operational Reporting on Grafana Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Grafana.
-
Getting Started with the CData SSIS Components for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CapsuleCRM.
-
Integrate Live Google Contacts Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Contacts to Blue Prism using the CData ODBC Driver for Google Contacts to create automated workflows for repetitive business tasks.
-
How to Create Power BI Visual Reports with Real-Time Billsby Data
Use CData Power BI Connectors to visualize Billsby in Power BI.
-
Query Contentful Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Contentful and perform CRUD operations on Contentful from Node.js.
-
Copper Reporting in OBIEE with the Copper JDBC Driver
Deploy the Copper JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Drip 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 Drip into TIBCO Spotfire.
-
LINQ to Accelo 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 Accelo Data Provider.
-
Create Outreach.io-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Outreach.io Data from OutSystems and build custom enterprise apps using live Outreach.io.
-
Visualize Telegram Data in Tableau
The CData ODBC driver for Telegram enables you integrate Telegram into Tableau dashboards.
-
Use JayDeBeApi to access Close Data in Python
Use standard Python scripting and the development environment of your choice to access live Close.
-
Visualize Office 365 Data in TIBCO Spotfire through OData
Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.
-
Build REST-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in GitHub Copilot to assist with building REST-powered applications.
-
Automated Continuous Front Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Front replication to Amazon S3.
-
DataBind Controls to Salesforce Pardot Data in Delphi
DataBind to Salesforce Pardot in Delphi with standard data access components and controls.
-
Configure the CData JDBC Driver for Brex in a Connection Pool in Tomcat
Connect to Brex from a connection pool in Tomcat.
-
How to Access Live SparkPost Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SparkPost enables you to integrate SparkPost into workflows built using Microsoft Power Automate Desktop.
-
Use JayDeBeApi to access Pinecone Data in Python
Use standard Python scripting and the development environment of your choice to access live Pinecone.
-
Easily Integrate Adobe Target Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Target in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Teamgate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teamgate using standard SQL.
-
How to create Oracle HCM Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle HCM Cloud in MySQL .
-
How to Work with Planio Data in AWS Glue Jobs Using JDBC
Connect to Planio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Apps with Live Hugging Face Data Using the Low-Code Development Platform of Mendix
Connect Hugging Face with Mendix to build apps using the CData API Driver for JDBC.
-
Build Semantic Layer Views for Mistral AI Data in APOS Live Data Gateway
Use the CData Connector for Mistral AI in APOS Live Data Gateway to build Semantic Layer Views for Mistral AI.
-
Access Live Oracle Data in Coginiti Pro
Connect to and query live Oracle Database from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Extend Google Sheets with ShipEngine Data
Make calls to ShipEngine from Google Apps Script via the API Server.
-
How to connect to Invoiced Data in DBVisualizer
Integrate Invoiced with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
Publish MarkLogic-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MarkLogic.