CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for SingleStore Data using JDBI
A brief overview of creating a SQL Object API for SingleStore in JDBI.
-
Integrating GitHub Copilot CLI with Marketo 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 Impala to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Impala with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from CampaignMonitor in Domo Workbench and Build Visualizations of CampaignMonitor Data in Domo
Use the CData Software ODBC Driver for CampaignMonitor to create datasets from CampaignMonitor in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy Desktop
Connect to ClickTime in MicroStrategy Desktop using the CData Software ODBC Driver for ClickTime.
-
How to connect to Bitbucket Data with Squirrel SQL client
Connect to Bitbucket and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Python Connector for MailerSend
Learn to install and license the CData Python Connector
-
Integrate CouchDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache CouchDB and integrate live Apache CouchDB into your Power Automate tasks.
-
Build Charts with ClickUp Data in Clear Analytics
Create dynamic charts and perform analytics based on ClickUp in Clear Analytics.
-
Integrate Flowlu Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Flowlu from Informatica Cloud.
-
Connect to SendInBlue Data from PowerBuilder via JDBC
This article demonstrates how to access SendInBlue from PowerBuilder using the SendInBlue JDBC Driver.
-
Create Data Visualizations in Cognos BI with Dynamics CRM Data
Access Microsoft Dynamics CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Live SingleStore 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 SingleStore directly from the development environment.
-
Build Data Flows from Zoho Inventory to SQL Server using SSIS
Easily back up Zoho Inventory to SQL Server using the SSIS components for Zoho Inventory.
-
Access BigQuery Data from MySQL in PHP
Connect to BigQuery through the standard MySQL libraries in PHP.
-
Connect to Webflow Data in CloverDX (formerly CloverETL)
Transfer Webflow using the visual workflow in the CloverDX data integration tool.
-
Visualize Omnisend Data in Tableau
The CData ODBC driver for Omnisend enables you integrate Omnisend into Tableau dashboards.
-
Automated Epicor Kinetic Data Replication to Teradata
Use CData Sync to Customize and automate Epicor Kinetic replication to Teradata.
-
Process & Analyze Greenhouse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Greenhouse Data.
-
How to Connect to Live Azure DevOps 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 Azure DevOps without replication.
-
Create Dynamic Typeform Grids Using the Infragistics XamDataGrid
Learn how you can connect Typeform to Infragistics XamDataGrid to build dynamic grids.
-
Create QuickBooks Time Dataflows on PowerBI.com
Connect to the CData Power BI Connector for QuickBooks Time from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Power BI Reports on Real-Time Simplesat Data
Use the CData ODBC Driver for Simplesat to visualize Simplesat in Power BI Desktop.
-
Visualize Salesforce Data 360 Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce Data 360 into dashboards in TIBCO Spotfire.
-
Automated Continuous Sage Intacct Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage Intacct replication to OneLake in Microsoft Fabric.
-
Bidirectional Access to Microsoft OneDrive Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft OneDrive in Filemaker Pro for Mac or Windows.
-
Connect to Amplitude Data in RazorSQL
Connect to Amplitude from wizards and query Amplitude from the GUI in the RazorSQL database management tool.
-
Connect to Zoho Recruit Data in Ruby
Connect to Zoho Recruit in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect and process Power BI XMLA from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Power BI XMLA.
-
Build Apps with Live Spark Data Using the Low-Code Development Platform of Mendix
Connect Apache Spark SQL with Mendix to build apps using the CData JDBC Driver for Spark.
-
Connect to ZohoDesk Data in CloverDX (formerly CloverETL)
Transfer ZohoDesk using the visual workflow in the CloverDX data integration tool.
-
Visualize Kafka Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Kafka.
-
Integrating Claude Code with SAP HANA Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP HANA within assisted coding and automated development workflows.
-
Integrating GitHub Copilot CLI with Databricks 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.
-
Build BambooHR-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BambooHR.
-
Visualize Avaza Data in Sisense
Create an ElastiCube in Sisense app with access to Avaza.
-
Access Live SendInBlue Data in AWS Lambda
Connect to live SendInBlue in AWS Lambda using the CData JDBC Driver.
-
Query Pipedrive Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Pipedrive and perform CRUD operations on Pipedrive from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendGrid
Provide connectivity to SendGrid through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze Foursquare Data in Alteryx Designer (ODBC)
Build workflows to access live Foursquare for self-service data analytics.
-
How to connect PolyBase to Testmonitor
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Testmonitor.
-
Access Live Jira Assets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Jira Assets from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Workable Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Workable.
-
Create a Data Access Object for AlloyDB Data using JDBI
A brief overview of creating a SQL Object API for Google AlloyDB in JDBI.
-
Integrate Databricks Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Databricks and integrate live Databricks into your Power Automate tasks.
-
How to connect and process Oracle Service Cloud from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Service Cloud.
-
Query Monday.com Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Monday.com entities in PHP by modeling them as objects.
-
Connect to Zuora Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zuora to connect to Zuora and execute queries in PowerBuilder.
-
Automated Continuous Neo4J Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Neo4J replication to PostgreSQL.
-
Visualize Optimizely Data in TIBCO Spotfire through ADO.NET
Integrate Optimizely into dashboards in TIBCO Spotfire.
-
Integrate Live VWO Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live VWO to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate Intercom Data from PowerShell
Write a quick PowerShell script to query Intercom. Use connectivity to the live data to replicate Intercom to SQL Server.
-
Deploy the ADO.NET Provider for SendInBlue on an SSRS Report Server
Connect to SendInBlue 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.
-
How to Create Power BI Visual Reports with Real-Time RabbitMQ Data
Use CData Power BI Connectors to visualize RabbitMQ in Power BI.
-
Analyze Spark Data in Looker
Use CData Connect AI to connect to Spark Data from Looker and build custom apps using live Apache Spark SQL.
-
Create Datasets from SAS Data Sets in Domo Workbench and Build Visualizations of SAS Data Sets Data in Domo
Use the CData Software ODBC Driver for SAS Data Sets to create datasets from SAS Data Sets in Domo Workbench and then build visualizations in the Domo service.
-
Connect to CSV Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CSV/TSV Files using standard SQL.
-
Use Claude to Talk to Your Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your IBM Cloudant for you.
-
Natively Connect to ConvertAPI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConvertAPI. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Python Connector for ServiceDesk Plus
Learn to install and license the CData Python Connector
-
How to Access Live Freshsales Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshsales enables you to integrate Freshsales into workflows built using Microsoft Power Automate Desktop.
-
Query ScrapingBee Data as a MySQL Database in Node.js
Execute MySQL queries against ScrapingBee from Node.js.
-
Integrating Claude Code CLI with Stack Exchange 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.
-
How to Seamlessly Import Excel Online Data into IBM SPSS Modeler
Integrate Excel Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to work with BenchmarkEmail Data in Apache Spark using SQL
Access and process BenchmarkEmail Data in Apache Spark using the CData Software JDBC Driver.
-
Connect HBase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache HBase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create IBM Cloud Object Storage-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Klipfolio and build custom visualizations using live IBM Cloud Object Storage.
-
Model Zoho Creator Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Creator, enabling the direct import of real-time Zoho Creator.
-
Integrate Todoist with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Todoist with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Todoist.
-
How to connect SharePoint with Cloudant Data through external lists
Provide IBM Cloudant to SharePoint users as an external list.
-
Automated Continuous XML Replication to Amazon S3
Use CData Sync for automated, continuous, customizable XML replication to Amazon S3.
-
Integrate Live Google Campaign Manager 360 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Campaign Manager 360 to Blue Prism using the CData ODBC Driver for Google Campaign Manager 360 to create automated workflows for repetitive business tasks.
-
Automate Blackbaud FE NXT Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Blackbaud FE NXT from PowerShell? This article demonstrates how to utilize the Blackbaud FE NXT Cmdlets for tasks like connecting to Blackbaud FE NXT, automating operations, downloading data, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Calendar using the Model Context Protocol.
-
Connect to Azure DevOps in SpagoBI
Create reports featuring live Azure DevOps in SpagoBI Studio. Host Azure DevOps reports on SpagoBI Server.
-
Use the CData ODBC Driver for Campaigner in Microsoft Power Query
You can use the CData Campaigner ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Campaigner into Microsoft Power Query.
-
Integrate Amazon S3 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon S3 and integrate live Amazon S3 into your Power Automate tasks.
-
Query, Visualize, and Share live Impala Data in Redash
Use CData Connect AI to connect to live Apache Impala in Redash for querying, visualizing, and sharing.
-
How to connect and process Veeva Vault & Vault CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Veeva Vault & Vault CRM.
-
Getting Started with the CData ADO.NET Provider for Shopify
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Shopify.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Web
Connect to Google Campaign Manager 360 in MicroStrategy Web using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Publish Google Sheets-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Sheets.
-
Access Bannerbear 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 Bannerbear.
-
Automated Continuous Wave Financial Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Wave Financial replication to Google BigQuery.
-
How to Visualize FormSite Data in Python with pandas
Use pandas and other modules to analyze and visualize live FormSite in Python.
-
Query Exa Data in DataGrip
Create a Data Source for Exa in DataGrip and use SQL to query live Exa.
-
Build Azure Data Lake Storage Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Data Lake Storage and build visualizations in Tableau Cloud.
-
Connect to PivotalTracker in SpagoBI
Create reports featuring live PivotalTracker in SpagoBI Studio. Host PivotalTracker reports on SpagoBI Server.
-
How to Build an ETL App for Microsoft Dataverse Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dataverse (CDS) in Python with petl.
-
Validate SAP Ariba Source Data with QuerySurge
Access and validate SAP Ariba Source in QuerySurge using the CData JDBC Driver.
-
Integrate with Act-On Data in JReport Designer
Create charts and reports based on Act-On in JReport Designer.
-
Import Oracle Service Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Service Cloud Data from Azure Data Factory and import live Oracle Service Cloud.
-
Build Charts with Microsoft Teams Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Teams in Clear Analytics.
-
Access Live Oracle HCM Cloud Data in AWS Lambda
Connect to live Oracle HCM Cloud in AWS Lambda using the CData JDBC Driver.
-
Access Sybase IQ Data from MySQL in PHP
Connect to Sybase IQ through the standard MySQL libraries in PHP.
-
Back Up Google Forms 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 Google Forms data.
-
Visualize Google Cloud Storage Data in Tableau
The CData ODBC driver for Google Cloud Storage enables you integrate Google Cloud Storage into Tableau dashboards.
-
How to import TaxJar Data into Apache Solr
Use the CData Software JDBC Driver for TaxJar in Data Import Handler and create an automated import of TaxJar to Apache Solr Enterprise Search platform.
-
How to use SQLAlchemy ORM to access Microsoft Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Ads.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live LinkedIn Ads using the Model Context Protocol.