CData Software - Knowledge Base
Recent Articles
-
Build AI Agents with Google Forms Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Forms data through CData Connect AI.
-
How to use SQLAlchemy ORM to access Google Cloud Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Cloud Storage data.
-
Automated Continuous Google Translate Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Translate replication to SingleStore.
-
Integrate Trae with Live Zoho CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zoho CRM data from within the AI-powered IDE.
-
How to Connect to Live WordPress Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your WordPress data for you.
-
Automated Continuous NetSuite SuiteAnalytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to AlloyDB.
-
Analyze Drip Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Drip data in Microsoft R Open.
-
Extract, Transform, and Load Paylocity Data in Informatica PowerCenter
Create a simple Workflow for Paylocity data in Informatica PowerCenter.
-
Create Dashboards and Visualize Live Dynamics 365 Business Central Data in Geckoboard
Use CData Connect AI to connect to live Dynamics 365 Business Central data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect to Amazon Marketplace Data with Squirrel SQL client
Connect to Amazon Marketplace data and execute queries in the Squirrel SQL Client.
-
How to create SAS Data Sets federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAS Data Sets data in MySQL .
-
Query Impala Data as a SQL Server Database in Node.js
Execute SQL Server queries against Impala data from Node.js.
-
Use the CData ODBC Driver for Cohere in Microsoft Power Query
You can use the CData Cohere ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cohere data into Microsoft Power Query.
-
Query XML Data as a MySQL Database in Node.js
Execute MySQL queries against XML data from Node.js.
-
Load ChargeOver Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ChargeOver data to a database.
-
Bridge Nuclia Connectivity with Apache NiFi
Access and process Nuclia data in Apache NiFi using the CData JDBC Driver.
-
Create SSAS Tabular Models from Google Analytics Data
How to build a SQL Server Analysis Service Tabular Model from Google Analytics data using CData drivers.
-
Access Live Sendwithus Data in Coginiti Pro
Connect to and query live Sendwithus data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access Rootly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Rootly data.
-
Create AfterShip Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AfterShip from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Informatica Mappings From/To a JDBC Data Source for Kafka
Create Kafka data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Neo4J Data from HeidiSQL
Use CData Connect AI to connect to and query live Neo4J data from HeidiSQL.
-
How to publish and share Freshsales Data dashboards with Tableau Server
The CData ODBC driver for Freshsales enables you integrate Freshsales data into Tableau dashboards.
-
Automate Tickspot Data Replication to Azure Data Lake
Use CData Sync to customize and automate Tickspot data replication to Azure Data Lake.
-
Automated Continuous eBay Replication to Amazon S3
Use CData Sync for automated, continuous, customizable eBay replication to Amazon S3.
-
Analyze Printify Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Printify data and visualize Printify data in SAP Analytics Cloud.
-
DataBind Charts to SpaceX Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SpaceX data 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Ontraport
Create an ODBC connection to Ontraport in Informatica and browse and transfer Ontraport data.
-
Validate Salesloft Data with QuerySurge
Access and validate Salesloft data in QuerySurge using the CData JDBC Driver.
-
How to Access Redis Data Using Entity Framework
This article shows how to access Redis data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze CloudConvert Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CloudConvert from Power Pivot. You will use the Table Import Wizard to load CloudConvert data. You can visually build the import query or use any SQL supported by the driver.
-
Create Reports with FHIR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FHIR data.
-
Connect to Active Directory Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Active Directory Data and connect to Active Directory data in Akorbi Digital RunMyProcess.
-
Connect and Visualize Live QuickBooks Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks data into the Databricks platform and create visualization dashboards with real-time QuickBooks data.
-
Create Data Visualizations Based On HDFS Data in Mode
Use CData Connect AI to connect to HDFS Data from Mode and build visualizations using live HDFS data.
-
Access Figshare Data from MySQL in Amazon QuickSight
Connect to Figshare and build visualizations of Figshare data using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build to Web Apps on Invoiced Data
Create Python applications that use pandas and Dash to build Invoiced-connected web apps.
-
Link ZohoDesk with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoDesk data in Filemaker Pro for Mac or Windows.
-
Create a Data Access Object for Bugsnag Data using JDBI
A brief overview of creating a SQL Object API for Bugsnag data in JDBI.
-
How to connect and process Databricks data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Databricks data.
-
Connect to Adobe Analytics Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Analytics data.
-
Build Voice Agents in ElevenLabs with access to Live Bitbucket Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Bitbucket data.
-
Integrate Real-Time Access to CouchDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CouchDB data in real time.
-
Build Dashboards with Accelo Data in DBxtra
Create dynamic dashboards and perform analytics based on Accelo data in DBxtra.
-
How to connect to MySQL Data in DBVisualizer
Integrate MySQL data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Active Directory Replication to Vertica
Use CData Sync for automated, continuous, customizable Active Directory replication to Vertica.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy Web
Connect to Oracle HCM Cloud data in MicroStrategy Web using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Connect to Authorize.Net Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Authorize.Net data using standard SQL.
-
Create Trello-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Trello Data from Klipfolio and build custom visualizations using live Trello data.
-
Integrating GitHub Copilot with Oracle Financials Cloud 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.
-
Connecting Pipedream with HubSpot 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 HubSpot data in real time.
-
Integrate Live Grafana Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Grafana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Grafana data.
-
Connect to Real-Time Superchat Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Superchat data in Power Apps.
-
Natively Connect to DB2 Data in PHP
The CData ODBC driver for DB2 enables you to create PHP applications with connectivity to DB2 data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for ADP in MicroStrategy Desktop
Connect to ADP data in MicroStrategy Desktop using the CData Software JDBC Driver for ADP.
-
How to connect SharePoint with LinkedIn Data through external lists
Provide LinkedIn data to SharePoint users as an external list.
-
Bridge Oracle Eloqua Reporting Connectivity with Apache NiFi
Access and process Oracle Eloqua Reporting data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Cassandra Replication to Oracle
Use CData Sync for automated, continuous, customizable Cassandra replication to Oracle.
-
Create SuiteCRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SuiteCRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Close Data in Jaspersoft Studio
Execute SQL to remote Close data in Jaspersoft Studio.
-
Connect to Databricks Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Databricks data in Airbyte.
-
Build Semantic Layer Views for Dynamics 365 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 data.
-
Import and Visualize Miro Data in Power View
Create data visualizations based on Miro data in Excel.
-
Integrate Google Drive Data in Pentaho Data Integration
Build ETL pipelines based on Google Drive data in the Pentaho Data Integration tool.
-
Build Square Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Square data and build visualizations in Tableau Cloud.
-
Integrate Gong with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gong with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gong data.
-
Build Data Flows from SQL Server to Certinia through SSIS
Easily push SQL Server data to Certinia using the CData SSIS Tasks for Certinia.
-
Query ZohoInvoice Data in DataGrip
Create a Data Source for ZohoInvoice in DataGrip and use SQL to query live ZohoInvoice data.
-
Build Data Flows from Splunk to SQL Server using SSIS
Easily back up Splunk data to SQL Server using the SSIS components for Splunk.
-
Integrating Codex with Avalara AvaTax 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.
-
Import SAS Data Sets Data Using Azure Data Factory
Use CData Connect AI to connect to SAS Data Sets Data from Azure Data Factory and import live SAS Data Sets data.
-
Connect to ZendeskSell Data in DBeaver
Use the CData ODBC Driver to connect to ZendeskSell data in DBeaver.
-
Easily Integrate SAS Data Sets Data in Lazarus Pascal IDE
Learn how to easily integrate live SAS Data Sets data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Confluence Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Confluence from Power Pivot. You will use the Table Import Wizard to load Confluence data. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Multiple Float Accounts
Replicate multiple Float accounts to one or many databases.
-
Integrate Real-Time Access to Zoho Projects in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Projects data in real time.
-
Analyze Zoom Data in Looker
Use CData Connect AI to connect to Zoom Data from Looker and build custom apps using live Zoom data.
-
Explore Geographical Relationships in eBay Data with Power Map
Create data visualizations with eBay data in Power Map.
-
Create PolarTeamPro Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PolarTeamPro from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query XML Data through ODBC in Node.js
Use node-odbc to execute SQL queries against XML data from Node.js.
-
Integrating GitHub Copilot with Microsoft 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.
-
Azure DevOps Reporting in OBIEE with the Azure DevOps JDBC Driver
Deploy the Azure DevOps JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import and Visualize Google Analytics Data in Power View
Create data visualizations based on Google Analytics data in Excel.
-
Create AfterShip-Connected Dashboards in Grafana
Connect to AfterShip Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to AfterShip data.
-
Integrate Live Humanity Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Humanity data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automate Flowlu Data Replication to Couchbase
Use CData Sync to Customize and automate Flowlu data replication to Couchbase.
-
Use Microsoft Copilot Studio to talk to your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your DB2 data for you.
-
Create Data Visualizations in Cognos BI with Wave Financial Data
Access Wave Financial data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Charts with Smartsheet Data in Clear Analytics
Create dynamic charts and perform analytics based on Smartsheet data in Clear Analytics.
-
Create SSAS Tabular Models from Redis Data
How to build a SQL Server Analysis Service Tabular Model from Redis data using CData drivers.
-
Automated Continuous Gorgias Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Gorgias replication to PostgreSQL.
-
Use Azure AI Foundry to Talk to Your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Marketo data for you.
-
Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage Cloud Accounting data.
-
Getting Started with the CData Excel Add-In for Optimizely
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Optimizely.
-
Migrating data from Klaviyo to Google BigQuery using CData SSIS Components.
Easily push Klaviyo data to Google BigQuery using the CData SSIS Tasks for Klaviyo and Google BigQuery.
-
Automate Amplitude Data Replication to Couchbase
Use CData Sync to Customize and automate Amplitude data replication to Couchbase.
-
Establish a Live Connection with Greenhouse Data using Tableau Bridge
The CData ODBC Driver for Greenhouse enables you to integrate live Greenhouse data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Google Analytics Data in JReport Designer
Create charts and reports based on Google Analytics data in JReport Designer.
-
Automated Continuous EmailOctopus Replication to MongoDB
Use CData Sync for automated, continuous, customizable EmailOctopus replication to MongoDB.
-
Create Dashboards and Visualize Live Reckon Data in Geckoboard
Use CData Connect AI to connect to live Reckon data and create dashboards for real-time monitoring and visualization in Geckoboard.