CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to MySQL: Complete Guide
Connect to the CData Software Power BI Connector for MySQL from PowerBI.com to provide real-time MySQL across the organization.
-
Connecting Pipedream with HCL Domino Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on HCL Domino data in real time.
-
Access Blackbaud FE NXT 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 Blackbaud FE NXT.
-
Excel Spreadsheet Automation on Basecamp Data with the QUERY Formula
Pull data from Basecamp, automate spreadsheets, and more with the QUERY formula.
-
Connect to Confluence Data in NetBeans
Connect to Atlassian Confluence in NetBeans with the data source configuration wizard.
-
Create a Data Access Object for GraphQL Data using JDBI
A brief overview of creating a SQL Object API for GraphQL in JDBI.
-
Build Dashboards with PolarTeamPro Data in DBxtra
Create dynamic dashboards and perform analytics based on PolarTeamPro in DBxtra.
-
Getting Started with the CData JDBC Driver for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PDFMonkey.
-
Prepare, Blend, and Analyze Impala Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache Impala for self-service data analytics.
-
Access Live SAP ByDesign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business ByDesign in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for MailerSend in a Connection Pool in Tomcat
Connect to MailerSend from a connection pool in Tomcat.
-
Import Real-Time Google Contacts Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Contacts in ColdFusion.
-
Publish Reports with Humanity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Humanity.
-
Create Reports with ShipStation Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipStation.
-
Integrate ChartMogul Data in the Pentaho Report Designer
Publish reports based on ChartMogul in the Pentaho BI tool.
-
Getting Started with the CData Python Connector for Authorize.Net
Learn to install and license the CData Python Connector
-
Automated Continuous Amazon S3 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Google Cloud SQL.
-
How to create Visio diagrams from Google Ad Manager Data
Automatically update Google Ad Manager with the changes you make to Visio master shapes.
-
Explore Geographical Relationships in GetResponse Data with Power Map
Create data visualizations with GetResponse in Power Map.
-
Use the CData Software JDBC Driver for Reply.io in MicroStrategy
Connect to Reply.io in MicroStrategy Developer using the CData Software JDBC Driver for Reply.io.
-
Replicate SAP BusinessObjects BI Data to Multiple Databases via the CData Sync CLI
Replicate SAP BusinessObjects BI to disparate databases with a single configuration.
-
Deploy the ADO.NET Provider for Active Directory on an SSRS Report Server
Connect to Active Directory 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.
-
Connect to ConstantContact from Asprova with CData Software ODBC Driver for ConstantContact
This article shows how to connect faster to ConstantContact data from Asprova.
-
How to connect to Google Contacts Data from Spring Boot
Connect to Google Contacts in a Spring Boot Application using the CData JDBC Driver for Google Contacts
-
Moving Data from Google Search to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Search data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with SAP Netweaver Gateway Data in JReport Designer
Create charts and reports based on SAP Netweaver Gateway in JReport Designer.
-
Query Dropbox Data in DataGrip
Create a Data Source for Dropbox in DataGrip and use SQL to query live Dropbox.
-
How to work with JobNimbus Data in Apache Spark using SQL
Access and process JobNimbus Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with Drip Data
Access Drip as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build OneNote-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for OneNote to explore live OneNote Data in Gemini Code Assist to assist with building OneNote-powered applications.
-
How to Connect DBeaver to Elorus via a JDBC Driver
Manage Elorus with visual tools in DBeaver like the query browser.
-
Analyze Power BI XMLA Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Power BI XMLA from Power Pivot. You will use the Table Import Wizard to load Power BI XMLA. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Dataiku with SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft SharePoint.
-
Integrate Datadog Data in Pentaho Data Integration
Build ETL pipelines based on Datadog in the Pentaho Data Integration tool.
-
Replicate Jira Assets Data to Multiple Databases via the CData Sync CLI
Replicate Jira Assets to disparate databases with a single configuration.
-
Publish Reports with Perplexity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Perplexity.
-
How to connect and process Aweber from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Aweber.
-
Create a Data Access Object for Retently Data using JDBI
A brief overview of creating a SQL Object API for Retently in JDBI.
-
Connecting Mastra with Blackbaud FE NXT 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 Blackbaud FE NXT, no replication required.
-
Connect to Facebook Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Facebook Ads and the SQL Gateway to access Facebook Ads from Google Apps Script.
-
Build Apps with Live JSON in Adalo using CData Connect AI
Use CData Connect AI to integrate live JSON into the Adalo platform and build custom mobile and web applications with real-time JSON.
-
Import and Visualize Zoho Inventory Data in Power View
Create data visualizations based on Zoho Inventory in Excel.
-
Replicate Multiple Wrike Accounts
Replicate multiple Wrike accounts to one or many databases.
-
Integrate with Zoho Books Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Books in SnapLogic.
-
Build Data Flows from SQL Server to Google Sheets through SSIS
Easily push SQL Server data to Google Sheets using the CData SSIS Tasks for Google Sheets.
-
Integrate Goose with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Amazon Athena from within the local AI agent.
-
Analyze Deel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Deel in Microsoft R Open.
-
Connect to SAP Hybris C4C Data from AWS Glue
Use CData Connect AI to gain access to live SAP Hybris C4C from your AWS Glue jobs.
-
Connect to LDAP from a Connection Pool in WebLogic
Use the CData JDBC Driver for LDAP to connect to LDAP from Web applications running on WebLogic.
-
How to Connect to Live WooCommerce Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your WooCommerce for you.
-
Enable the Azure DevOps JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure DevOps.
-
How to update ActiveCampaign from Excel
This article explains how to transfer data from Excel to ActiveCampaign using the Excel Add-In for ActiveCampaign.
-
How to use SQLAlchemy ORM to access Pipedrive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pipedrive.
-
Automated Continuous CSV Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CSV replication to Amazon S3.
-
Connect to Live Vault CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Vault CRM in CData Connect AI and connect to your Veeva Vault & Vault CRM from PostgreSQL.
-
Use Dash to Build Web Apps on CouchDB Data via CData Connect AI
Build interactive Dash web apps on live Apache CouchDB using pandas and the CData Connect AI Python SDK.
-
Query Acumatica Data in DataGrip
Create a Data Source for Acumatica in DataGrip and use SQL to query live Acumatica ERP.
-
Import and Visualize PDFMonkey Data in Power View
Create data visualizations based on PDFMonkey in Excel.
-
Use the CData Software ODBC Driver for Flowlu in MicroStrategy Desktop
Connect to Flowlu in MicroStrategy Desktop using the CData Software ODBC Driver for Flowlu.
-
Connect to Oracle from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Database, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to ServiceNow Data from HeidiSQL
Use CData Connect AI to connect to and query live ServiceNow from HeidiSQL.
-
Create Dynamic CockroachDB Grids Using the Infragistics XamDataGrid
Learn how you can connect CockroachDB to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Aweber Accounts via the CData Sync CLI
Replicate multiple Aweber accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Commerce.
-
Visualize Suadeo Data in Sisense
Create an ElastiCube in Sisense app with access to Suadeo.
-
Integrating GitHub Copilot CLI with PabblySubscriptions 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.
-
Getting Started with the CData ADO.NET Provider for Presto
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Presto.
-
Build Charts with GitLab Data in Clear Analytics
Create dynamic charts and perform analytics based on GitLab in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time PDFMonkey Data
Use CData Power BI Connectors to visualize PDFMonkey in Power BI.
-
Replicate PDFMonkey Data from PowerShell
Write a quick PowerShell script to query PDFMonkey. Use connectivity to the live data to replicate PDFMonkey to SQL Server.
-
Create Power BI Reports on Real-Time Cloudant Data
Use the CData ODBC Driver for Cloudant to visualize IBM Cloudant in Power BI Desktop.
-
How to Connect DBeaver to Wistia via a JDBC Driver
Manage Wistia with visual tools in DBeaver like the query browser.
-
Consume RSS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on RSS feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple SAP Business One Accounts via the CData Sync CLI
Replicate multiple SAP Business One accounts to one or many databases.
-
Use Dash to Build to Web Apps on Microsoft Entra ID Data
Create Python applications that use pandas and Dash to build Microsoft Entra ID-connected web apps.
-
Create Power BI Reports on Real-Time Neo4J Data
Use the CData ODBC Driver for Neo4J to visualize Neo4J in Power BI Desktop.
-
Build TaxJar-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for TaxJar to explore live TaxJar Data in Gemini Code Assist to assist with building TaxJar-powered applications.
-
Visualize Live Google Cloud Storage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Cloud Storage.
-
Build FHIR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FHIR and build web apps with connectivity to live FHIR.
-
Integrate Open WebUI with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Veeva Vault & Vault CRM from within the chat interface.
-
Visualize Toggl Data in TIBCO Spotfire through ADO.NET
Integrate Toggl into dashboards in TIBCO Spotfire.
-
Integrate Asana with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Asana with External Services.
-
Connect to Live Microsoft Planner Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Planner in CData Connect AI and connect to your Microsoft Planner from PostgreSQL.
-
Integrating Boomi Agentstudio with SAP Hybris C4C Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Hybris C4C, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import and Visualize eBay Analytics Data in Power View
Create data visualizations based on eBay Analytics in Excel.
-
Visualize Office 365 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Office 365.
-
Access Live Oracle Eloqua Reporting Data in AWS Lambda
Connect to live Oracle Eloqua Reporting in AWS Lambda using the CData JDBC Driver.
-
How to integrate Autopilot with Apache Airflow
Access and process Autopilot in Apache Airflow using the CData JDBC Driver.
-
Build Oracle-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle to explore live Oracle Data in GitHub Copilot to assist with building Oracle-powered applications.
-
Integrating Kiro CLI with SurveyMonkey 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.
-
Use the CData Software ODBC Driver for Pipedrive in SAS for Real-Time Reporting and Analytics
Connect to real-time Pipedrive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pipedrive.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle SCM to Power BI dashboards. Simply drag and drop Oracle SCM into data visuals on the Power BI canvas.
-
Integrating Dataiku with Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Athena.
-
Integrating LangGraph with SAP Ariba Procurement Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Ariba Procurement within automated workflows.
-
DataBind Charts to Microsoft Entra ID Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Entra ID 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.
-
DataBind Charts to Close Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Close 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 the CData ODBC Driver for Avaza from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avaza to connect to Avaza from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Avaza in Excel.
-
Build Tally-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Tally ERP.
-
Connect to Parallel Data in RazorSQL
Connect to Parallel from wizards and query Parallel from the GUI in the RazorSQL database management tool.
-
Query Zoho Creator Data in DataGrip
Create a Data Source for Zoho Creator in DataGrip and use SQL to query live Zoho Creator.