CData Software - Knowledge Base
Recent Articles
-
Query Parquet Data as a MySQL Database in Node.js
Execute MySQL queries against Parquet data from Node.js.
-
Create Wrike Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wrike from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Data from a SharePoint List Based on a Custom View
We use Server Explorer in Visual Studio to show how the CData provider data model exposes custom views of SharePoint lists.
-
Integrate with GraphQL Data in JReport Designer
Create charts and reports based on GraphQL data in JReport Designer.
-
Integrate Omnisend Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Omnisend data and integrate live Omnisend data into your Power Automate tasks.
-
Connect to Live Basecamp Data in MicroStrategy through CData Connect AI
Create a live connection to Basecamp Data in CData Connect AI and connect to your Basecamp data from MicroStrategy.
-
Automated Continuous ConvertAPI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ConvertAPI replication to Google BigQuery.
-
Process & Analyze Google Contacts Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Contacts Data.
-
Integrate Hacker News with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hacker News with External Services.
-
Automate Excel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Excel data from PowerShell? This article demonstrates how to utilize the Excel Cmdlets for tasks like connecting to Excel data, automating operations, downloading data, and more.
-
Connect to Lakebase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Lakebase to connect to Lakebase data and execute queries in PowerBuilder.
-
How to work with Browserless Data in Apache Spark using SQL
Access and process Browserless Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Aha! with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Aha! with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aha! data.
-
Connect to ZeroBounce Data in RapidMiner
Integrate ZeroBounce data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect Flowise AI Agents to Live Basecamp 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 Basecamp data without replication.
-
Use Grok to Talk to Your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Monday.com data for you.
-
Build Adobe Commerce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Adobe Commerce data and build visualizations in Tableau.
-
Automated Continuous Microsoft Exchange Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to MySQL.
-
How to use SQLAlchemy ORM to access Zoom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoom data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aha!
Provide connectivity to Aha! data through an SAP BusinessObjects universe.
-
Automated Printify Data Replication to Teradata
Use CData Sync to Customize and automate Printify data replication to Teradata.
-
Integrate CircleCI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CircleCI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CircleCI data.
-
Extract, Transform, and Load Mocean Data in Informatica PowerCenter
Create a simple Workflow for Mocean data in Informatica PowerCenter.
-
Integrate Live Dynamics NAV Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dynamics NAV data to Blue Prism using the CData ODBC Driver for Dynamics NAV to create automated workflows for repetitive business tasks.
-
Integrate Shopify Data into Power Automate Desktop using CData Connect
CData Connect for Shopify Data enables you to integrate Shopify data into workflows built using Microsoft Power Automate Desktop.
-
Aircall Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aircall facts in real time.
-
How to Seamlessly Import Raisers Edge NXT Data into IBM SPSS Modeler
Integrate Raisers Edge NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Workable Data in HULFT Integrate
Connect to Workable as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for SAP in Microsoft Power Query
You can use the CData SAP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP data into Microsoft Power Query.
-
How to Connect to Live EnterpriseDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live EnterpriseDB data securely in real time.
-
Integrate with live BigCommerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live BigCommerce data in Jitterbit.
-
Integrate Devin with Live Wave Financial Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Wave Financial data.
-
Interact with Live Databricks Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Databricks data.
-
How to connect Amazon QuickSight to SAP SuccessFactors LMS Data
Create a connection to SAP SuccessFactors LMS data in CData Connect AI and insert SAP SuccessFactors LMS data into Amazon QuickSight SPICE to build interactive dashboards.
-
DB2 Reporting in OBIEE with the DB2 JDBC Driver
Deploy the DB2 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Gumroad Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Gumroad and work with Gumroad data in your FileMaker application.
-
Automate SAP Concur Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Concur data replication to Couchbase.
-
View Reports on Real-Time Sybase Data in Power BI Report Server
Use the CData ODBC Driver for Sybase to visualize Sybase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Oracle HCM Cloud Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle HCM Cloud data in DBxtra.
-
Integrate Live Greenplum Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Greenplum data to Blue Prism using the CData ODBC Driver for Greenplum to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Mouseflow in SAS for Real-Time Reporting and Analytics
Connect to real-time Mouseflow data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mouseflow.
-
Connect to BigCommerce Data from AWS Glue
Use CData Connect AI to gain access to live BigCommerce data from your AWS Glue jobs.
-
How to Visualize PolarTeamPro 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 PolarTeamPro data in Python.
-
Connect to REST Data from a Connection Pool in JBoss
Integrate REST data into Java servlets: Use the Management Console in JBoss to install the REST JDBC Driver.
-
Visualize Cosmos DB Data in Sisense
Create an ElastiCube in Sisense app with access to Cosmos DB data.
-
Analyze BambooHR Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BambooHR data and visualize BambooHR data in SAP Analytics Cloud.
-
Build Dashboards with Azure Data Catalog Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Data Catalog data in DBxtra.
-
Integrating LangGraph with Adobe Experience Manager Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Adobe Experience Manager data within automated workflows.
-
Connect to LaunchDarkly Data in RazorSQL
Connect to LaunchDarkly from wizards and query LaunchDarkly data from the GUI in the RazorSQL database management tool.
-
Integrate DocuSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DocuSign with External Services.
-
Visualize Google 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 Google Ads data into TIBCO Spotfire.
-
Build Data Flows from Salesforce CRM Analytics to SQL Server using SSIS
Easily back up Salesforce CRM Analytics data to SQL Server using the SSIS components for Salesforce CRM Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Brex
Provide connectivity to Brex data through an SAP BusinessObjects universe.
-
Automate Instagram Data Replication to Azure Data Lake
Use CData Sync to customize and automate Instagram data replication to Azure Data Lake.
-
Connect to Google Drive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Drive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
A PostgreSQL Interface for Printify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Printify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Microsoft Exchange in MicroStrategy Desktop
Connect to Microsoft Exchange data in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Exchange.
-
Access Greenplum 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 Greenplum data.
-
How to Easily Query Salesloft Data in OpenOffice Base
Connect to Salesloft data in OpenOffice Base using the CData ODBC Driver for Salesloft and generate reports with live data insights.
-
How to create an RPA flow for Stack Exchange Data in UiPath Studio
Use the Stack Exchange ODBC Driver to create workflows that access real-time Stack Exchange data without any coding.
-
Import Real-Time Workable Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Workable data in ColdFusion.
-
Automated Continuous Amazon S3 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Snowflake.
-
Build Dynamics NAV-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dynamics NAV data and build web apps with connectivity to live Dynamics NAV data.
-
Process & Analyze Microsoft Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Ads Data.
-
Access SendGrid Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendGrid data from HeidiSQL.
-
Query Azure Data Catalog Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Data Catalog data.
-
Prepare, Blend, and Analyze HCL Domino Data in Alteryx Designer (Connect AI)
Build workflows to access live HCL Domino data for self-service data analytics.
-
Integrate Databricks Data in Pentaho Data Integration
Build ETL pipelines based on Databricks data in the Pentaho Data Integration tool.
-
Connecting Pipedream with Sendwithus 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 Sendwithus data in real time.
-
Visualize VWO Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to VWO data.
-
Create Campaigner-Connected Applications in Appsmith
Connect to Campaigner Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Campaigner data.
-
Import Amazon Marketplace Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon Marketplace Data and provide access to live Amazon Marketplace data for custom reports in the Power BI Service.
-
Enable the Hive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hive data.
-
How to Visualize Superchat Data in Python with pandas
Use pandas and other modules to analyze and visualize live Superchat data in Python.
-
How to connect SharePoint with Redshift Data through external lists
Provide Redshift data to SharePoint users as an external list.
-
Natively Connect to Cloudflare Data in PHP
The CData ODBC driver for Cloudflare enables you to create PHP applications with connectivity to Cloudflare data. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for Autopilot Data using the CData ODBC Driver
Use the SQL Gateway and Autopilot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Highrise data for you.
-
Integrate Google Campaign Manager 360 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Campaign Manager 360 data and integrate live Google Campaign Manager 360 data into your Power Automate tasks.
-
Explore Geographical Relationships in Box Data with Power Map
Create data visualizations with Box data in Power Map.
-
Connect to ZohoSubscriptions Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoSubscriptions as an External Source in Dremio.
-
Query Zendesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zendesk data from Node.js.
-
Connect to MarkLogic Data in Ruby
Connect to MarkLogic data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Building Dynamic Web Pages with Reckon Accounts Hosted Data Using AngularJS
Create single-page applications with live connectivity to Reckon Accounts Hosted using the CData API Server.
-
Build Data Flows from Cloudant to SQL Server using SSIS
Easily back up Cloudant data to SQL Server using the SSIS components for Cloudant.
-
Migrating data from Greenhouse to Snowflake using CData SSIS Components.
Easily push Greenhouse data to Snowflake using the CData SSIS Tasks for Greenhouse and Snowflake.
-
Connect to SAP Ariba Procurement Data in Ruby
Connect to SAP Ariba Procurement data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Placid Replication to SingleStore
Use CData Sync for automated, continuous, customizable Placid replication to SingleStore.
-
How to Query Freshservice Data in MySQL Workbench
Execute MySQL queries against live Freshservice data from MySQL Workbench.
-
Connect to Google Contacts Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Contacts data in Airbyte.
-
Connect Certinia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Certinia data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Live CockroachDB 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 CockroachDB data through a conversational interface.
-
Automate MariaDB Data Replication to Couchbase
Use CData Sync to Customize and automate MariaDB data replication to Couchbase.
-
Integrate Live Gmail 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 Gmail data from within the IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Stack Exchange
Provide connectivity to Stack Exchange data through an SAP BusinessObjects universe.
-
Connect to PayPal Data in Google Apps Script via Connect AI
Use CData Connect AI to access PayPal data in Google Apps Script.
-
Integrate Trae with Live SAP BusinessObjects BI Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP BusinessObjects BI data from within the AI-powered IDE.
-
Choosing the Best Method to Connect Placid to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Placid data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Redis Replication to Snowflake
Use CData Sync for automated, continuous, customizable Redis replication to Snowflake.
-
Working with eBay Analytics Data in LINQPad
Execute LINQ queries to eBay Analytics data in LINQPad.