CData Software - Knowledge Base
Recent Articles
-
How to Access Live BigCommerce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BigCommerce enables you to integrate BigCommerce into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate SAP Hybris C4C Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Hybris C4C in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Visualize Live Tavily Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tavily.
-
Validate Parallel Data with QuerySurge
Access and validate Parallel in QuerySurge using the CData JDBC Driver.
-
Build Highrise-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Highrise to explore live Highrise Data in Gemini Code Assist to assist with building Highrise-powered applications.
-
Connecting GenSpark with Authorize.Net Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Authorize.Net without any replication or custom integration required.
-
Using the CData Software ODBC Driver for OnePageCrm in PyCharm
Connect to OnePageCrm as an ODBC data source in PyCharm using the CData Software ODBC Driver for OnePageCrm.
-
Replicate Multiple Epicor Kinetic Accounts
Replicate multiple Epicor Kinetic accounts to one or many databases.
-
Reply.io Reporting in OBIEE with the Reply.io JDBC Driver
Deploy the Reply.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Building Dynamic Web Pages with Sybase Data Using AngularJS
Create single-page applications with live connectivity to Sybase using the CData API Server.
-
Create Power BI Reports on Real-Time Couchbase Data
Use the CData ODBC Driver for Couchbase to visualize Couchbase in Power BI Desktop.
-
Import Real-Time GetResponse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use GetResponse in ColdFusion.
-
Automated Continuous Active Directory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Active Directory replication to Snowflake.
-
Integrate Live Act CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize HDFS Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache HDFS.
-
Back Up Rebilly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Rebilly data.
-
Automated Continuous Oracle Eloqua Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Cassandra.
-
Migrating data from Mailjet to Snowflake using CData SSIS Components.
Easily push Mailjet to Snowflake using the CData SSIS Tasks for Mailjet and Snowflake.
-
Query Vimeo Data as a MySQL Database in Node.js
Execute MySQL queries against Vimeo from Node.js.
-
Visualize Live Instagram Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Instagram using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ShipStation within automated workflows.
-
How to Visualize ScrapingBee Data in Python with pandas
Use pandas and other modules to analyze and visualize live ScrapingBee in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure DevOps
Provide connectivity to Azure DevOps through an SAP BusinessObjects universe.
-
Moving Data from Optimizely to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Optimizely data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Act-On Data in Cognos Analytics
Use CData Connect AI to connect to Act-On Data from Cognos Analytics and analyze live Act-On.
-
Create Onfleet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Onfleet data access from reports, embedded analytics, and more.
-
Automated ClickTime Data Replication to Teradata
Use CData Sync to Customize and automate ClickTime replication to Teradata.
-
Use the CData SSIS Components to Insert New or Update Existing IBM Informix Records from SQL Server
Easily push SQL Server data to IBM Informix using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into IBM Informix or update existing records with data from a SQL Server database.
-
Use ChatGPT to Talk to Your Asana 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 Asana for you.
-
Add SparkPost Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SparkPost with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build MVC Applications with Connectivity to Procore Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Procore from an ASP.NET MVC application.
-
Publish Jira-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Atlassian Jira.
-
Connect to Oracle Data in Ruby
Connect to Oracle Database in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extract, Transform, and Load ChartMogul Data in Informatica PowerCenter
Create a simple Workflow for ChartMogul in Informatica PowerCenter.
-
Automated Continuous ZohoMarketingHub Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Vertica.
-
Integrating LangChain with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on OData within automated workflows.
-
View Reports on Real-Time Instagram Data in Power BI Report Server
Use the CData ODBC Driver for Instagram to visualize Instagram in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect DBeaver to Recurly via a JDBC Driver
Manage Recurly with visual tools in DBeaver like the query browser.
-
How to Easily Query Coinbase Data in OpenOffice Base
Connect to Coinbase data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Live CSV Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to CSV/TSV Files and integrate live CSV/TSV Files into apps built in Microsoft Power Apps.
-
Perform Batch Operations with Azure Synapse Data in Apache NiFi
Connect to Azure Synapse and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Printful Replication to SQL Server
Use CData Sync for automated, continuous, customizable Printful replication to SQL Server.
-
Connect to Oracle Eloqua Data in NetBeans
Connect to Oracle Eloqua in NetBeans with the data source configuration wizard.
-
How to create SAP HANA XS Advanced federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP HANA XS Advanced in MySQL .
-
Access Live GraphQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GraphQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Feed MarkLogic Data into FineReport
How to set MarkLogic as a JDBC data source in FineReport.
-
Excel Spreadsheet Automation on YouTube Analytics Data with the QUERY Formula
Pull data from YouTube Analytics, automate spreadsheets, and more with the QUERY formula.
-
How to Visualize EnterpriseDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live EnterpriseDB in Python.
-
Visualize Google Ad Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Google Ad Manager.
-
Connect to Omnisend Data from a Connection Pool in JBoss
Integrate Omnisend into Java servlets: Use the Management Console in JBoss to install the Omnisend JDBC Driver.
-
Connect to Hive Data in Jaspersoft Studio
Execute SQL to remote Apache Hive in Jaspersoft Studio.
-
Replicate Omnisend Data to Multiple Databases via the CData Sync CLI
Replicate Omnisend to disparate databases with a single configuration.
-
Visualize Exact Online Data in Sisense
Create an ElastiCube in Sisense app with access to Exact Online.
-
Build Charts with Dropbox Data in Clear Analytics
Create dynamic charts and perform analytics based on Dropbox in Clear Analytics.
-
How to Access Live Email Data in Visual Studio Code via Cline
Run CData MCP Server for Email on Windows Subsytem for Linux (WSL) and connect to live Email from the Cline extension in Visual Studio Code.
-
Enable the EnterpriseDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with EnterpriseDB.
-
Replicate Multiple Act CRM Accounts
Replicate multiple Act CRM accounts to one or many databases.
-
Migrating data from Toggl to Snowflake using CData SSIS Components.
Easily push Toggl to Snowflake using the CData SSIS Tasks for Toggl and Snowflake.
-
DataBind Elorus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Elorus to a chart.
-
Connect to Zoho Creator Data in RazorSQL
Connect to Zoho Creator from wizards and query Zoho Creator from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee in MicroStrategy Developer using the CData Software JDBC Driver for ScrapingBee.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Dynamics 365 Business Central to Power BI dashboards. Simply drag and drop Dynamics 365 Business Central into data visuals on the Power BI canvas.
-
Integrating Dataiku with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceNow.
-
Access Kafka 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 Apache Kafka.
-
Query Elasticsearch Data in DataGrip
Create a Data Source for Elasticsearch in DataGrip and use SQL to query live Elasticsearch.
-
Integrate Goose with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gmail from within the local AI agent.
-
Getting Started with the CData Power BI Connector for Freshteam
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to & Open Sentry Data in Microsoft Excel
This article uses the CData ODBC driver for Sentry to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to integrate Snapchat Ads with Apache Airflow
Access and process Snapchat Ads in Apache Airflow using the CData JDBC Driver.
-
ETL Wistia in Oracle Data Integrator
This article shows how to transfer Wistia into a data warehouse using Oracle Data Integrator.
-
Access Live Cosmos DB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Cosmos DB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Connect AI Python SDK for SendGrid
Install the CData Connect AI Python SDK to read and write live SendGrid with standard DB-API 2.0 Python code.
-
Integrate Live Oracle Financials Cloud Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Financials Cloud to Blue Prism using the CData ODBC Driver for Oracle Financials Cloud to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Desktop
Connect to Dynamics 365 Business Central in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Bidirectional Access to PhantomBuster Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PhantomBuster in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Superchat Data using Tableau Bridge
The CData ODBC Driver for Superchat enables you to integrate live Superchat into Tableau Cloud dashboards using the Tableau Bridge.
-
Build an OLAP Cube in SSAS from Twitter Ads Data
Establish a connection to Twitter Ads data from SQL Server Analysis Services, and use the Twitter Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import and Visualize Bullhorn CRM Data in Power View
Create data visualizations based on Bullhorn CRM in Excel.
-
Getting Started with the CData Power BI Connector for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Netweaver Gateway.
-
Easily Integrate ZohoDesk Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoDesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Klaviyo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Klaviyo replication to Google BigQuery.
-
Use the CData API Server to Access Google Directory Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Directory in the Power Pivot business intelligence tool.
-
Use the CData ODBC Driver for Workday from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Workday to connect to Workday from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Workday in Excel.
-
Access SAP HANA XS Advanced Data from MySQL in PHP
Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.
-
Connect to Aha! Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aha! and the SQL Gateway to access Aha! from Google Apps Script.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy
Connect to Redis in MicroStrategy Developer using the CData Software JDBC Driver for Redis.
-
Use JayDeBeApi to access ConvertKit Data in Python
Use standard Python scripting and the development environment of your choice to access live ConvertKit.
-
Integrating OpenCode Terminal with ZohoDesk 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 Live Jira Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Jira in CData Connect AI and connect to your Atlassian Jira from PostgreSQL.
-
Access Live Zendesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zendesk from your Excel spreadsheets.
-
Connect to FreshBooks in SpagoBI
Create reports featuring live FreshBooks in SpagoBI Studio. Host FreshBooks reports on SpagoBI Server.
-
Explore Geographical Relationships in MessageBird Data with Power Map
Create data visualizations with MessageBird in Power Map.
-
Connect to Google Drive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Drive in the Denodo Virtual DataPort Administrator.
-
Visualize Presto Data in Tableau
The CData ODBC driver for Presto enables you integrate Presto into Tableau dashboards.
-
Access Live Asana 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 Asana through MCP integration.
-
Trigger Blackbaud FE NXT IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Blackbaud FE NXT with standard wizards in Logic Apps.
-
How to connect and process Missive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Missive.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy Web
Connect to SpaceX in MicroStrategy Web using the CData Software JDBC Driver for SpaceX.
-
DataBind Controls to Egnyte Data in Delphi
DataBind to Egnyte in Delphi with standard data access components and controls.
-
Replicate Access Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Access to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.