CData Software - Knowledge Base
Recent Articles
-
Back Up Databricks to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Databricks. In this article, we will employ an SSIS workflow to populate a database with Databricks data.
-
Migrating data from Adobe Target to Snowflake using CData SSIS Components.
Easily push Adobe Target to Snowflake using the CData SSIS Tasks for Adobe Target and Snowflake.
-
Integrate OneNote with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OneNote with External Services.
-
Create Email-Connected Nintex Workflows
Use CData Connect AI to connect to Email Data from Nintex Workflow Cloud and build custom workflows using live Email.
-
Replicate Multiple Greenhouse Accounts via the CData Sync CLI
Replicate multiple Greenhouse accounts to one or many databases.
-
How to update Salesloft from Excel
This article explains how to transfer data from Excel to Salesloft using the Excel Add-In for Salesloft.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy
Connect to MailChimp in MicroStrategy Developer using the CData Software ODBC Driver for MailChimp.
-
Access eBay Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access eBay from your Oracle system.
-
How to use SQLAlchemy ORM to access Auth0 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Auth0.
-
How to Connect DBeaver to Phoenix via a JDBC Driver
Manage Apache Phoenix with visual tools in DBeaver like the query browser.
-
Build Pipelines with Live Splunk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Splunk from Google Cloud Data Fusion, enabling the integration of live Splunk into the building and management of effective data pipelines.
-
Analyze SAP BusinessObjects BI Data in Cognos Analytics
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Cognos Analytics and analyze live SAP BusinessObjects BI.
-
Use JayDeBeApi to access Zoho Recruit Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Recruit.
-
Automated Continuous CockroachDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CockroachDB replication to delimited files (CSV/TSV).
-
Connect to Recurly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Recurly to connect to Recurly from Web applications running on WebLogic.
-
Integrate LibreChat with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SingleStore from within the chat interface.
-
How to Visualize Wistia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Wistia in Python.
-
How to Connect to Live JSON Services 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 JSON for you.
-
How to Access Live Elorus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Elorus enables you to integrate Elorus into workflows built using Microsoft Power Automate Desktop.
-
How to create an RPA flow for ZendeskSell Data in UiPath Studio
Use the ZendeskSell ODBC Driver to create workflows that access real-time ZendeskSell without any coding.
-
Integrate with Jira Assets Data in JReport Designer
Create charts and reports based on Jira Assets in JReport Designer.
-
Build Semantic Layer Views for Microsoft Planner Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Planner.
-
Query Live eBay 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 eBay directly from the development environment.
-
Getting Started with the CData Connect AI Python SDK for Avro
Install the CData Connect AI Python SDK to read and write live Apache Avro with standard DB-API 2.0 Python code.
-
Natively Connect to Jira Data in PHP
The CData ODBC driver for Jira enables you to create PHP applications with connectivity to Atlassian Jira. Leverage the native support for ODBC in PHP.
-
Import Real-Time GitLab Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GitLab in ColdFusion.
-
Integrate SAS xpt with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAS xpt with External Services.
-
Deploy the ADO.NET Provider for ElevenLabs on an SSRS Report Server
Connect to ElevenLabs from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Design BIRT Reports on Greenhouse Data
Provide current Greenhouse to your embedded analytics.
-
Use the CData Software JDBC Driver for Mistral AI in MicroStrategy Web
Connect to Mistral AI in MicroStrategy Web using the CData Software JDBC Driver for Mistral AI.
-
Connect to Gumroad Data in RapidMiner
Integrate Gumroad with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Desktop
Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software JDBC Driver for Acumatica.
-
Getting Started with the CData Python Connector for SQL Server
Learn to install and license the CData Python Connector
-
Automated Continuous Azure DevOps Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure DevOps replication to SQL Server.
-
Publish Hubstaff-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hubstaff.
-
Write a Simple Go Application to work with Aha! Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Aha!.
-
Using the CData Software ODBC Driver for Box in PyCharm
Connect to Box as an ODBC data source in PyCharm using the CData Software ODBC Driver for Box.
-
How to work with Yelp Data in Apache Spark using SQL
Access and process Yelp Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Email to Power BI dashboards. Simply drag and drop Email into data visuals on the Power BI canvas.
-
Automated Continuous Kintone Replication to MySQL
Use CData Sync for automated, continuous, customizable Kintone replication to MySQL.
-
Automate Accelo Data Replication to Couchbase
Use CData Sync to Customize and automate Accelo replication to Couchbase.
-
Create Informatica Mappings From/To a JDBC Data Source for Missive
Create Missive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Accelo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Accelo by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for MailChimp in MicroStrategy Web
Connect to MailChimp in MicroStrategy Web using the CData Software JDBC Driver for MailChimp.
-
Automated Continuous Acumatica Replication to Vertica
Use CData Sync for automated, continuous, customizable Acumatica replication to Vertica.
-
Connect to Datadog Data in RazorSQL
Connect to Datadog from wizards and query Datadog from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access Highrise Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Highrise CRM.
-
Visualize DB2 Data in TIBCO Spotfire through ADO.NET
Integrate IBM DB2 into dashboards in TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Dynamics 365 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics 365.
-
Analyze Zoho Books Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Books with the CData JDBC Driver for Zoho Books.
-
Integrating Cursor CLI with Calendly 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.
-
Integrating Boomi Agentstudio with Oracle Financials Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Financials Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Live OData Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live OData securely in real time.
-
Connect to Microsoft Planner Data in RazorSQL
Connect to Microsoft Planner from wizards and query Microsoft Planner from the GUI in the RazorSQL database management tool.
-
Feed ChartMogul Data into FineReport
How to set ChartMogul as a JDBC data source in FineReport.
-
Integrate Theia IDE with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Power BI Reports on Real-Time Salesloft Data
Use the CData ODBC Driver for Salesloft to visualize Salesloft in Power BI Desktop.
-
Integrating Antigravity CLI with Pinterest via CData CLI
Connect Pinterest to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
View Reports on Real-Time QuickBooks Data in Power BI Report Server
Use the CData ODBC Driver for QuickBooks to visualize QuickBooks Desktop in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for Pushbullet in MicroStrategy
Connect to Pushbullet in MicroStrategy Developer using the CData Software JDBC Driver for Pushbullet.
-
How to Seamlessly Import QuickBooks Time Data into IBM SPSS Modeler
Integrate QuickBooks Time data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Exact Online Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Exact Online and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate PabblySubscriptions Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PabblySubscriptions from Informatica Cloud.
-
How to Connect to Live FreshBooks 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 FreshBooks without replication.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy
Connect to VWO in MicroStrategy Developer using the CData Software ODBC Driver for VWO.
-
Integrate with Highrise Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Highrise CRM in SnapLogic.
-
Automated Continuous Pingdom Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pingdom replication to AlloyDB.
-
Replicate Multiple SAP Accounts via the CData Sync CLI
Replicate multiple SAP accounts to one or many databases.
-
Integrating Dataiku with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache Avro.
-
Manage Google Ad Manager Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Ad Manager.
-
Integrate Sage Intacct Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sage Intacct from Informatica Cloud.
-
Natively Connect to Microsoft Teams Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Teams. Leverage the native support for ODBC in PHP.
-
Automated Continuous Adobe Target Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Adobe Target replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for Aircall in PyCharm
Connect to Aircall as an ODBC data source in PyCharm using the CData Software ODBC Driver for Aircall.
-
Connect to EmailOctopus Data in Jaspersoft Studio
Execute SQL to remote EmailOctopus in Jaspersoft Studio.
-
Build Data Flows from Rootly to SQL Server using SSIS
Easily back up Rootly to SQL Server using the SSIS components for Rootly.
-
Import and Visualize Act-On Data in Power View
Create data visualizations based on Act-On in Excel.
-
Access Copper Data from MySQL in Amazon QuickSight
Connect to Copper and build visualizations of Copper using a MySQL Connection in Amazon QuickSight.
-
Visualize Jodoo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jodoo.
-
Access Live Google Analytics 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 Google Analytics through MCP integration.
-
Connect to and Query LightSpeedRetail Data in QlikView over ODBC
Create data visualizations with LightSpeedRetail in QlikView.
-
Connect to Productboard Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Productboard and work with Productboard in your FileMaker applications.
-
Use the CData API Server to Access SAS xpt Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAS XPORT in the Power Pivot business intelligence tool.
-
Enable the Paymo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Paymo.
-
Integrating Cursor CLI with Tavily 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.
-
Easily Integrate Mouseflow Data in Lazarus Pascal IDE
Learn how to easily integrate live Mouseflow in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Pipeline CRM in MicroStrategy Desktop
Connect to Pipeline CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Pipeline CRM.
-
How to connect to Suadeo Data with Squirrel SQL client
Connect to Suadeo and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on Grafana Data
Provide current Grafana to your embedded analytics.
-
Create Dynamic Blackbaud FE NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Blackbaud FE NXT to Infragistics XamDataGrid to build dynamic grids.
-
Access Live MongoDB Data in TIBCO Data Virtualization
Use the MongoDB Tibco DV Adapter to create a MongoDB data source in TIBCO Data Virtualization Studio and gain access to live MongoDB from your TDV Server.
-
DataBind Charts to Gumroad Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gumroad from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Biml to Build SSIS Tasks to Replicate Phoenix Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Phoenix to SQL Server.
-
Getting Started with the CData Excel Add-In for Mailgun
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mailgun.
-
How to Query IBM Cloud Object Storage Data in MySQL Workbench
Execute MySQL queries against live IBM Cloud Object Storage from MySQL Workbench.
-
Build XML-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for XML to explore live XML Data in GitHub Copilot to assist with building XML-powered applications.
-
Analyze Slack Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Slack from Power Pivot. You will use the Table Import Wizard to load Slack. You can visually build the import query or use any SQL supported by the driver.
-
Moving Data from Elorus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Elorus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Zoom Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoom and integrate live Zoom into your Power Automate tasks.
-
Build Visualizations of EnterpriseDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of EnterpriseDB in Birst.