CData Software - Knowledge Base
Recent Articles
-
Integrate Clari with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Clari with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Clari data.
-
How to Access Clockify Data Using Entity Framework
This article shows how to access Clockify data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access WordPress Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access WordPress data from your Oracle system.
-
Automated Continuous Campaigner Replication to Databricks
Use CData Sync for automated, continuous, customizable Campaigner replication to Databricks.
-
Replicate Raisers Edge NXT Data in Heroku for Use in Salesforce Connect
Replicate Raisers Edge NXT data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Google Campaign Manager 360 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Campaign Manager 360 data.
-
Build Visualizations of Reply.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Reply.io data in Birst.
-
Connect to Instagram Data in JRuby
Create a simple JRuby app with access to live Instagram data.
-
Back Up Oracle Financials Cloud data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Financials Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle Financials Cloud data data.
-
Create Hive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Hive Data from Klipfolio and build custom visualizations using live Hive data.
-
Bidirectional Access to ADP Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ADP data in Filemaker Pro for Mac or Windows.
-
How to Build an ETL App for MailChimp Data in Python with CData Connect AI
Build ETL pipelines that read and write live MailChimp data in Python with petl and the CData Connect AI Python SDK.
-
Query AgileCRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against AgileCRM data from Node.js.
-
Connect IBM Informix to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect IBM Informix with IBM WebSphere for seamless data integration and connectivity.
-
Import and Visualize AgileCRM Data in Power View
Create data visualizations based on AgileCRM data in Excel.
-
Create Reports with Google Directory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Directory data.
-
Use the CData Software ODBC Driver for NetSuite in MicroStrategy Web
Connect to NetSuite data in MicroStrategy Web using the CData Software ODBC Driver for NetSuite.
-
Replicate Multiple Notion Accounts via the CData Sync CLI
Replicate multiple Notion accounts to one or many databases.
-
Create Power BI Reports on Real-Time MailChimp Data
Use the CData ODBC Driver for MailChimp to visualize MailChimp data in Power BI Desktop.
-
Use Microsoft Copilot Studio to talk to your Elasticsearch 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 Elasticsearch data for you.
-
Analyze Live Amazon S3 Data in SAS Viya
Use CData Connect AI to connect to Amazon S3 data from SAS Viya and deploy self-service analytics using live Amazon S3 data.
-
Connect to Reckon Accounts Hosted Data in HULFT Integrate
Connect to Reckon Accounts Hosted as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy Web
Connect to BenchmarkEmail data in MicroStrategy Web using the CData Software JDBC Driver for BenchmarkEmail.
-
How to Connect the Power BI Service to Sybase IQ: Complete Guide
Connect to the CData Software Power BI Connector for Sybase IQ from PowerBI.com to provide real-time Sybase IQ data across the organization.
-
Connect to Azure Data Lake Storage 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 Azure Data Lake Storage data.
-
Connect to Live Exa Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Exa in CData Connect AI and connect to your Exa data from PostgreSQL.
-
Integrate PagerDuty with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PagerDuty with External Services.
-
Integrate Real-Time Access to SAP ByDesign in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP ByDesign data in real time.
-
Bind Live SAP Ariba Procurement Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Procurement data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build a Simple VCL Application for Freshsales Data
How to build a simple VCL Application to view Freshsales data in RAD Studio using the CData ODBC Driver for Freshsales.
-
Establish a Live Connection with Kintone Data using Tableau Bridge
The CData ODBC Driver for Kintone enables you to integrate live Kintone data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for Monday.com Data in Python with CData
Create ETL applications and real-time data pipelines for Monday.com data in Python with petl.
-
Getting Started with the CData Connect AI Python SDK for SAP HANA
Install the CData Connect AI Python SDK to read and write live SAP HANA data with standard DB-API 2.0 Python code.
-
Automated Continuous Vertica Replication to Snowflake
Use CData Sync for automated, continuous, customizable Vertica replication to Snowflake.
-
Connect to Google Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Analytics to connect to Google Analytics data and execute queries in PowerBuilder.
-
Using the CData Software ODBC Driver for SAP Concur in PyCharm
Connect to SAP Concur as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Concur.
-
Connect to Splunk Data in Aqua Data Studio
Access Splunk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build JobNimbus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JobNimbus data and build web apps with connectivity to live JobNimbus data.
-
Publish Microsoft Dataverse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dataverse data.
-
Replicate Power BI XMLA Data to Multiple Databases
Replicate Power BI XMLA data to disparate databases with a point-and-click configuration.
-
Connect to ZeroBounce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZeroBounce.
-
Create OnePageCrm Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OnePageCrm from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Act-On 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 Act-On data for you.
-
Visualize Trello 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 Trello data into TIBCO Spotfire.
-
Create SSAS Tabular Models from Jira Assets Data
How to build a SQL Server Analysis Service Tabular Model from Jira Assets data using CData drivers.
-
Replicate SuiteCRM Data in Heroku for Use in Salesforce Connect
Replicate SuiteCRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Interact with Live Wistia Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Wistia data.
-
Connect to Microsoft Exchange Data in JRuby
Create a simple JRuby app with access to live Microsoft Exchange data.
-
Build a PostgreSQL Interface for Anaplan Data using the CData JDBC Driver
Use the Remoting features of the Anaplan JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live ConstantContact Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConstantContact data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to LDAP Objects in RapidMiner
Integrate LDAP objects with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Greenplum Data Replication to Teradata
Use CData Sync to Customize and automate Greenplum data replication to Teradata.
-
DataBind Controls to Accelo Data in C++Builder
DataBind to Accelo data in C++Builder with standard components and controls.
-
Getting Started with the CData Power BI Connector for ConstantContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Query Live Amazon DynamoDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Amazon DynamoDB data through a conversational interface.
-
DataBind Controls to Hacker News Data in C++Builder
DataBind to Hacker News data in C++Builder with standard components and controls.
-
Automated Continuous FreeAgent Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FreeAgent replication to Apache Kafka.
-
Create Power BI Reports on Real-Time Sendwithus Data
Use the CData ODBC Driver for Sendwithus to visualize Sendwithus data in Power BI Desktop.
-
How to connect SharePoint with Snowflake Data through external lists
Provide Snowflake data to SharePoint users as an external list.
-
Enable the SingleStore JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SingleStore data.
-
Integrate with EnterpriseDB Data in JReport Designer
Create charts and reports based on EnterpriseDB data in JReport Designer.
-
Automate Calendly Data Replication to Azure Synapse
Use CData Sync to customize and automate Calendly data replication to Azure Synapse.
-
Integrating LangGraph with Bullhorn CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Bullhorn CRM data within automated workflows.
-
Build a Singer.io Tap for RabbitMQ With the CData Python Connector
Learn how to easily build a Singer.io Tap for live RabbitMQ data using the CData Python Connector.
-
Build Charts with SAP SuccessFactors LMS Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP SuccessFactors LMS data in Clear Analytics.
-
Trigger Oracle Service Cloud IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle Service Cloud with standard wizards in Logic Apps.
-
Connect and Query Live Active Directory Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Active Directory data into Databricks and enable direct, live querying and analysis without replication.
-
Consume Paylocity OData Feeds in PowerBuilder
This article demonstrates how to consume Paylocity data as OData feeds from PowerBuilder using the API Server.
-
Query ADP Data in ColdFusion
Write standard ColdFusion data access code to connect to ADP data.
-
Deploy the ADO.NET Provider for Zoho Recruit on an SSRS Report Server
Connect to Zoho Recruit data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to load Dynamics CRM data into Elasticsearch via Logstash
Introducing a simple method to load Dynamics CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Semantic Layer Views for SQL Server Data in APOS Live Data Gateway
Use the CData Connector for SQL Server in APOS Live Data Gateway to build Semantic Layer Views for SQL Server data.
-
Create Reports with HubSpot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubSpot data.
-
Build AI Agents with SAP Fieldglass 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 SAP Fieldglass data through CData Connect AI.
-
Getting Started with the CData ADO.NET Provider for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
Working with Insightly Data in LINQPad
Execute LINQ queries to Insightly data in LINQPad.
-
Deploy the ADO.NET Provider for Auth0 on an SSRS Report Server
Connect to Auth0 data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Visualize Amazon Marketplace 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 Amazon Marketplace data in Python.
-
How to Connect the Power BI Service to FTP: Complete Guide
Connect to the CData Software Power BI Connector for FTP from PowerBI.com to provide real-time FTP data across the organization.
-
Integrate Exa Data in the Pentaho Report Designer
Publish reports based on Exa data in the Pentaho BI tool.
-
Connect to Shortcut Data from a Connection Pool in JBoss
Integrate Shortcut data into Java servlets: Use the Management Console in JBoss to install the Shortcut JDBC Driver.
-
Integrating OpenCode with Jira 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 Sybase Data in DBeaver
Use the CData ODBC Driver to connect to Sybase data in DBeaver.
-
Integrate Live Microsoft Dataverse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Dataverse data to Blue Prism using the CData ODBC Driver for Microsoft Dataverse to create automated workflows for repetitive business tasks.
-
Integrate Goose with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live HubSpot data from within the local AI agent.
-
Connect to Google Forms Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Forms data from HeidiSQL.
-
Feed Google Ad Manager Data into FineReport
How to set Google Ad Manager data as a JDBC data source in FineReport.
-
Create SAP Business One-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Business One Data from OutSystems and build custom enterprise apps using live SAP Business One data.
-
Configure the CData JDBC Driver for Teradata in a Connection Pool in Tomcat
Connect to Teradata data from a connection pool in Tomcat.
-
Replicate RabbitMQ Data to Multiple Databases
Replicate RabbitMQ data to disparate databases with a point-and-click configuration.
-
How to Easily Query QuickBooks Online Data in OpenOffice Base
Connect to QuickBooks Online data in OpenOffice Base using the CData ODBC Driver for QuickBooks Online and generate reports with live data insights.
-
Connecting GenSpark with JSON Services via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to JSON services without any replication or custom integration required.
-
Analyze Paylocity Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Paylocity data with the CData JDBC Driver for Paylocity.
-
Use Azure AI Foundry to Talk to Your Reckon Accounts Hosted 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 Reckon Accounts Hosted data for you.
-
Automated Continuous Oracle Financials Cloud Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to SingleStore.
-
Access Clio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clio data from HeidiSQL.
-
Operational Reporting on ConvertAPI Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ConvertAPI data.
-
Connect to Greenhouse Data in ACL Analytics
Connect to Greenhouse data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Greenhouse data.
-
Object-Relational Mapping (ORM) with Salesforce Marketing 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 Salesforce Marketing data into a Java-based ORM framework, Hibernate.
-
Access Live Phoenix Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Phoenix data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.