CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with ActiveCampaign Data in DBxtra
Create dynamic dashboards and perform analytics based on ActiveCampaign in DBxtra.
-
Connect to Facebook Ads Data in JRuby
Create a simple JRuby app with access to live Facebook Ads.
-
How to Connect to Live Zuora 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 Zuora for you.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange through natural language.
-
Analyze SAP Hybris C4C Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Hybris C4C with the CData JDBC Driver for SAP Hybris C4C.
-
Getting Started with the CData JDBC Driver for Jumpseller
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jumpseller.
-
Connect to Hugging Face Data in NetBeans
Connect to Hugging Face in NetBeans with the data source configuration wizard.
-
Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver
Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Calendly Data in Tableau
The CData ODBC driver for Calendly enables you integrate Calendly into Tableau dashboards.
-
Migrating data from Hive to Google BigQuery using CData SSIS Components.
Easily push Apache Hive to Google BigQuery using the CData SSIS Tasks for Hive and Google BigQuery.
-
Build Tally-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Tally to explore live Tally Data in Cursor to assist with building Tally-powered applications.
-
Connect to Close Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting Mastra with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MySQL, no replication required.
-
Build a PostgreSQL Interface for MailChimp Data using the CData JDBC Driver
Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on Oracle Eloqua Data with the QUERY Formula
Pull data from Oracle Eloqua, automate spreadsheets, and more with the QUERY formula.
-
Analyze Dropbox Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dropbox from Power Pivot. You will use the Table Import Wizard to load Dropbox. You can visually build the import query or use any SQL supported by the driver.
-
Feed Okta Data into FineReport
How to set Okta as a JDBC data source in FineReport.
-
How to Connect to & Open Shippo Data in Microsoft Excel
This article uses the CData ODBC driver for Shippo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Invoiced Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Invoiced. Leverage the native support for ODBC in PHP.
-
Automate Microsoft Entra ID Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Entra ID from PowerShell? This article demonstrates how to utilize the Microsoft Entra ID Cmdlets for tasks like connecting to Microsoft Entra ID, automating operations, downloading data, and more.
-
Connect to Zoho Inventory Data in RapidMiner
Integrate Zoho Inventory with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze IBM Informix Data in Cognos Analytics
Use CData Connect AI to connect to IBM Informix Data from Cognos Analytics and analyze live IBM Informix.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Procurement
Create an ODBC connection to SAP Ariba Procurement in Informatica and browse and transfer SAP Ariba Procurement.
-
Use the CData Software ODBC Driver for ZendeskSell in SAS for Real-Time Reporting and Analytics
Connect to real-time ZendeskSell in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZendeskSell.
-
Connect to SAP BusinessObjects BI Data in DBeaver
Use the CData ODBC Driver to connect to SAP BusinessObjects BI in DBeaver.
-
How to Connect to Live Office 365 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Office 365 securely in real time.
-
Query AfterShip Data in ColdFusion
Write standard ColdFusion data access code to connect to AfterShip.
-
DataBind Controls to IBM Cloud Object Storage Data in C++Builder
DataBind to IBM Cloud Object Storage in C++Builder with standard components and controls.
-
Query ZeroBounce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZeroBounce from Node.js.
-
Connect to Telegram Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Telegram.
-
Create Informatica Mappings From/To a JDBC Data Source for Square
Create Square data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Apollo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Apollo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Inventory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Inventory to SQL Server.
-
Consume Google Drive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Drive feeds that reflect any changes in SAP Lumira.
-
Create Reports from Google Contacts Data in Looker Studio
Use CData Connect AI to gain access to live Google Contacts and create custom reports in Looker Studio.
-
Authenticating Connections from the Client Side (Power BI & More)
Authenticate to a service or application directly from a client tool without relying on the ODBC DSN settings
-
Integrate Cursor with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live OData from within the editor.
-
Import Real-Time SAP SuccessFactors LMS Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP SuccessFactors LMS in ColdFusion.
-
Use the CData ODBC Driver for REST from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring REST in Excel.
-
Import Real-Time Printify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Printify in ColdFusion.
-
Access Live Testmonitor Data in Coginiti Pro
Connect to and query live Testmonitor from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Connect AI Python SDK for WordPress
Install the CData Connect AI Python SDK to read and write live WordPress with standard DB-API 2.0 Python code.
-
Integrating Dataiku with QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live QuickBooks Online.
-
Configure the CData JDBC Driver for Customer.io in a Connection Pool in Tomcat
Connect to Customer.io from a connection pool in Tomcat.
-
How to create FHIR federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for FHIR in MySQL .
-
Integrate Cursor with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Synapse from within the editor.
-
Connect VWO to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect VWO with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Grafana Data (MySQL Remoting via JDBC)
Use the Remoting features of the Grafana JDBC Driver to create a PostgreSQL entry-point for data access.
-
Establish a Live Connection with Outreach.io Data using Tableau Bridge
The CData ODBC Driver for Outreach.io enables you to integrate live Outreach.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Theia IDE with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to connect to Microsoft Planner Data from IntelliJ
Integrate connectivity to Microsoft Planner with wizards in IntelliJ.
-
Connect to FreeAgent Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to DocuSign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Outreach.io Data Replication to SAP HANA
Use CData Sync to customize and automate Outreach.io replication to SAP HANA.
-
Automated Continuous Wave Financial Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Wave Financial replication to AlloyDB.
-
Visualize MailerLite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerLite.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Square
Provide connectivity to Square through an SAP BusinessObjects universe.
-
Build SQL Server-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft SQL Server and build web apps with connectivity to live Microsoft SQL Server.
-
Automate Sybase Data Replication to SAP HANA
Use CData Sync to customize and automate Sybase replication to SAP HANA.
-
Consume Neo4J OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Neo4J feeds that reflect any changes in SAP Lumira.
-
How to update Snapchat Ads from Excel
This article explains how to transfer data from Excel to Snapchat Ads using the Excel Add-In for Snapchat Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for ActiveCampaign
Create an ODBC connection to ActiveCampaign in Informatica and browse and transfer ActiveCampaign.
-
Natively Connect to HelloSign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HelloSign. Leverage the native support for ODBC in PHP.
-
Connect to GitLab Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GitLab using standard SQL.
-
Feed SAP BusinessObjects BI Data into FineReport
How to set SAP BusinessObjects BI as a JDBC data source in FineReport.
-
Bidirectional Access to MessageBird Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MessageBird in Filemaker Pro for Mac or Windows.
-
Validate Freshservice Data with QuerySurge
Access and validate Freshservice in QuerySurge using the CData JDBC Driver.
-
Analyze SendGrid Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SendGrid and visualize live SendGrid in Infragistics Reveal.
-
Automated Continuous Spark Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Spark replication to IBM DB2.
-
Create Reports from Jira Assets Data in Looker Studio
Use CData Connect AI to gain access to live Jira Assets and create custom reports in Looker Studio.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy
Connect to Everhour in MicroStrategy Developer using the CData Software ODBC Driver for Everhour.
-
Stream PagerDuty Data into Apache Kafka Topics
Access and stream PagerDuty in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build Web Apps on Elasticsearch Data via CData Connect AI
Build interactive Dash web apps on live Elasticsearch using pandas and the CData Connect AI Python SDK.
-
Visualize Webex Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Webex.
-
Connect to SAP Ariba Procurement Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Ariba Procurement from Crystal Reports.
-
Connect to Live Excel Online Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Excel Online in CData Connect AI and connect to your Microsoft Excel Online from PostgreSQL.
-
Connect to Outreach.io Data in Ruby
Connect to Outreach.io in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SAP Ariba Procurement Data in Jaspersoft Studio
Execute SQL to remote SAP Ariba Procurement in Jaspersoft Studio.
-
Integrating LangChain with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Jira Assets within automated workflows.
-
Build a Simple VCL Application for CircleCI Data
How to build a simple VCL Application to view CircleCI in RAD Studio using the CData ODBC Driver for CircleCI.
-
Integrate Teradata with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Teradata with External Services.
-
Access Live FreshBooks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FreshBooks in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build MVC Applications with Connectivity to QuickBooks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks from an ASP.NET MVC application.
-
Connect to Oracle SCM Data from AWS Glue
Use CData Connect AI to gain access to live Oracle SCM from your AWS Glue jobs.
-
Integrate with Amazon Marketplace Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Marketplace to a JSON file on disk.
-
Connect to Templated Data in Jaspersoft Studio
Execute SQL to remote Templated in Jaspersoft Studio.
-
Automated Continuous Vault CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Vault CRM replication to Google BigQuery.
-
Build MVC Applications with Connectivity to Amazon Marketplace Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon Marketplace from an ASP.NET MVC application.
-
Automated Pipeliner CRM Data Replication to Teradata
Use CData Sync to Customize and automate Pipeliner CRM replication to Teradata.
-
How to Connect to Live MongoDB 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 MongoDB for you.
-
Connecting Agentforce with Phoenix 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 Apache Phoenix for you.
-
Bidirectional Access to Billsby Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Billsby in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Bannerbear Data using Tableau Bridge
The CData ODBC Driver for Bannerbear enables you to integrate live Bannerbear into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for SAS xpt Data using JDBI
A brief overview of creating a SQL Object API for SAS XPORT in JDBI.
-
Configure the CData JDBC Driver for Telegram in a Connection Pool in Tomcat
Connect to Telegram from a connection pool in Tomcat.
-
Replicate Multiple Dynamics NAV Accounts
Replicate multiple Dynamics NAV accounts to one or many databases.
-
Operational Reporting on Pipeline CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipeline CRM.
-
Enable the Nuclia JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Nuclia.
-
Create Datasets from Grafana in Domo Workbench and Build Visualizations of Grafana Data in Domo
Use the CData Software ODBC Driver for Grafana to create datasets from Grafana in Domo Workbench and then build visualizations in the Domo service.
-
Build OneNote-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for OneNote to explore live OneNote Data in GitHub Copilot to assist with building OneNote-powered applications.