CData Software - Knowledge Base
Recent Articles
-
Enable the ConstantContact JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConstantContact.
-
How to Connect to Live Couchbase 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 Couchbase for you.
-
Automated Continuous Dynamics CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Kafka.
-
Build Pipelines with Live Zoho Projects Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Projects from Google Cloud Data Fusion, enabling the integration of live Zoho Projects into the building and management of effective data pipelines.
-
How to connect PolyBase to Microsoft Exchange
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Exchange.
-
Integrating LlamaIndex with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MYOB AccountRight in real time.
-
Publish Crystal Reports on Google Forms Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Forms.
-
Visualize CouchDB Data in TIBCO Spotfire through OData
Integrate Apache CouchDB into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for MarkLogic Data in Python with CData Connect AI
Build ETL pipelines that read and write live MarkLogic in Python with petl and the CData Connect AI Python SDK.
-
Build an OLAP Cube in SSAS from Pinecone Data
Establish a connection to Pinecone data from SQL Server Analysis Services, and use the Pinecone Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Kiro CLI with Marketo 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 Okta from Asprova with CData Software ODBC Driver for Okta
This article shows how to connect faster to Okta data from Asprova.
-
Model, Search, and Visualize Live Odoo Data in ThoughtSpot
Use CData Connect AI to connect to live Odoo ERP for modeling, searching, and visualizing.
-
Automated Continuous FreshBooks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FreshBooks replication to Apache Cassandra.
-
Build Dashboards with Pipeline CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pipeline CRM in Dundas BI.
-
Use the CData Software ODBC Driver for Onfleet in MicroStrategy Web
Connect to Onfleet in MicroStrategy Web using the CData Software ODBC Driver for Onfleet.
-
DataBind Teamwork Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Teamwork to a chart.
-
Build MVC Applications with Connectivity to Oracle HCM Cloud Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle HCM Cloud from an ASP.NET MVC application.
-
Use Dash to Build to Web Apps on Okta Data
Create Python applications that use pandas and Dash to build Okta-connected web apps.
-
Integrate Spotify Data in Pentaho Data Integration
Build ETL pipelines based on Spotify in the Pentaho Data Integration tool.
-
How to Connect Confluence 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 Confluence data in real time using natural language.
-
Getting Started with the CData Connect AI Python SDK for MYOB AccountRight
Install the CData Connect AI Python SDK to read and write live MYOB AccountRight with standard DB-API 2.0 Python code.
-
Create Reports with Sybase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase.
-
Integrate SharePoint Excel Services with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SharePoint Excel Services with External Services.
-
Operational Reporting on Redis Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Redis.
-
Create Apps from Zoho Creator Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho Creator Data and build apps from live Zoho Creator in Qlik Sense Cloud.
-
Operational Reporting on Sage Cloud Accounting Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage Business Cloud Accounting.
-
Replicate Google Search Results in Heroku for Use in Salesforce Connect
Replicate Google Search to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create an RPA flow for Google Search Results in UiPath Studio
Use the Google Search ODBC Driver to create workflows that access real-time Google Search without any coding.
-
Build a Simple VCL Application for HBase Data
How to build a simple VCL Application to view Apache HBase in RAD Studio using the CData ODBC Driver for HBase.
-
How to Create Power BI Visual Reports with Real-Time GetResponse Data
Use CData Power BI Connectors to visualize GetResponse in Power BI.
-
Migrating data from Blackbaud FE NXT to Snowflake using CData SSIS Components.
Easily push Blackbaud FE NXT to Snowflake using the CData SSIS Tasks for Blackbaud FE NXT and Snowflake.
-
Connect to YouTube Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with YouTube Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect and process Stripe from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Stripe.
-
Integrate Real-Time Access to Microsoft Teams in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Teams in real time.
-
Establish a Live Connection with EmailOctopus Data using Tableau Bridge
The CData ODBC Driver for EmailOctopus enables you to integrate live EmailOctopus into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Zoho Inventory Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to IBM DB2.
-
Getting Started with the CData JDBC Driver for Clockify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Clockify.
-
Connect to Microsoft Entra ID from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID from Web applications running on WebLogic.
-
Automate Oracle SCM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle SCM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build an OLAP Cube in SSAS from CockroachDB Data
Establish a connection to CockroachDB data from SQL Server Analysis Services, and use the CockroachDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Real-Time CockroachDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for CockroachDB and Dataflow to import and use CockroachDB in Power Apps.
-
Access OpenWeatherMap Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OpenWeatherMap from HeidiSQL.
-
Feed BambooHR Data into FineReport
How to set BambooHR as a JDBC data source in FineReport.
-
Enable the Cloudflare JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cloudflare.
-
How to Work with REST Data in AWS Glue Jobs Using JDBC
Connect to REST from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Create Power BI Visual Reports with Real-Time Trello Data
Use CData Power BI Connectors to visualize Trello in Power BI.
-
Perform Batch Operations with Snapchat Ads Data in Apache NiFi
Connect to Snapchat Ads and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Bitly Data in AWS Lambda
Connect to live Bitly in AWS Lambda using the CData JDBC Driver.
-
Connect to Azure DevOps Data from a Connection Pool in JBoss
Integrate Azure DevOps into Java servlets: Use the Management Console in JBoss to install the Azure DevOps JDBC Driver.
-
Automated Continuous Zoom Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoom replication to Amazon S3.
-
Visualize LDAP Objects in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load LDAP into TIBCO Spotfire.
-
Build a PostgreSQL Interface for Salesforce Data 360 Data using the CData JDBC Driver
Use the Remoting features of the Salesforce Data 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Paddle in MicroStrategy
Connect to Paddle in MicroStrategy Developer using the CData Software JDBC Driver for Paddle.
-
Use the CData ODBC Driver for Twilio in Microsoft Power Query
You can use the CData Twilio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twilio into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to & Open DB2 Data in Microsoft Excel
This article uses the CData ODBC driver for DB2 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Box in SpagoBI
Create reports featuring live Box in SpagoBI Studio. Host Box reports on SpagoBI Server.
-
Integrate Theia IDE with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate with Raisers Edge NXT Data in JReport Designer
Create charts and reports based on Raisers Edge NXT in JReport Designer.
-
How to create an RPA flow for Redis Data in UiPath Studio
Use the Redis ODBC Driver to create workflows that access real-time Redis without any coding.
-
Integrate QuickBooks Time Data in Pentaho Data Integration
Build ETL pipelines based on QuickBooks Time in the Pentaho Data Integration tool.
-
Build Data Flows from SQL Server to Workday through SSIS
Easily push SQL Server data to Workday using the CData SSIS Tasks for Workday.
-
Connect to Brex Data in Aqua Data Studio
Access Brex from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Apps with Live YouTube Analytics Data Using the Low-Code Development Platform of Mendix
Connect YouTube Analytics with Mendix to build apps using the CData JDBC Driver for YouTube Analytics.
-
Connect to Jira Data in RapidMiner
Integrate Atlassian Jira with standard components and data source configuration wizards in RapidMiner Studio.
-
Natively Connect to Odoo Data in PHP
The CData ODBC driver for Odoo enables you to create PHP applications with connectivity to Odoo ERP. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Quickbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Quickbase.
-
Access Live Splunk 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 Splunk through MCP integration.
-
Integrate Tally Data in the Pentaho Report Designer
Publish reports based on Tally ERP in the Pentaho BI tool.
-
Create Power BI Reports on Real-Time OnePageCrm Data
Use the CData ODBC Driver for OnePageCrm to visualize OnePageCrm in Power BI Desktop.
-
Connect to Campaigner Data in JRuby
Create a simple JRuby app with access to live Campaigner.
-
How to Connect to Live SAP Ariba Source 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 SAP Ariba Source for you.
-
Use Biml to Build SSIS Tasks to Replicate Float Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Float to SQL Server.
-
Connect Cohere Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Cohere using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Add Instantly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Instantly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live AlloyDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google AlloyDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Foursquare Data in the Pentaho Report Designer
Publish reports based on Foursquare in the Pentaho BI tool.
-
Create HubSpot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HubSpot Data from Klipfolio and build custom visualizations using live HubSpot.
-
Create Dashboards and Visualize Live Google Analytics Data in Geckoboard
Use CData Connect AI to connect to live Google Analytics and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to and Query Figshare Data in QlikView over ODBC
Create data visualizations with Figshare in QlikView.
-
Integrating GitHub Copilot CLI with SendGrid 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 Seamlessly Import Telegram Data into IBM SPSS Modeler
Integrate Telegram data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Viewing Insightly Data in RAD Studio Data Explorer
How to view Insightly in RAD Studio Data Explorer using the CData ODBC Driver for Insightly.
-
How to create Certinia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Certinia in MySQL .
-
How to Create Power BI Visual Reports with Real-Time Jodoo Data
Use CData Power BI Connectors to visualize Jodoo in Power BI.
-
Integrating Procore Data in Talend Cloud Data Management Platform
Connect Procore Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with Strava 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 Real-Time Postmark Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Postmark in Power Apps.
-
Connect to SAP SuccessFactors LMS Data in RazorSQL
Connect to SAP SuccessFactors LMS from wizards and query SAP SuccessFactors LMS from the GUI in the RazorSQL database management tool.
-
Use Azure AI Foundry to Talk to Your Twilio 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 Twilio for you.
-
How to connect and process Eventbrite from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Eventbrite.
-
Automated Continuous Square Replication to SingleStore
Use CData Sync for automated, continuous, customizable Square replication to SingleStore.
-
Visualize Live Authorize.Net Data in the Power BI Service
Use CData Connect AI to connect to live Authorize.Net and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Zoho Projects-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Projects.
-
Consume Lakebase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Lakebase feeds that reflect any changes in SAP Lumira.
-
Analyze Neo4J Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Neo4J and visualize Neo4J in SAP Analytics Cloud.
-
How to connect PolyBase to Azure Data Catalog
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Data Catalog.
-
Connect to Everhour Data from a Connection Pool in Jetty
The Everhour JDBC Driver supports connection pooling: This article shows how to connect faster to Everhour from Web apps in Jetty.
-
Create Informatica Mappings From/To a JDBC Data Source for Klipfolio
Create Klipfolio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.