CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Power BI Connector for Cloudant
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Cloudant.
-
Deploy the ADO.NET Provider for DB2 on an SSRS Report Server
Connect to IBM DB2 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.
-
Create Monday.com-Connected Business Apps in AppSheet
Connect to Monday.com Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Monday.com.
-
Connect to Active Directory Data from PowerBuilder via ADO.NET
This article demonstrates how to access Active Directory from Appeon PowerBuilder using the CData ADO.NET Provider for Active Directory.
-
Getting Started with the CData Connect AI Python SDK for API
Install the CData Connect AI Python SDK to read and write live API with standard DB-API 2.0 Python code.
-
Access Live YouTube Analytics Data in Excel 365 Online (Excel for the web)
Connect to YouTube Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Back Up ServiceNow to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ServiceNow. In this article, we will employ an SSIS workflow to populate a database with ServiceNow data.
-
Analyze Harvest Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Harvest from Power Pivot. You will use the Table Import Wizard to load Harvest. You can visually build the import query or use any SQL supported by the driver.
-
Bridge MarkLogic Connectivity with Apache NiFi
Access and process MarkLogic in Apache NiFi using the CData JDBC Driver.
-
Integrate Live Neo4J Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Neo4J from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Neo4J.
-
Integrating GitHub Copilot CLI with Billsby 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.
-
Import Real-Time Close Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Close in ColdFusion.
-
Migrating data from BigQuery to Databricks using CData SSIS Components.
Easily push Google BigQuery to Databricks using the CData SSIS Tasks for BigQuery and Databricks.
-
Use Databricks Agent Bricks to Talk to Your Procore Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Procore for you.
-
Connect to Outlook Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outlook as an External Source in Dremio.
-
Deploy the ADO.NET Provider for Google Ad Manager on an SSRS Report Server
Connect to Google Ad Manager 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.
-
Use JayDeBeApi to access MariaDB Data in Python
Use standard Python scripting and the development environment of your choice to access live MariaDB.
-
Build Data Flows from Printify to SQL Server using SSIS
Easily back up Printify to SQL Server using the SSIS components for Printify.
-
Use Dash to Build to Web Apps on Typeform Data
Create Python applications that use pandas and Dash to build Typeform-connected web apps.
-
Getting Started with the CData Tableau Connector for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Business Warehouse.
-
Automated Continuous Pipeliner CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SQL Server.
-
How to connect PolyBase to Webflow
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Webflow.
-
Build PayPal-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PayPal and build PayPal-connected web apps with Axios.
-
Access Couchbase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Couchbase from your Oracle system.
-
Use Manus AI to Talk to Your Workday 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 Workday.
-
Automated Continuous EnterpriseDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to PostgreSQL.
-
Replicate Opsgenie Data in Heroku for Use in Salesforce Connect
Replicate Opsgenie to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Reports from MariaDB Data in Looker Studio
Use CData Connect AI to gain access to live MariaDB and create custom reports in Looker Studio.
-
How to create an RPA flow for Adobe Experience Manager Data in UiPath Studio
Use the Adobe Experience Manager ODBC Driver to create workflows that access real-time Adobe Experience Manager without any coding.
-
Analyze Databricks Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Databricks and visualize Databricks in SAP Analytics Cloud.
-
Configure the CData JDBC Driver for Zoho CRM in a Connection Pool in Tomcat
Connect to Zoho CRM from a connection pool in Tomcat.
-
Automate Phoenix Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Phoenix and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Real-Time Tavily Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tavily in Power Apps.
-
Build an OLAP Cube in SSAS from Cvent Data
Establish a connection to Cvent data from SQL Server Analysis Services, and use the Cvent Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Microsoft Dataverse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Dataverse Data from OutSystems and build custom enterprise apps using live Microsoft Dataverse (CDS).
-
Automated Continuous Zoho Books Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Books replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Oracle SCM in MicroStrategy Web
Connect to Oracle SCM in MicroStrategy Web using the CData Software ODBC Driver for Oracle SCM.
-
Automated Continuous Exa Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exa replication to SQL Server.
-
How to publish and share Zoho Books Data dashboards with Tableau Server
The CData ODBC driver for Zoho Books enables you integrate Zoho Books into Tableau dashboards.
-
Connect to Zoho Recruit in SpagoBI
Create reports featuring live Zoho Recruit in SpagoBI Studio. Host Zoho Recruit reports on SpagoBI Server.
-
How to Visualize Samanage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Samanage in Python.
-
Connect to Amazon DynamoDB from Asprova with CData Software ODBC Driver for Amazon DynamoDB
This article shows how to connect faster to Amazon DynamoDB data from Asprova.
-
How to Work with ClickUp Data in AWS Glue Jobs Using JDBC
Connect to ClickUp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI/ML Models with Live PhantomBuster Data using Dataiku
Connect PhantomBuster Data with Dataiku using the CData API Driver for JDBC.
-
Use Manus AI to Talk to Your HCL Domino 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 HCL Domino.
-
Connect to Live Cloudant Data in MicroStrategy through CData Connect AI
Create a live connection to Cloudant Data in CData Connect AI and connect to your IBM Cloudant from MicroStrategy.
-
Analyze Live WooCommerce Data in SAS Viya
Use CData Connect AI to connect to WooCommerce from SAS Viya and deploy self-service analytics using live WooCommerce.
-
How to Easily Query BambooHR Data in OpenOffice Base
Connect to BambooHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Rapidly Develop Productboard-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 Productboard.
-
Integrate with Bitbucket Data in JReport Designer
Create charts and reports based on Bitbucket in JReport Designer.
-
DataBind Charts to JobNimbus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to JobNimbus 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.
-
ETL Superchat in Oracle Data Integrator
This article shows how to transfer Superchat into a data warehouse using Oracle Data Integrator.
-
How to Visualize Okta Data in Python with pandas
Use pandas and other modules to analyze and visualize live Okta in Python.
-
Connect to Access from Asprova with CData Software ODBC Driver for Access
This article shows how to connect faster to Access data from Asprova.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Desktop
Connect to Zoho Projects in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Projects.
-
Visualize Dynamics NAV Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dynamics NAV into dashboards in TIBCO Spotfire.
-
Natively Connect to Jira Assets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jira Assets. Leverage the native support for ODBC in PHP.
-
Connect to SAP from Asprova with CData Software ODBC Driver for SAP
This article shows how to connect faster to SAP data from Asprova.
-
How to Work with TaxJar Data in AWS Glue Jobs Using JDBC
Connect to TaxJar from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous XML Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable XML replication to Google BigQuery.
-
Replicate Multiple ZohoPeople Accounts
Replicate multiple ZohoPeople accounts to one or many databases.
-
Provide OData Services of ServiceDesk Plus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ServiceDesk Plus by developing a WCF Service Application.
-
Build Sugar CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sugar CRM to explore live Sugar CRM Data in Claude Code to assist with building Sugar CRM-powered applications.
-
Connect to and Query Google Ads Data in QlikView over ODBC
Create data visualizations with Google Ads in QlikView.
-
Connecting Mastra with Basecamp 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 Basecamp, no replication required.
-
Integrating LangChain with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Impala within automated workflows.
-
Integrating Codex CLI with Drift 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.
-
Use the CData API Server to Access PayPal Data in Microsoft PowerPivot
Use the CData API Server to connect to live PayPal in the Power Pivot business intelligence tool.
-
Import and Visualize Snowflake Data in Power View
Create data visualizations based on Snowflake in Excel.
-
Use Dash to Build to Web Apps on Neo4J Data
Create Python applications that use pandas and Dash to build Neo4J-connected web apps.
-
Viewing Microsoft Dataverse Data in RAD Studio Data Explorer
How to view Microsoft Dataverse (CDS) in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Dataverse.
-
Securing the CData API Server
This document shows how to secure connections from end-users to the API Server for your data source.
-
How to Work with Facebook Ads Data in ETL Validator JDBC
Connect to Facebook Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to QuickBooks Time Data in HULFT Integrate
Connect to QuickBooks Time as a JDBC data source in HULFT Integrate
-
Connect Google Spanner to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Spanner with IBM WebSphere for seamless data integration and connectivity.
-
ETL HubDB in Oracle Data Integrator
This article shows how to transfer HubDB into a data warehouse using Oracle Data Integrator.
-
Connect to Box Data in DBArtisan
Use wizards in DBArtisan to configure Box as a data source.
-
Connect to Bannerbear Data in Ruby
Connect to Bannerbear in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Landbot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Landbot.
-
Integrate Goose with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zuora from within the local AI agent.
-
Integrating Kiro CLI with ZendeskSell 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.
-
Migrating data from Klaviyo to Databricks using CData SSIS Components.
Easily push Klaviyo to Databricks using the CData SSIS Tasks for Klaviyo and Databricks.
-
Integrating OpenCode Terminal with Wave Financial 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.
-
Analyze SAP Business Warehouse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Business Warehouse with the CData JDBC Driver for SAP Business Warehouse.
-
Configure the CData JDBC Driver for Lakebase in a Connection Pool in Tomcat
Connect to Lakebase from a connection pool in Tomcat.
-
Use the CData ODBC Driver for Spark from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Spark to connect to Apache Spark SQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Spark SQL in Excel.
-
How to integrate Metabase with Monday.com Data
Use CData Connect AI to connect to live Monday.com and create an interactive dashboard in Metabase from Monday.com.
-
Viewing Yelp Data in RAD Studio Data Explorer
How to view Yelp in RAD Studio Data Explorer using the CData ODBC Driver for Yelp.
-
Build Pipelines with Live Salesforce Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce from Google Cloud Data Fusion, enabling the integration of live Salesforce & Force.com into the building and management of effective data pipelines.
-
Enable the Bitbucket JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bitbucket.
-
Migrating data from ConstantContact to Databricks using CData SSIS Components.
Easily push ConstantContact to Databricks using the CData SSIS Tasks for ConstantContact and Databricks.
-
Connect to Azure DevOps Data in RazorSQL
Connect to Azure DevOps from wizards and query Azure DevOps from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ADO.NET Provider for Google Forms
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Exact Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon S3.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SQL Analysis Services using the Model Context Protocol.
-
Replicate Presto Data to Multiple Databases via the CData Sync CLI
Replicate Presto to disparate databases with a single configuration.
-
Access Live Hubstaff Data in Coginiti Pro
Connect to and query live Hubstaff from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Salesloft Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesloft with the DevExpress Windows Forms and Web controls to provide Salesloft to a chart.
-
Integrating Claude Code CLI with OpenWeatherMap 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.
-
Access Live Stripe Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe from your Google Sheets.