CData Software - Knowledge Base
Recent Articles
-
Connect to Grafana Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Grafana and work with Grafana in your FileMaker application.
-
ETL SAP in Oracle Data Integrator
This article shows how to transfer SAP ERP/NetWeaver into a data warehouse using Oracle Data Integrator.
-
Integrating Kiro CLI with SAP SuccessFactors LMS 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 create Zoho Recruit federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Recruit in MySQL .
-
Analyze Google Drive Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Drive and visualize live Google Drive in Infragistics Reveal.
-
Automated Continuous Salesloft Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon Redshift.
-
Build Smartsheet-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Smartsheet Data and create custom apps in Mendix.
-
Build Apps with Live Ontraport Data Using the Low-Code Development Platform of Mendix
Connect Ontraport with Mendix to build apps using the CData API Driver for JDBC.
-
Manage SurveyMonkey Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SurveyMonkey.
-
Extend Google Sheets with IBM Cloud Object Storage Data
Make calls to IBM Cloud Object Storage from Google Apps Script via the API Server.
-
Connect to GraphQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL and execute queries in PowerBuilder.
-
Connect to Gmail Data from a Connection Pool in JBoss
Integrate Gmail into Java servlets: Use the Management Console in JBoss to install the Gmail JDBC Driver.
-
Automated Continuous Recurly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Recurly replication to MongoDB.
-
Feed Ontraport Data into FineReport
How to set Ontraport as a JDBC data source in FineReport.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZarMoney
Provide connectivity to ZarMoney through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live IBM Informix Data in Workato
Use CData Connect AI to connect to live IBM Informix and build automated workflows in Workato.
-
Prepare, Blend, and Analyze Bugsnag Data in Alteryx Designer (ODBC)
Build workflows to access live Bugsnag for self-service data analytics.
-
Extend Google Sheets with Greenplum Data
Make calls to Greenplum from Google Apps Script via the API Server.
-
Connecting Pipedream with ActiveCampaign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ActiveCampaign data in real time.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MySQL to Power BI dashboards. Simply drag and drop MySQL into data visuals on the Power BI canvas.
-
Connect to and Visualize Live Jodoo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jodoo.
-
How to connect to Oracle Data with Squirrel SQL client
Connect to Oracle Database and execute queries in the Squirrel SQL Client.
-
Automated Continuous Retently Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Retently replication to OneLake in Microsoft Fabric.
-
Access Live Amazon Marketplace Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Marketplace from your Excel spreadsheets.
-
Miro Reporting in OBIEE with the Miro JDBC Driver
Deploy the Miro JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Google Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Ads replication to IBM DB2.
-
How to Connect the Power BI Service to Printify: Complete Guide
Connect to the CData Software Power BI Connector for Printify from PowerBI.com to provide real-time Printify across the organization.
-
Work with Azure Data Lake Storage Data in FoxPro
Load Azure Data Lake Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData JDBC Driver for Quaderno
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Quaderno.
-
Integrate SparkPost with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SparkPost with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SparkPost.
-
Integrate Browserless Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Browserless from Informatica Cloud.
-
Getting Started with the CData ODBC Driver for Sage 300
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage 300.
-
Access Live SAS Data Sets Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAS Data Sets data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Explore Geographical Relationships in Bugsnag Data with Power Map
Create data visualizations with Bugsnag in Power Map.
-
View Reports on Real-Time Sybase IQ Data in Power BI Report Server
Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to MongoDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MongoDB in Airbyte.
-
Replicate Mistral AI Data from PowerShell
Write a quick PowerShell script to query Mistral AI. Use connectivity to the live data to replicate Mistral AI to SQL Server.
-
Rapidly Develop AgileCRM-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 AgileCRM.
-
Access Salesloft Data from MySQL in Amazon QuickSight
Connect to Salesloft and build visualizations of Salesloft using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Pipeline CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Amazon Redshift.
-
How to connect PolyBase to SharePoint Excel Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SharePoint Excel Services.
-
How to import Dynamics NAV Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics NAV in Data Import Handler and create an automated import of Microsoft Dynamics NAV to Apache Solr Enterprise Search platform.
-
DataBind Controls to Azure DevOps Data in C++Builder
DataBind to Azure DevOps in C++Builder with standard components and controls.
-
Access Zoho Inventory Data from MySQL in PHP
Connect to Zoho Inventory through the standard MySQL libraries in PHP.
-
Feed Presto Data into FineReport
How to set Presto as a JDBC data source in FineReport.
-
Build Semantic Layer Views for Scrapfly Data in APOS Live Data Gateway
Use the CData Connector for Scrapfly in APOS Live Data Gateway to build Semantic Layer Views for Scrapfly.
-
Build Dashboards with Blackbaud FE NXT Data in DBxtra
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT in DBxtra.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing Cloud for you.
-
Add Superchat Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Superchat with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with SendGrid Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SendGrid in SnapLogic.
-
Integrate Live Azure DevOps Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize Klipfolio Data in Tableau
The CData ODBC driver for Klipfolio enables you integrate Klipfolio into Tableau dashboards.
-
Explore Geographical Relationships in Dynamics 365 Data with Power Map
Create data visualizations with Microsoft Dynamics 365 in Power Map.
-
Connect to Zuora Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zuora from Appeon PowerBuilder using the CData ADO.NET Provider for Zuora.
-
Connect to Zuora Data in Ruby
Connect to Zuora in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Codex CLI with ClickTime 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.
-
Consume PostgreSQL OData Feeds in PowerBuilder
This article demonstrates how to consume PostgreSQL as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Oracle Financials Cloud Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Financials Cloud into custom reports in Power BI.
-
Automate SAP Netweaver Gateway Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Netweaver Gateway replication to Azure Data Lake.
-
Integrating LangChain with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Neo4J within automated workflows.
-
Automate Coinbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Coinbase replication to Azure Data Lake.
-
Configure the CData JDBC Driver for CloudConvert in a Connection Pool in Tomcat
Connect to CloudConvert from a connection pool in Tomcat.
-
How to Work with IBM Informix Data in ETL Validator JDBC
Connect to IBM Informix from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Google Cloud Storage Data in MicroStrategy through CData Connect AI
Create a live connection to Google Cloud Storage Data in CData Connect AI and connect to your Google Cloud Storage from MicroStrategy.
-
Easily Integrate Oracle Service Cloud Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Service Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Sybase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sybase and integrate live Sybase into your Power Automate tasks.
-
Connect to Real-Time OpenWeatherMap Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use OpenWeatherMap in Power Apps.
-
Use Biml to Build SSIS Tasks to Replicate OnePageCrm Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate OnePageCrm to SQL Server.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy
Connect to Microsoft Dynamics 365 in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365.
-
Create RabbitMQ Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time RabbitMQ data access from reports, embedded analytics, and more.
-
Integrate Real-Time Access to Amazon Marketplace in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Marketplace in real time.
-
Visualize Jumpseller Data in TIBCO Spotfire through ADO.NET
Integrate Jumpseller into dashboards in TIBCO Spotfire.
-
Connect to Live PostgreSQL Data in PostGresSQL Interface through CData Connect AI
Create a live connection to PostgreSQL in CData Connect AI and connect to your PostgreSQL from PostgreSQL.
-
Query Procore Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Procore from Node.js.
-
LINQ to SAP ByDesign 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 SAP ByDesign Data Provider.
-
Build Agents in Relevance AI with Access to Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Presto within intelligent agent workflows.
-
Create Power BI Reports on Real-Time MailerSend Data
Use the CData ODBC Driver for MailerSend to visualize MailerSend in Power BI Desktop.
-
Bind Live Greenhouse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Greenhouse data
-
Connect to SQL Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SQL Analysis Services in the Denodo Virtual DataPort Administrator.
-
Connect to Simplesat Data in DBeaver
Use the CData ODBC Driver to connect to Simplesat in DBeaver.
-
Connect to Google Calendar Data from a Connection Pool in Jetty
The Google Calendar JDBC Driver supports connection pooling: This article shows how to connect faster to Google Calendar from Web apps in Jetty.
-
Connect to Front Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy Desktop
Connect to Twilio in MicroStrategy Desktop using the CData Software JDBC Driver for Twilio.
-
Prepare, Blend, and Analyze Raisers Edge NXT Data in Alteryx Designer (Connect AI)
Build workflows to access live Raisers Edge NXT for self-service data analytics.
-
Use the CData Software JDBC Driver for Calendly in MicroStrategy
Connect to Calendly in MicroStrategy Developer using the CData Software JDBC Driver for Calendly.
-
How to load Twilio data into Elasticsearch via Logstash
Introducing a simple method to load Twilio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Microsoft Entra ID Data from MySQL in Amazon QuickSight
Connect to Microsoft Entra ID and build visualizations of Microsoft Entra ID using a MySQL Connection in Amazon QuickSight.
-
Build Visualizations of Printful Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Printful in Birst.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy Web
Connect to ConvertAPI in MicroStrategy Web using the CData Software ODBC Driver for ConvertAPI.
-
Load Adobe Experience Manager Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Experience Manager to a database.
-
Migrating data from Cloudflare to Google BigQuery using CData SSIS Components.
Easily push Cloudflare to Google BigQuery using the CData SSIS Tasks for Cloudflare and Google BigQuery.
-
Automated Continuous Bullhorn CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to OneLake in Microsoft Fabric.
-
Connect to Wistia Data from a Connection Pool in Jetty
The Wistia JDBC Driver supports connection pooling: This article shows how to connect faster to Wistia from Web apps in Jetty.
-
Stream Sendwithus Data into Apache Kafka Topics
Access and stream Sendwithus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Epicor Kinetic Data in DBVisualizer
Integrate Epicor Kinetic with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Beeminder Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Beeminder to a JSON file on disk.
-
How to Seamlessly Import Microsoft OneDrive Data into IBM SPSS Modeler
Integrate Microsoft OneDrive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Confluence Replication to Databricks
Use CData Sync for automated, continuous, customizable Confluence replication to Databricks.
-
Connect to Active Directory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Active Directory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Claude to Talk to Your Adobe Analytics 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 Adobe Analytics for you.