CData Software - Knowledge Base
Recent Articles
-
Import Microsoft Teams Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Teams Data and provide access to live Microsoft Teams for custom reports in the Power BI Service.
-
Automated Continuous Klaviyo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Klaviyo replication to SingleStore.
-
Build Apps with Live Quaderno Data Using the Low-Code Development Platform of Mendix
Connect Quaderno with Mendix to build apps using the CData API Driver for JDBC.
-
Enable the Discord JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Discord.
-
Automated Continuous Zuora Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zuora replication to MongoDB.
-
Integrate with Oracle HCM Cloud Data in JReport Designer
Create charts and reports based on Oracle HCM Cloud in JReport Designer.
-
Establish a Live Connection with Adobe Analytics Data using Tableau Bridge
The CData ODBC Driver for Adobe Analytics enables you to integrate live Adobe Analytics into Tableau Cloud dashboards using the Tableau Bridge.
-
Provide OData Services of Salesloft Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesloft by developing a WCF Service Application.
-
How to Visualize Retently Data in Python with pandas
Use pandas and other modules to analyze and visualize live Retently in Python.
-
Use the CData ODBC Driver for Facebook from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Facebook to connect to Facebook from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Facebook in Excel.
-
Integrate Google Directory with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Directory with External Services.
-
Import HCL Domino Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to HCL Domino Data and provide access to live HCL Domino for custom reports in the Power BI Service.
-
Connect to Zoho Projects Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Projects from Filemaker Pro on Mac.
-
How to load Phoenix data into Elasticsearch via Logstash
Introducing a simple method to load Phoenix data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate BambooHR Data in the Pentaho Report Designer
Publish reports based on BambooHR in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Tanda in MicroStrategy Desktop
Connect to Tanda in MicroStrategy Desktop using the CData Software ODBC Driver for Tanda.
-
Connect to Jira Data in Ruby
Connect to Atlassian Jira in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query ChartMogul Data in ColdFusion
Write standard ColdFusion data access code to connect to ChartMogul.
-
Access Supabase Data from MySQL in Amazon QuickSight
Connect to Supabase and build visualizations of Supabase using a MySQL Connection in Amazon QuickSight.
-
Explore Geographical Relationships in Sybase Data with Power Map
Create data visualizations with Sybase in Power Map.
-
Validate Oracle Service Cloud Data with QuerySurge
Access and validate Oracle Service Cloud in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Cloudant in Microsoft Power Query
You can use the CData Cloudant ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Cloudant into Microsoft Power Query.
-
Build AI/ML Models with Live Wistia Data using Dataiku
Connect Wistia Data with Dataiku using the CData API Driver for JDBC.
-
Create Microsoft Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Qualaroo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Qualaroo to a chart.
-
Work with Sybase IQ Data in FoxPro
Load Sybase IQ into a FoxPro database. This article includes full code and a walk-through of the process.
-
Design BIRT Reports on SAP BusinessObjects BI Data
Provide current SAP BusinessObjects BI to your embedded analytics.
-
Integrate Live Paddle Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Paddle to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Bind Live SAP SuccessFactors Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP SuccessFactors data
-
How to Connect to Codat Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Codat. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Odoo ERP using the Model Context Protocol.
-
How to Connect to Live Cvent Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Cvent without replication.
-
Connect to Dropbox Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dropbox as an External Source in Dremio.
-
Build Dashboards with CouchDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache CouchDB in Dundas BI.
-
How to connect Amazon QuickSight to Reckon Accounts Hosted Data
Create a connection to Reckon Accounts Hosted in CData Connect AI and insert Reckon Accounts Hosted into Amazon QuickSight SPICE to build interactive dashboards.
-
Use ChatGPT to Talk to Your Dynamics 365 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 Microsoft Dynamics 365 for you.
-
Integrating Cursor CLI with CapsuleCRM 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 Informatica Mappings From/To a JDBC Data Source for Google Translate
Create Google Translate data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate SAP Hybris C4C Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Hybris C4C replication to Azure Data Lake.
-
Edit and Search eBay Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of eBay Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create eBay Analytics objects that you can access from apps and the dashboard.
-
Connect to PayPal Data in CloverDX (formerly CloverETL)
Transfer PayPal using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for ConvertAPI
Create an ODBC connection to ConvertAPI in Informatica and browse and transfer ConvertAPI.
-
Analyze RSS Feeds in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze RSS Feeds in Microsoft R Open.
-
Integrate Todoist with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Todoist with External Services.
-
Create ZohoMarketingHub Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoMarketingHub data access from reports, embedded analytics, and more.
-
Replicate Multiple Confluence Accounts
Replicate multiple Confluence accounts to one or many databases.
-
Integrate ClickTime with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickTime with External Services.
-
Getting Started with the CData Connect AI Python SDK for ServiceNow
Install the CData Connect AI Python SDK to read and write live ServiceNow with standard DB-API 2.0 Python code.
-
Access Salesforce Marketing Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce Marketing Cloud from your Oracle system.
-
Connect Epicor Kinetic to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Epicor Kinetic using the CData Python MCP Server.
-
Getting Started with the CData Excel Add-In for Omnisend
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Omnisend.
-
Connect to QuickBooks Online Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Online using standard SQL.
-
Migrating data from DB2 to Google BigQuery using CData SSIS Components.
Easily push IBM DB2 to Google BigQuery using the CData SSIS Tasks for DB2 and Google BigQuery.
-
Connect to Todoist Data in RazorSQL
Connect to Todoist from wizards and query Todoist from the GUI in the RazorSQL database management tool.
-
Rapidly Develop Mode-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 Mode.
-
Integrating Notion Data in Talend Cloud Data Management Platform
Connect Notion Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData ADO.NET Provider for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SuiteCRM.
-
Automated Continuous Datadog Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Datadog replication to IBM DB2.
-
Connect to HCL Domino Data in Claris FileMaker Pro
Use the CData ODBC Driver for HCL Domino in FileMaker Pro to connect to HCL Domino and work with HCL Domino in your FileMaker applications.
-
Work with Live Adobe Analytics Data in Power Query
Use CData Connect AI to connect to Adobe Analytics and work with live Adobe Analytics in Microsoft Power Query.
-
Query Instagram Data as a MySQL Database in Node.js
Execute MySQL queries against Instagram from Node.js.
-
Getting Started with the CData JDBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Recurly.
-
Access Live Workday Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Workday into the statistical analysis tools available in SAS JMP. This article shows how to use Workday in the Graph Builder and Query Builder.
-
Create WooCommerce-Connected Dashboards in Grafana
Connect to WooCommerce Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to WooCommerce.
-
Connect to Bitly Data in DBArtisan
Use wizards in DBArtisan to configure Bitly as a data source.
-
Create Dynamic Bannerbear Grids Using the Infragistics XamDataGrid
Learn how you can connect Bannerbear to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Pingdom Data in RazorSQL
Connect to Pingdom from wizards and query Pingdom from the GUI in the RazorSQL database management tool.
-
How to Access Live SAP Netweaver Gateway Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Netweaver Gateway enables you to integrate SAP Netweaver Gateway into workflows built using Microsoft Power Automate Desktop.
-
Integrate Wave Financial Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wave Financial from Informatica Cloud.
-
Access SendPulse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendPulse from HeidiSQL.
-
Create MailChimp-Connected Applications in Appsmith
Connect to MailChimp Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MailChimp.
-
Analyze Salesforce Data in Looker
Use CData Connect AI to connect to Salesforce Data from Looker and build custom apps using live Salesforce & Force.com.
-
Automated Oracle HCM Cloud Data Replication to Teradata
Use CData Sync to Customize and automate Oracle HCM Cloud replication to Teradata.
-
Enable the Landbot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Landbot.
-
Connect to ZohoMarketingHub Data in Jaspersoft Studio
Execute SQL to remote ZohoMarketingHub in Jaspersoft Studio.
-
Automated Continuous Autopilot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Autopilot replication to Apache Cassandra.
-
Query NetSuite Data in ColdFusion
Write standard ColdFusion data access code to connect to NetSuite CRM & ERP.
-
Query Intercom Data in ColdFusion
Write standard ColdFusion data access code to connect to Intercom.
-
Feed Mailjet Data into FineReport
How to set Mailjet as a JDBC data source in FineReport.
-
How to Query Live Egnyte Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Egnyte data in natural language using Python.
-
How to Build an ETL App for Attio Data in Python with CData
Create ETL applications and real-time data pipelines for Attio in Python with petl.
-
Build Automated Workflows with Live Acumatica Data in Workato
Use CData Connect AI to connect to live Acumatica ERP and build automated workflows in Workato.
-
Use Databricks Agent Bricks to Talk to Your Exact Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Exact Online for you.
-
Query Sage Intacct Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage Intacct.
-
Use JayDeBeApi to access Missive Data in Python
Use standard Python scripting and the development environment of your choice to access live Missive.
-
Access Simplesat Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Simplesat from HeidiSQL.
-
Automate Shippo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shippo replication to Azure Data Lake.
-
Automate PingOne Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live PingOne and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Facebook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Facebook replication to Amazon Redshift.
-
Access Live Gumroad Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gumroad into the statistical analysis tools available in SAS JMP. This article shows how to use Gumroad in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for Sybase IQ Data in APOS Live Data Gateway
Use the CData Connector for Sybase IQ in APOS Live Data Gateway to build Semantic Layer Views for Sybase IQ.
-
Build Semantic Layer Views for AlloyDB Data in APOS Live Data Gateway
Use the CData Connector for AlloyDB in APOS Live Data Gateway to build Semantic Layer Views for Google AlloyDB.
-
How to Build an ETL App for Reply.io Data in Python with CData
Create ETL applications and real-time data pipelines for Reply.io in Python with petl.
-
Use Grok to Talk to Your Salesforce 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 Salesforce & Force.com for you.
-
Build AI/ML Models with Live Coda Data using Dataiku
Connect Coda Data with Dataiku using the CData API Driver for JDBC.
-
How to Visualize Mouseflow Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mouseflow in Python.
-
Enable the Attio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Attio.
-
Back Up Nuclia 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 Nuclia data.
-
Automated Continuous Zoho Inventory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Amazon S3.
-
Use the CData Software JDBC Driver for Short.io in MicroStrategy Web
Connect to Short.io in MicroStrategy Web using the CData Software JDBC Driver for Short.io.