CData Software - Knowledge Base
Recent Articles
-
Integrate SAP Concur Data into Power Automate Desktop using CData Connect
CData Connect for SAP Concur Data enables you to integrate SAP Concur into workflows built using Microsoft Power Automate Desktop.
-
Replicate Mocean Data from PowerShell
Write a quick PowerShell script to query Mocean. Use connectivity to the live data to replicate Mocean to SQL Server.
-
How to Connect to SAP Ariba Source Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Ariba Source. Leverage the pyodbc module for ODBC in Python.
-
Query Autopilot Data in DataGrip
Create a Data Source for Autopilot in DataGrip and use SQL to query live Autopilot.
-
Access Live Amazon Marketplace Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Marketplace data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData ODBC Driver for Pingdom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pingdom to connect to Pingdom from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pingdom in Excel.
-
Integrate ZohoMarketingHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoMarketingHub with External Services.
-
Connect Landbot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Landbot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live PostgreSQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PostgreSQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Tableau Connector for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build an OLAP Cube in SSAS from BambooHR Data
Establish a connection to BambooHR data from SQL Server Analysis Services, and use the BambooHR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Active Directory-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Active Directory Data from Klipfolio and build custom visualizations using live Active Directory.
-
How to integrate Twitter Ads with Apache Airflow
Access and process Twitter Ads in Apache Airflow using the CData JDBC Driver.
-
Access Live Epicor Kinetic Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Epicor Kinetic from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Outreach.io from Asprova with CData Software ODBC Driver for Outreach.io
This article shows how to connect faster to Outreach.io data from Asprova.
-
Query Access Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Access from Node.js.
-
Integrate with Shopify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shopify to a JSON file on disk.
-
Build AI/ML Models with Live SparkPost Data using Dataiku
Connect SparkPost Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect to Live Box 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 Box without replication.
-
How to use SQLAlchemy ORM to access Keap Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Keap.
-
Access Live Instagram Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Instagram from your Excel spreadsheets.
-
Perform Batch Operations with QuickBooks Online Data in Apache NiFi
Connect to QuickBooks Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Manage Sage Intacct Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage Intacct.
-
Connect to Presto Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Presto Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Apps with Live PivotalTracker Data Using the Low-Code Development Platform of Mendix
Connect PivotalTracker with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Dropbox Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dropbox using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Harvest Data in AWS Glue Jobs Using JDBC
Connect to Harvest from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating GitHub Copilot CLI with Mailgun 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 to Cosmos DB Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Cosmos DB from HeidiSQL.
-
Build eBay Analytics-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for eBay Analytics to explore live eBay Analytics Data in Gemini Code Assist to assist with building eBay Analytics-powered applications.
-
Rapidly Develop Microsoft Planner-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 Microsoft Planner.
-
Configure the CData JDBC Driver for TaxJar in a Connection Pool in Tomcat
Connect to TaxJar from a connection pool in Tomcat.
-
Connect to Tanda Data in Aqua Data Studio
Access Tanda from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Close Data from a Connection Pool in Jetty
The Close JDBC Driver supports connection pooling: This article shows how to connect faster to Close from Web apps in Jetty.
-
Integrate with Short.io Data in JReport Designer
Create charts and reports based on Short.io in JReport Designer.
-
Visualize Microsoft Ads Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Ads into TIBCO Spotfire.
-
Create Discourse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Discourse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Rebilly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rebilly.
-
Use the CData Software ODBC Driver for Google Spanner in MicroStrategy
Connect to Google Spanner in MicroStrategy Developer using the CData Software ODBC Driver for Google Spanner.
-
Create Reports with Mailjet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailjet.
-
How to Work with HubDB Data in ETL Validator JDBC
Connect to HubDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating OpenCode Terminal with HCL Domino 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 Work with Shopify Data in AWS Glue Jobs Using JDBC
Connect to Shopify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Auth0 Data in DBeaver
Use the CData ODBC Driver to connect to Auth0 in DBeaver.
-
Build Apps with Live Bannerbear Data Using the Low-Code Development Platform of Mendix
Connect Bannerbear with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Kiro CLI with Amazon S3 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.
-
Explore Geographical Relationships in Active Directory Data with Power Map
Create data visualizations with Active Directory in Power Map.
-
Integrate Amazon DynamoDB Data in the Pentaho Report Designer
Publish reports based on Amazon DynamoDB in the Pentaho BI tool.
-
LINQ to Coda Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Coda Data Provider.
-
How to Connect to Live SAP SuccessFactors LMS Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP SuccessFactors LMS securely in real time.
-
Rapidly Develop Intercom-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 Intercom.
-
Automated Continuous Azure Synapse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Apache Kafka.
-
How to load OnePageCrm data into Elasticsearch via Logstash
Introducing a simple method to load OnePageCrm data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to QuickBooks Data in Ruby
Connect to QuickBooks Desktop in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access SurveyMonkey Data from MySQL in Amazon QuickSight
Connect to SurveyMonkey and build visualizations of SurveyMonkey using a MySQL Connection in Amazon QuickSight.
-
Access Unbounce Data from MySQL in Amazon QuickSight
Connect to Unbounce and build visualizations of Unbounce using a MySQL Connection in Amazon QuickSight.
-
Rapidly Develop CapsuleCRM-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 CapsuleCRM.
-
Automated Continuous Google Forms Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Forms replication to Apache Cassandra.
-
Use Biml to Build SSIS Tasks to Replicate Excel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Excel to SQL Server.
-
Use Dash to Build Web Apps on Neo4J Data via CData Connect AI
Build interactive Dash web apps on live Neo4J using pandas and the CData Connect AI Python SDK.
-
Connect to Shippo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Shippo and work with Shippo in your FileMaker applications.
-
Viewing MailerSend Data in RAD Studio Data Explorer
How to view MailerSend in RAD Studio Data Explorer using the CData ODBC Driver for MailerSend.
-
Access Live Databricks Data in TIBCO Data Virtualization
Use the Databricks Tibco DV Adapter to create a Databricks data source in TIBCO Data Virtualization Studio and gain access to live Databricks from your TDV Server.
-
Connect to Aweber Data in CloverDX (formerly CloverETL)
Transfer Aweber using the visual workflow in the CloverDX data integration tool.
-
Integrate Sage Intacct with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage Intacct with External Services.
-
Access Rootly Data from MySQL in PHP
Connect to Rootly through the standard MySQL libraries in PHP.
-
How to Connect to Live Marketo 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 Marketo for you.
-
Connect to Salesforce CRM Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce CRM Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automate Tally Data Replication to Azure Data Lake
Use CData Sync to customize and automate Tally ERP replication to Azure Data Lake.
-
Connect to Onfleet Data in HULFT Integrate
Connect to Onfleet as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Excel Add-In for Cloudflare
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cloudflare.
-
Build an OLAP Cube in SSAS from FTP Data
Establish a connection to FTP Servers data from SQL Server Analysis Services, and use the FTP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live EnterpriseDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to EnterpriseDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live EnterpriseDB.
-
Publish Miro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Miro.
-
Use the CData Software ODBC Driver for Slack in MicroStrategy Web
Connect to Slack in MicroStrategy Web using the CData Software ODBC Driver for Slack.
-
How to Visualize Blackbaud FE NXT Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Blackbaud FE NXT in Python.
-
Access Samanage Data from MySQL in Amazon QuickSight
Connect to Samanage and build visualizations of Samanage using a MySQL Connection in Amazon QuickSight.
-
Integrate DB2 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM DB2 and integrate live IBM DB2 into your Power Automate tasks.
-
Integrate Open WebUI with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Financials Cloud from within the chat interface.
-
How to Create Power BI Visual Reports with Real-Time TigerGraph Data
Use CData Power BI Connectors to visualize TigerGraph in Power BI.
-
Connect to and Visualize Live ChartMogul Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ChartMogul.
-
Connect Excel to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Live Klaviyo Data in MicroStrategy through CData Connect AI
Create a live connection to Klaviyo Data in CData Connect AI and connect to your Klaviyo from MicroStrategy.
-
Connect to Airtable Data in CloverDX (formerly CloverETL)
Transfer Airtable using the visual workflow in the CloverDX data integration tool.
-
Provide OData Services of Act-On Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Act-On by developing a WCF Service Application.
-
Use Dash to Build to Web Apps on LeadDesk Data
Create Python applications that use pandas and Dash to build LeadDesk-connected web apps.
-
Connect to Avalara AvaTax Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Avalara AvaTax and the Script function in FileMaker Pro to connect to Avalara AvaTax and work with Avalara AvaTax in your FileMaker application.
-
Getting Started with the CData Python Connector for ZohoMarketingHub
Learn to install and license the CData Python Connector
-
Connect to Blackbaud FE NXT Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Blackbaud FE NXT from Filemaker Pro on Mac.
-
Integrate Cosmos DB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cosmos DB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Cosmos DB.
-
Integrating Antigravity CLI with Missive via CData CLI
Connect Missive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build an OLAP Cube in SSAS from Gong Data
Establish a connection to Gong data from SQL Server Analysis Services, and use the Gong Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating LangGraph with Dynamics CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dynamics CRM within automated workflows.
-
Integrate Live Factorial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Factorial to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Printify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Printify in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Excel Spreadsheet Automation on Box Data with the QUERY Formula
Pull data from Box, automate spreadsheets, and more with the QUERY formula.
-
How to Work with ZohoDesk Data in ETL Validator JDBC
Connect to ZohoDesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Reports from CSV Data in Looker Studio
Use CData Connect AI to gain access to live CSV/TSV Files and create custom reports in Looker Studio.
-
Integrate BigQuery Data into Power Automate Desktop using CData Connect
CData Connect for BigQuery Data enables you to integrate Google BigQuery into workflows built using Microsoft Power Automate Desktop.
-
Use Microsoft Copilot Studio to talk to your HCL Domino 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 HCL Domino for you.