CData Software - Knowledge Base
Recent Articles
-
Billsby Reporting in OBIEE with the Billsby JDBC Driver
Deploy the Billsby JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live Cvent Data in Visual Studio Code via Cline
Run CData MCP Server for Cvent on Windows Subsytem for Linux (WSL) and connect to live Cvent from the Cline extension in Visual Studio Code.
-
How to create Accelo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Accelo in MySQL .
-
Replicate Multiple Adobe Commerce Accounts via the CData Sync CLI
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Automated Continuous Azure Data Catalog Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Azure SQL Database.
-
Configure the CData JDBC Driver for Cvent in a Connection Pool in Tomcat
Connect to Cvent from a connection pool in Tomcat.
-
Access Spotify 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 Spotify.
-
Visualize Live Basecamp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Basecamp.
-
Connect to Aweber Data in HULFT Integrate
Connect to Aweber as a JDBC data source in HULFT Integrate
-
How to Access ChartMogul Data Using Entity Framework
This article shows how to access ChartMogul using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Viewing Harvest Data in RAD Studio Data Explorer
How to view Harvest in RAD Studio Data Explorer using the CData ODBC Driver for Harvest.
-
Load Insightly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Insightly to a database.
-
Access Live HelloSign Data in AWS Lambda
Connect to live HelloSign in AWS Lambda using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time ZeroBounce Data
Use CData Power BI Connectors to visualize ZeroBounce in Power BI.
-
Import Real-Time Salesforce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce & Force.com in ColdFusion.
-
Use the CData Software JDBC Driver for Simplesat in MicroStrategy Web
Connect to Simplesat in MicroStrategy Web using the CData Software JDBC Driver for Simplesat.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy Desktop
Connect to Oracle Database in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle.
-
Analyze ShipStation Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ShipStation and visualize live ShipStation in Infragistics Reveal.
-
Automate Authorize.Net Data Replication to Azure Synapse
Use CData Sync to customize and automate Authorize.Net replication to Azure Synapse.
-
How to Connect to Live Smartsheet Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Smartsheet through natural language.
-
Connect to HBase 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 Apache HBase.
-
Build SQL Analysis Services-Connected Apps in Choreo
Use CData Connect AI to connect to SQL Analysis Services Data from Choreo and build custom apps using live SQL Analysis Services.
-
Connect to Mode from Asprova with CData Software ODBC Driver for Mode
This article shows how to connect faster to Mode data from Asprova.
-
Build Charts with SharePoint Excel Services Data in Clear Analytics
Create dynamic charts and perform analytics based on SharePoint Excel Services in Clear Analytics.
-
Integrate with Live Trello Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Trello from the MuleSoft Anypoint Platform to integrate live Trello into custom reports and dashboards.
-
Integrate Cline with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Pipedrive from within your IDE.
-
Connect to GitHub Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GitHub Data and connect to GitHub in Akorbi Digital RunMyProcess.
-
Extract, Transform, and Load Phoenix Data in Informatica PowerCenter
Create a simple Workflow for Apache Phoenix in Informatica PowerCenter.
-
Connect to Live Microsoft Teams Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Teams Data in CData Connect AI and connect to your Microsoft Teams from MicroStrategy.
-
Create Reports with GitHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitHub.
-
Use Claude to Talk to Your Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle Sales for you.
-
How to Connect to Live CSV 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 CSV/TSV Files for you.
-
Automated Continuous DocuSign Replication to Databricks
Use CData Sync for automated, continuous, customizable DocuSign replication to Databricks.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Oracle Eloqua actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to ShipEngine Data from PowerBuilder via JDBC
This article demonstrates how to access ShipEngine from PowerBuilder using the ShipEngine JDBC Driver.
-
Connect to Contentful Data in NetBeans
Connect to Contentful in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Exa in MicroStrategy Web
Connect to Exa in MicroStrategy Web using the CData Software ODBC Driver for Exa.
-
Connect to Insightly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Insightly in the Denodo Virtual DataPort Administrator.
-
ETL Act CRM in Oracle Data Integrator
This article shows how to transfer Act CRM into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Trello Replication to SingleStore
Use CData Sync for automated, continuous, customizable Trello replication to SingleStore.
-
Getting Started with the CData ODBC Driver for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay Analytics.
-
Create Reports with Oracle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Database.
-
Automate SAP BusinessObjects BI Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP BusinessObjects BI and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Seamlessly Import Onfleet Data into IBM SPSS Modeler
Integrate Onfleet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Guru Data in the Pentaho Report Designer
Publish reports based on Guru in the Pentaho BI tool.
-
How to connect PolyBase to SAP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP ERP/NetWeaver.
-
Automate GitHub Data Replication to Couchbase
Use CData Sync to Customize and automate GitHub replication to Couchbase.
-
Connect and Visualize Live BambooHR Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live BambooHR into the Databricks platform and create visualization dashboards with real-time BambooHR.
-
Visualize Adobe Experience Manager 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 Adobe Experience Manager into TIBCO Spotfire.
-
Integrate Lakebase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Lakebase with External Services.
-
Deploy the ADO.NET Provider for Apify on an SSRS Report Server
Connect to Apify 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.
-
Integrating Gumloop with Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon DynamoDB within automated workflows.
-
Editing API Driver API Profiles
Edit existing API Profiles to enable more SQL access to APIs.
-
Excel Spreadsheet Automation on Adobe Target Data with the QUERY Formula
Pull data from Adobe Target, automate spreadsheets, and more with the QUERY formula.
-
Moving Data from JotForm to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live JotForm data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Microsoft Dataverse Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Dataverse Data from Azure Data Factory and import live Microsoft Dataverse (CDS).
-
Extend Google Sheets with Blackbaud FE NXT Data
Make calls to Blackbaud FE NXT from Google Apps Script via the API Server.
-
Use ChatGPT to Talk to Your Adobe Analytics 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 Adobe Analytics for you.
-
Feed Attio Data into FineReport
How to set Attio as a JDBC data source in FineReport.
-
Connect to Zoho Projects Data from a Connection Pool in JBoss
Integrate Zoho Projects into Java servlets: Use the Management Console in JBoss to install the Zoho Projects JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Rootly
Create an ODBC connection to Rootly in Informatica and browse and transfer Rootly.
-
Build FHIR-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to FHIR Data from Zoho Analytics and import live FHIR.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy Desktop
Connect to Microsoft Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Ads.
-
Connect to Mixpanel Data in NetBeans
Connect to Mixpanel in NetBeans with the data source configuration wizard.
-
Load Supabase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Supabase to a database.
-
Visualize Teradata Data in Sisense
Create an ElastiCube in Sisense app with access to Teradata.
-
Import Excel Online Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Excel Online. In this article, you will use the OData format to import Microsoft Excel Online into Microsoft Power Query.
-
Getting Started with the CData Excel Add-In for Vimeo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vimeo.
-
How to Visualize Twilio Data in Python with pandas
Use pandas and other modules to analyze and visualize live Twilio in Python.
-
Operational Reporting on Vercel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vercel.
-
Getting Started with the CData Power BI Connector for Sage 200
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage 200.
-
Connect to Cloudflare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cloudflare to connect to Cloudflare from Web applications running on WebLogic.
-
How to integrate CircleCI with Apache Airflow
Access and process CircleCI in Apache Airflow using the CData JDBC Driver.
-
Extend Google Sheets with MarkLogic Data
Make calls to MarkLogic from Google Apps Script via the API Server.
-
Query QuickBooks Online Data from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Online and perform CRUD operations on QuickBooks Online from Node.js.
-
Visualize Greenplum Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pivotal GreenPlum.
-
DataBind Controls to Zoom Data in C++Builder
DataBind to Zoom in C++Builder with standard components and controls.
-
Integrating Kiro CLI with Hugging Face 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 Real-Time Snowflake Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Snowflake and Dataflow to import and use Snowflake in Power Apps.
-
Access Live CouchDB 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 Apache CouchDB through MCP integration.
-
How to Connect DBeaver to Microsoft Dataverse via a JDBC Driver
Manage Microsoft Dataverse (CDS) with visual tools in DBeaver like the query browser.
-
Build WordPress-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to WordPress Data from Zoho Analytics and import live WordPress.
-
Connect Tavily to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tavily using the CData Python MCP Server.
-
Integrating Boomi Agentstudio with Microsoft Exchange Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Exchange, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live MailerLite Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MailerLite into the statistical analysis tools available in SAS JMP. This article shows how to use MailerLite in the Graph Builder and Query Builder.
-
Query, Visualize, and Share live Snowflake Data in Redash
Use CData Connect AI to connect to live Snowflake in Redash for querying, visualizing, and sharing.
-
DataBind ClickTime Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ClickTime to a chart.
-
Analyze Mocean Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mocean in Microsoft R Open.
-
Publish Factorial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Factorial.
-
Build Workable-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workable and build web apps with connectivity to live Workable.
-
Visualize Live Harvest Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Harvest using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to DocuSign Data in C++Builder
DataBind to DocuSign in C++Builder with standard components and controls.
-
Object-Relational Mapping (ORM) with Spark 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 Apache Spark SQL into a Java-based ORM framework, Hibernate.
-
Create Reports with Aha! Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aha!.
-
Publish Freshsales-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshsales.
-
How to Access Live CSV Data in Visual Studio Code via Cline
Run CData MCP Server for CSV on Windows Subsytem for Linux (WSL) and connect to live CSV/TSV Files from the Cline extension in Visual Studio Code.
-
How to Create Power BI Visual Reports with Real-Time ZohoExpense Data
Use CData Power BI Connectors to visualize ZohoExpense in Power BI.
-
Integrate Goose with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle SCM from within the local AI agent.
-
Presto Reporting in OBIEE with the Presto JDBC Driver
Deploy the Presto JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Adobe Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital