CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Sales Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Sales as a data source.
-
Automated Continuous ClickTime Replication to Oracle
Use CData Sync for automated, continuous, customizable ClickTime replication to Oracle.
-
Connecting Moonlit Workflow with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sybase IQ in real time.
-
Using the CData Software ODBC Driver for Cosmos DB in PyCharm
Connect to Cosmos DB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cosmos DB.
-
Create MongoDB-Connected Business Apps in AppSheet
Connect to MongoDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MongoDB.
-
ETL Salesforce Data 360 in Oracle Data Integrator
This article shows how to transfer Salesforce Data 360 into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Aweber Replication to Snowflake
Use CData Sync for automated, continuous, customizable Aweber replication to Snowflake.
-
Access Live Access Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Access in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
View Reports on Real-Time Microsoft Teams Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Teams to visualize Microsoft Teams in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous HCL Domino Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HCL Domino replication to AlloyDB.
-
Connect to PolarTeamPro Data from PowerBuilder via JDBC
This article demonstrates how to access PolarTeamPro from PowerBuilder using the PolarTeamPro JDBC Driver.
-
Query Live Freshservice Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Freshservice directly from the development environment.
-
Build Automated Workflows with Live MySQL Data in Workato
Use CData Connect AI to connect to live MySQL and build automated workflows in Workato.
-
DataBind SendInBlue Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SendInBlue to a chart.
-
Automated Continuous Exa Replication to MongoDB
Use CData Sync for automated, continuous, customizable Exa replication to MongoDB.
-
Edit and Search External Gmail Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Gmail to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Gmail Data objects that you can access from apps and the dashboard.
-
Automated Continuous DB2 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable DB2 replication to delimited files (CSV/TSV).
-
Access Stack Exchange Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Stack Exchange from your Oracle system.
-
Automated Continuous Timely Replication to Oracle
Use CData Sync for automated, continuous, customizable Timely replication to Oracle.
-
Visualize SAP Fieldglass Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Fieldglass.
-
Getting Started with the CData SSIS Components for Jira Assets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jira Assets.
-
Connect to Todoist Data from a Connection Pool in Jetty
The Todoist JDBC Driver supports connection pooling: This article shows how to connect faster to Todoist from Web apps in Jetty.
-
Connect to Printify Data in DBArtisan
Use wizards in DBArtisan to configure Printify as a data source.
-
Know Your LLMs: Grok
An in-depth enterprise overview of xAI Grok models, covering architecture, multimodal intelligence, agentic tool use, benchmarks, security, and CData Connect AI integration.
-
Enable the Lakebase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Lakebase.
-
Visualize Live Microsoft Entra ID Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Entra ID using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Recurly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Recurly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Optimizely Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Optimizely in the Denodo Virtual DataPort Administrator.
-
Connect to Exact Online Data in JRuby
Create a simple JRuby app with access to live Exact Online.
-
Validate Databricks Data with QuerySurge
Access and validate Databricks in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to iContact Data in C++Builder
DataBind to iContact in C++Builder with standard components and controls.
-
How to Query Live Kintone Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Kintone data in natural language using Python.
-
Viewing eBay Data in RAD Studio Data Explorer
How to view eBay in RAD Studio Data Explorer using the CData ODBC Driver for eBay.
-
How to connect and process Acumatica ERP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Acumatica ERP.
-
Load Tavily Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tavily to a database.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy
Connect to ShipStation in MicroStrategy Developer using the CData Software JDBC Driver for ShipStation.
-
Create Informatica Mappings From/To an ODBC Data Source for Jumpseller
Create an ODBC connection to Jumpseller in Informatica and browse and transfer Jumpseller.
-
LINQ to iContact 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 iContact Data Provider.
-
Automate Timely Data Replication to SAP HANA
Use CData Sync to customize and automate Timely replication to SAP HANA.
-
Connect to Freshsales Data in DBeaver
Use the CData ODBC Driver to connect to Freshsales in DBeaver.
-
How to Connect to Rebilly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Rebilly. Leverage the pyodbc module for ODBC in Python.
-
Access Jumpseller Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jumpseller from HeidiSQL.
-
How to connect to SAP Data from Spring Boot
Connect to SAP in a Spring Boot Application using the CData JDBC Driver for SAP
-
Manage Chargebee Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Chargebee.
-
Explore Geographical Relationships in Copper Data with Power Map
Create data visualizations with Copper in Power Map.
-
Analyze Salesforce Marketing Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Marketing Cloud and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with Live Act-On Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Act-On from the MuleSoft Anypoint Platform to integrate live Act-On into custom reports and dashboards.
-
Use the CData Software ODBC Driver for Reckon in MicroStrategy
Connect to Reckon in MicroStrategy Developer using the CData Software ODBC Driver for Reckon.
-
How to connect to Google Sheets Data from IntelliJ
Integrate connectivity to Google Sheets with wizards in IntelliJ.
-
Build Voice Agents in ElevenLabs with access to Live SQL Analysis Services Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SQL Analysis Services.
-
Access Azure DevOps Data from MySQL in Amazon QuickSight
Connect to Azure DevOps and build visualizations of Azure DevOps using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Freshdesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshdesk replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy
Connect to MarkLogic in MicroStrategy Developer using the CData Software ODBC Driver for MarkLogic.
-
Build a Simple VCL Application for ZohoMarketingHub Data
How to build a simple VCL Application to view ZohoMarketingHub in RAD Studio using the CData ODBC Driver for ZohoMarketingHub.
-
Build Semantic Layer Views for Webex Data in APOS Live Data Gateway
Use the CData Connector for Webex in APOS Live Data Gateway to build Semantic Layer Views for Webex.
-
Consume Facebook Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Facebook Ads feeds that reflect any changes in SAP Lumira.
-
Enable the BambooHR JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with BambooHR.
-
Use the CData Software JDBC Driver for Teamgate in MicroStrategy Web
Connect to Teamgate in MicroStrategy Web using the CData Software JDBC Driver for Teamgate.
-
Import Real-Time Anaplan Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Anaplan in ColdFusion.
-
How to Connect Flowise AI Agents to Live Elasticsearch Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Elasticsearch without replication.
-
SingleStore Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SingleStore facts in real time.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Reckon Accounts Hosted to Power BI dashboards. Simply drag and drop Reckon Accounts Hosted into data visuals on the Power BI canvas.
-
Import and Visualize Presto Data in Power View
Create data visualizations based on Presto in Excel.
-
Access Live Splunk Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Splunk data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Theia IDE with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Using the CData Software ODBC Driver for Apollo in PyCharm
Connect to Apollo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apollo.
-
How to connect to ZohoPeople Data from Spring Boot
Connect to ZohoPeople in a Spring Boot Application using the CData API Driver for JDBC
-
Build Visualizations of Float Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Float in Birst.
-
Access Live SpaceX Data in Coginiti Pro
Connect to and query live SpaceX from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Redis-Connected Dashboards in Grafana
Connect to Redis Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Redis.
-
Query Live Box Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Box directly from the development environment.
-
Connect to SAP HANA Data in NetBeans
Connect to SAP HANA in NetBeans with the data source configuration wizard.
-
Access Live LinkedIn Data in AWS Lambda
Connect to live LinkedIn in AWS Lambda using the CData JDBC Driver.
-
Connecting Mastra with CouchDB 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 Apache CouchDB, no replication required.
-
Automated Continuous Pinterest Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pinterest replication to MongoDB.
-
How to Connect to Live Azure Data Lake Storage Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Azure Data Lake Storage for you.
-
Build MYOB AccountRight-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for MYOB AccountRight to explore live MYOB AccountRight Data in Gemini Code Assist to assist with building MYOB AccountRight-powered applications.
-
DataBind Controls to CapsuleCRM Data in C++Builder
DataBind to CapsuleCRM in C++Builder with standard components and controls.
-
Integrate Live Odoo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Odoo ERP and integrate live Odoo ERP into apps built in Microsoft Power Apps.
-
How to Seamlessly Import Freshteam Data into IBM SPSS Modeler
Integrate Freshteam data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Productboard Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Productboard from PowerShell? This article demonstrates how to utilize the Productboard Cmdlets for tasks like connecting to Productboard, automating operations, downloading data, and more.
-
Connect to BigQuery Data in Claris FileMaker Pro
Use the CData ODBC Driver for BigQuery in FileMaker Pro to connect to BigQuery and work with Google BigQuery in your FileMaker applications.
-
Build Voice Agents in ElevenLabs with access to Live Slack Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Slack.
-
Create Informatica Mappings From/To an ODBC Data Source for FTP
Create an ODBC connection to FTP in Informatica and browse and transfer FTP Servers.
-
Seamlessly Bring AlloyDB Data into Retool Using CData Connect AI
Integrate AlloyDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Kiro CLI with SendPulse 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.
-
Automated Continuous Discord Replication to Oracle
Use CData Sync for automated, continuous, customizable Discord replication to Oracle.
-
How to connect to Google Campaign Manager 360 Data in DBVisualizer
Integrate Google Campaign Manager 360 with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Crystal Reports on Retently Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Retently.
-
Replicate SAP Ariba Source Data to Multiple Databases
Replicate SAP Ariba Source to disparate databases with a point-and-click configuration.
-
Analyze AlloyDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AlloyDB from Power Pivot. You will use the Table Import Wizard to load Google AlloyDB. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SingleStore Data in HULFT Integrate
Connect to SingleStore as a JDBC data source in HULFT Integrate
-
Build Dashboards with SAP BusinessObjects BI Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI in Dundas BI.
-
Build Jodoo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Jodoo.
-
Use the CData Software ODBC Driver for OData in MicroStrategy Web
Connect to OData in MicroStrategy Web using the CData Software ODBC Driver for OData.
-
ETL Drip in Oracle Data Integrator
This article shows how to transfer Drip into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations Based On PostgreSQL Data in Mode
Use CData Connect AI to connect to PostgreSQL Data from Mode and build visualizations using live
-
Automated Vault CRM Data Replication to Teradata
Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Teradata.
-
How to Easily Query Auth0 Data in OpenOffice Base
Connect to Auth0 data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous SAP HANA Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP HANA replication to MongoDB.