CData Software - Knowledge Base
Recent Articles
-
Visualize Live Oracle Service Cloud Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Service Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Xero Replication to MySQL
Use CData Sync for automated, continuous, customizable Xero replication to MySQL.
-
Extract, Transform, and Load Bugsnag Data in Informatica PowerCenter
Create a simple Workflow for Bugsnag in Informatica PowerCenter.
-
Replicate ZohoPeople Data from PowerShell
Write a quick PowerShell script to query ZohoPeople. Use connectivity to the live data to replicate ZohoPeople to SQL Server.
-
Build Pipelines with Live Oracle Financials Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Financials Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Financials Cloud into the building and management of effective data pipelines.
-
Connect to Microsoft Planner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Planner and the SQL Gateway to access Microsoft Planner from Google Apps Script.
-
Use Agno to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Ads for you.
-
How to Connect to Live HBase 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 Apache HBase for you.
-
Feed iContact Data into FineReport
How to set iContact as a JDBC data source in FineReport.
-
Getting Started with the CData SSIS Components for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LaunchDarkly.
-
How to work with Clockify Data in Apache Spark using SQL
Access and process Clockify Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with SAS xpt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAS XPORT to a JSON file on disk.
-
Integrate Instantly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Instantly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Instantly.
-
DataBind Controls to Attio Data in Delphi
DataBind to Attio in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Web
Connect to Unbounce in MicroStrategy Web using the CData Software ODBC Driver for Unbounce.
-
Create YouTube Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time YouTube Analytics data access from reports, embedded analytics, and more.
-
Connect to Azure Synapse 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 Synapse.
-
Use the CData ODBC Driver for QuickBooks in Microsoft Power Query
You can use the CData QuickBooks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks Desktop into Microsoft Power Query.
-
How to Connect to Live Okta 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 Okta through natural language.
-
Create SSAS Tabular Models from Egnyte Data
How to build a SQL Server Analysis Service Tabular Model from Egnyte using CData drivers.
-
Natively Connect to Cohere Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cohere. Leverage the native support for ODBC in PHP.
-
Use Manus AI to Talk to Your Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Elasticsearch.
-
Build Charts with SAP Netweaver Gateway Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Netweaver Gateway in Clear Analytics.
-
How to connect and process Figshare from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Figshare.
-
Use Grok to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Outreach.io for you.
-
Replicate Wave Financial Data in Heroku for Use in Salesforce Connect
Replicate Wave Financial to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Live ConvertKit Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live ConvertKit from the Cline extension in Visual Studio Code.
-
How to Query Zoho Projects Data in MySQL Workbench
Execute MySQL queries against live Zoho Projects from MySQL Workbench.
-
Publish Clio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clio.
-
Object-Relational Mapping (ORM) with JotForm 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 JotForm into a Java-based ORM framework, Hibernate.
-
How to Work with Xero Data in ETL Validator JDBC
Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Zendesk Data in DBVisualizer
Integrate Zendesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Apps with Live Mistral AI Data Using the Low-Code Development Platform of Mendix
Connect Mistral AI with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Float Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Float data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Query Live Slack Data in Claude Desktop
Connect to and query live Slack Data in Claude Desktop using CData MCP Server.
-
Access Live CouchDB Data in Excel 365 Online (Excel for the web)
Connect to Apache CouchDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Dotmailer Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to PostgreSQL.
-
Access eBay Data from MySQL in Amazon QuickSight
Connect to eBay and build visualizations of eBay using a MySQL Connection in Amazon QuickSight.
-
Build Dashboards with PabblySubscriptions Data in Dundas BI
Create dynamic dashboards and perform analytics based on PabblySubscriptions in Dundas BI.
-
Viewing Clockify Data in RAD Studio Data Explorer
How to view Clockify in RAD Studio Data Explorer using the CData ODBC Driver for Clockify.
-
ETL Perigon in Oracle Data Integrator
This article shows how to transfer Perigon into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Salesforce Marketing Data in QlikView over ODBC
Create data visualizations with Salesforce Marketing Cloud in QlikView.
-
How to connect to AgileCRM Data from Spring Boot
Connect to AgileCRM in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from Egnyte to Google BigQuery using CData SSIS Components.
Easily push Egnyte to Google BigQuery using the CData SSIS Tasks for Egnyte and Google BigQuery.
-
Connect to Live Raisers Edge NXT Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Raisers Edge NXT in CData Connect AI and connect to your Raisers Edge NXT from PostgreSQL.
-
Integrating Antigravity CLI with EnterpriseDB via CData CLI
Connect EnterpriseDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Bidirectional Access to Ontraport Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Ontraport in Filemaker Pro for Mac or Windows.
-
Integrating OpenCode Terminal with Yelp 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.
-
Create Power BI Reports on Real-Time Sybase IQ Data
Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ in Power BI Desktop.
-
Work with Live Google Ad Manager Data in Power Query
Use CData Connect AI to connect to Google Ad Manager and work with live Google Ad Manager in Microsoft Power Query.
-
Access Live OneNote Data in AWS Lambda
Connect to live Microsoft OneNote in AWS Lambda using the CData JDBC Driver.
-
Analyze Zoom Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoom in Microsoft R Open.
-
Automated Continuous FreeAgent Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FreeAgent replication to Amazon S3.
-
Access Live Sybase Data in TIBCO Data Virtualization
Use the Sybase Tibco DV Adapter to create a Sybase data source in TIBCO Data Virtualization Studio and gain access to live Sybase from your TDV Server.
-
How to connect and process Everhour from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Everhour.
-
Build Microsoft Teams-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Teams and build web apps with connectivity to live Microsoft Teams.
-
Use the CData Software ODBC Driver for Brex in SAS for Real-Time Reporting and Analytics
Connect to real-time Brex in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Brex.
-
Query Slack Data as a MySQL Database in Node.js
Execute MySQL queries against Slack from Node.js.
-
Connect to Zuora Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zuora and the Script function in FileMaker Pro to connect to Zuora and work with Zuora in your FileMaker application.
-
Bind Live VWO Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live VWO data
-
Connect to Demio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Demio and the SQL Gateway to access Demio from Google Apps Script.
-
Access Live HDFS Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HDFS data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to work with Wrike Data in Apache Spark using SQL
Access and process Wrike Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Clio Data in Ruby
Connect to Clio in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations in Cognos BI with xBase Data
Access xBase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bidirectional Access to Salesforce Marketing Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Marketing Cloud in Filemaker Pro for Mac or Windows.
-
Integrate Real-Time Access to Amazon DynamoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon DynamoDB in real time.
-
Extend Google Sheets with Sybase Data
Make calls to Sybase from Google Apps Script via the API Server.
-
Connect Omnisend to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Omnisend with IBM WebSphere for seamless data integration and connectivity.
-
Create Data Visualizations in Cognos BI with Zoho Creator Data
Access Zoho Creator as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build BambooHR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BambooHR and build web apps with connectivity to live BambooHR.
-
Replicate HelloSign Data in Heroku for Use in Salesforce Connect
Replicate HelloSign to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Slack 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 Slack through MCP integration.
-
Build MVC Applications with Connectivity to Bitly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bitly from an ASP.NET MVC application.
-
Connect to Aweber Data in Jaspersoft Studio
Execute SQL to remote Aweber in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Templated
Provide connectivity to Templated through an SAP BusinessObjects universe.
-
How to Connect to Live Active Directory 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 Active Directory for you.
-
Query Reckon Data as a MySQL Database in Node.js
Execute MySQL queries against Reckon from Node.js.
-
Connect to Square Data in JRuby
Create a simple JRuby app with access to live Square.
-
How to connect Amazon QuickSight to Snowflake Data
Create a connection to Snowflake in CData Connect AI and insert Snowflake into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData ODBC Driver for HCL Domino
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HCL Domino.
-
Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage Cloud Accounting to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live SAP BusinessObjects BI Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP BusinessObjects BI for you.
-
A PostgreSQL Interface for LaunchDarkly Data (MySQL Remoting via JDBC)
Use the Remoting features of the LaunchDarkly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Office 365 Data
Use the CData ODBC Driver for Office 365 to visualize Microsoft Office 365 in Power BI Desktop.
-
Moving Data from CSV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CSV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a PostgreSQL Interface for Bitly Data using the CData JDBC Driver
Use the Remoting features of the Bitly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Sage 300 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon Redshift.
-
Getting Started with the CData ODBC Driver for Pipedrive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pipedrive.
-
Create Basecamp-Connected Dashboards in Grafana
Connect to Basecamp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Basecamp.
-
Getting Started with the CData SSIS Components for NASA
Complete guide to installing, licensing, and connecting with the CData SSIS Components for NASA.
-
Migrating data from Spotify to Google BigQuery using CData SSIS Components.
Easily push Spotify to Google BigQuery using the CData SSIS Tasks for Spotify and Google BigQuery.
-
Automated Continuous Freshservice Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshservice replication to AlloyDB.
-
Import and Visualize SAP Netweaver Gateway Data in Power View
Create data visualizations based on SAP Netweaver Gateway in Excel.
-
Use Microsoft Copilot Studio to talk to your SAP Fieldglass 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 SAP Fieldglass for you.
-
How to Create Power BI Visual Reports with Real-Time RSS Feeds
Use CData Power BI Connectors to visualize RSS Feeds in Power BI.
-
Process & Analyze Act-On Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Act-On Data.
-
Integrating Authorize.Net Data in Talend Cloud Data Management Platform
Connect Authorize.Net Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Authorize.Net.
-
Model, Search, and Visualize Live Dynamics CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Dynamics CRM for modeling, searching, and visualizing.
-
Getting Started with the CData Python Connector for Gorgias
Learn to install and license the CData Python Connector