CData Software - Knowledge Base
Recent Articles
-
Connect to SAP HANA XS Advanced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA XS Advanced data using standard SQL.
-
Create Microsoft Teams-Connected Dashboards in Grafana
Connect to Microsoft Teams Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Teams data.
-
Automated Continuous Databricks Replication to MySQL
Use CData Sync for automated, continuous, customizable Databricks replication to MySQL.
-
Automated Continuous Twilio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Twilio replication to Amazon Redshift.
-
How to Connect to Live Exa Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Exa data for you.
-
Automated Continuous Salesforce Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce replication to Vertica.
-
How to Connect Flowise AI Agents to Live PayPal Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live PayPal data without replication.
-
Use the CData Software JDBC Driver for Sage 200 in MicroStrategy Desktop
Connect to Sage 200 data in MicroStrategy Desktop using the CData Software JDBC Driver for Sage 200.
-
Build Semantic Layer Views for Salesloft Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesloft data.
-
Connect to GraphQL Data in Ruby
Connect to GraphQL data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect PolyBase to SageHR
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SageHR data.
-
Interact with Live Grafana Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Grafana data.
-
How to connect and process Bannerbear data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bannerbear data.
-
Using the CData Software ODBC Driver for SAP SuccessFactors LMS in PyCharm
Connect to SAP SuccessFactors LMS as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Operational Reporting on VWO Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote VWO data.
-
Build a Singer.io Tap for HBase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HBase data using the CData Python Connector.
-
How to create Oracle Eloqua Reporting federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Eloqua Reporting data in MySQL .
-
How to Query Live Excel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Excel data data in natural language using Python.
-
How to Access Live Postmark Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Postmark enables you to integrate Postmark data into workflows built using Microsoft Power Automate Desktop.
-
Automate Qualaroo Data Replication to Azure Synapse
Use CData Sync to customize and automate Qualaroo data replication to Azure Synapse.
-
Connect to Oracle HCM Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle HCM Cloud data as a data source.
-
How to Create Power BI Visual Reports with Real-Time Snowflake Data
Use CData Power BI Connectors to visualize Snowflake data in Power BI.
-
Query Live Grafana Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Grafana data through a conversational interface.
-
Create Adobe Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Analytics Data from Nintex Workflow Cloud and build custom workflows using live Adobe Analytics data.
-
Moving Data from Google Forms to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Forms data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Jodoo Data Replication to Teradata
Use CData Sync to Customize and automate Jodoo data replication to Teradata.
-
Build Automated DB2-Connected Workflows in Zapier
Use CData Connect AI to connect to live DB2 data and build automated workflows in Zapier.
-
View Reports on Real-Time Timely Data in Power BI Report Server
Use the CData ODBC Driver for Timely to visualize Timely data in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Google Cloud Storage Data from PowerShell
Write a quick PowerShell script to query Google Cloud Storage data. Use connectivity to the live data to replicate Google Cloud Storage data to SQL Server.
-
Migrating data from Gmail to Snowflake using CData SSIS Components.
Easily push Gmail data to Snowflake using the CData SSIS Tasks for Gmail and Snowflake.
-
Build Apps with Live Cloudant data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Cloudant data into the Adalo platform and build custom mobile and web applications with real-time Cloudant data.
-
Build AI/ML Models with Live Lakebase Data using Dataiku
Connect Lakebase Data with Dataiku using the CData JDBC Driver for Lakebase.
-
Connect to Hugging Face Data from PowerBuilder via JDBC
This article demonstrates how to access Hugging Face data from PowerBuilder using the Hugging Face JDBC Driver.
-
How to Easily Query GetResponse Data in OpenOffice Base
Connect to GetResponse data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy Desktop
Connect to Oracle Financials Cloud data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Financials Cloud.
-
Getting Started with the CData Tableau Connector for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Basecamp-Connected Business Apps in AppSheet
Connect to Basecamp Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Basecamp data.
-
Access Live AlloyDB Data in TIBCO Data Virtualization
Use the AlloyDB Tibco DV Adapter to create a AlloyDB data data source in TIBCO Data Virtualization Studio and gain access to live AlloyDB data from your TDV Server.
-
Connect to Live Google Spanner Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Spanner in CData Connect AI and connect to your Google Spanner data from PostgreSQL.
-
Integrating Claude Code CLI with Salesloft 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.
-
Connect eBay Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live eBay Analytics data using the CData Python MCP Server.
-
Automated Continuous Azure DevOps Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Azure SQL Database.
-
Connect to Adobe Experience Manager Data in ACL Analytics
Connect to Adobe Experience Manager data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Adobe Experience Manager data.
-
Automate Postmark Data Replication to SAP HANA
Use CData Sync to customize and automate Postmark data replication to SAP HANA.
-
Moving Data from Salesforce CRM Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce CRM Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Manage Square Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Square.
-
Automated Continuous FreeAgent Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable FreeAgent replication to PostgreSQL.
-
Create ZohoExpense Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoExpense from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Cohere-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cohere data.
-
Analyze Airtable Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Airtable data and visualize live Airtable data in Infragistics Reveal.
-
Connecting Moonlit Workflow with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Outreach.io data in real time.
-
Design BIRT Reports on MessageBird Data
Provide current MessageBird data to your embedded analytics.
-
Build an OLAP Cube in SSAS from Quickbase Data
Establish a connection to Quickbase data data from SQL Server Analysis Services, and use the Quickbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Workday Data in DataGrip
Create a Data Source for Workday in DataGrip and use SQL to query live Workday data.
-
Replicate Productboard Data to Multiple Databases
Replicate Productboard data to disparate databases with a point-and-click configuration.
-
Object-Relational Mapping (ORM) with Apollo Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apollo data into a Java-based ORM framework, Hibernate.
-
Integrate Cline with Live Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Forms data from within your IDE.
-
Publish Reports with Amazon S3 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon S3 data.
-
Build Sage Intacct-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage Intacct data.
-
Query Blackbaud FE NXT Data as a MySQL Database in Node.js
Execute MySQL queries against Blackbaud FE NXT data from Node.js.
-
Integrate Live API Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live API data from within the IDE.
-
Connect to Oracle Eloqua Reporting Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Eloqua Reporting data in the Denodo Virtual DataPort Administrator.
-
Automate Pipedrive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pipedrive data from PowerShell? This article demonstrates how to utilize the Pipedrive Cmdlets for tasks like connecting to Pipedrive data, automating operations, downloading data, and more.
-
A PostgreSQL Interface for SAP BusinessObjects BI Data using the CData ODBC Driver
Use the SQL Gateway and SAP BusinessObjects BI ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CSV Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CSV data.
-
How to Connect to Live BigCommerce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your BigCommerce data for you.
-
Connect to Live Shopify Data in MicroStrategy through CData Connect AI
Create a live connection to Shopify Data in CData Connect AI and connect to your Shopify data from MicroStrategy.
-
Integrating Codex with Supabase 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.
-
Build Google Spanner-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Spanner data and build web apps with connectivity to live Google Spanner data.
-
Prepare, Blend, and Analyze SAP Hybris C4C Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Hybris C4C data for self-service data analytics.
-
Integrating Claude Code with Mailjet Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Mailjet data within assisted coding and automated development workflows.
-
Connect to Klaviyo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Klaviyo in FileMaker Pro to connect to Klaviyo and work with Klaviyo data in your FileMaker applications.
-
Connect to Salesforce Pardot Data in Google Apps Script via Connect AI
Use CData Connect AI to access Salesforce Pardot data in Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for SQL Analysis Services
Create an ODBC connection to SQL Analysis Services in Informatica and browse and transfer SQL Analysis Services data.
-
Connect to Outlook Data in Ruby
Connect to Outlook data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData SSIS Components to Insert New or Update Existing Google Campaign Manager 360 Records from SQL Server
Easily push SQL Server data to Google Campaign Manager 360 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Campaign Manager 360 or update existing records with data from a SQL Server database.
-
Build a Simple VCL Application for Teamwork Data
How to build a simple VCL Application to view Teamwork data in RAD Studio using the CData ODBC Driver for Teamwork.
-
Build Dashboards with Box Data in Dundas BI
Create dynamic dashboards and perform analytics based on Box data in Dundas BI.
-
Use the CData Software JDBC Driver for Humanity in MicroStrategy Web
Connect to Humanity data in MicroStrategy Web using the CData Software JDBC Driver for Humanity.
-
Visualize Azure DevOps Data in TIBCO Spotfire through OData
Integrate Azure DevOps data into dashboards in TIBCO Spotfire.
-
Connect to PolarTeamPro Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with PolarTeamPro Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Grafana Data from Crystal Reports
Use CData Connect AI to connect to and report on live Grafana data from Crystal Reports.
-
How to create Klipfolio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Klipfolio data in MySQL .
-
Bind Live Microsoft Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to work with ConstantContact Data in Apache Spark using SQL
Access and process ConstantContact Data in Apache Spark using the CData Software JDBC Driver.
-
Access Guru 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 Guru data.
-
Connect to Browserless Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Browserless.
-
Connect to TaxJar Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for TaxJar data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous ZohoExpense Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoExpense replication to MongoDB.
-
How to Connect to Live Quickbase Data 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 Quickbase data for you.
-
Build ZohoInvoice-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ZohoInvoice Data and create custom apps in Bubble.
-
Replicate FTP Data from PowerShell
Write a quick PowerShell script to query FTP data. Use connectivity to the live data to replicate FTP data to SQL Server.
-
Access Live Blackbaud FE NXT Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Blackbaud FE NXT data from your Excel spreadsheets.
-
Build SendPulse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SendPulse data and build visualizations in Tableau Cloud.
-
Integrate Live Salesloft Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesloft data to Blue Prism using the CData ODBC Driver for Salesloft to create automated workflows for repetitive business tasks.
-
Integrate with Scrapfly Data in JReport Designer
Create charts and reports based on Scrapfly data in JReport Designer.
-
Connect SAP ByDesign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP ByDesign with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Cloudflare Data in Sisense
Create an ElastiCube in Sisense app with access to Cloudflare data.
-
Use the CData Software JDBC Driver for CloudConvert in MicroStrategy Web
Connect to CloudConvert data in MicroStrategy Web using the CData Software JDBC Driver for CloudConvert.
-
Connect to Microsoft Teams Data in RapidMiner
Integrate Microsoft Teams data with standard components and data source configuration wizards in RapidMiner Studio.