CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Azure Analysis Services Data
Use CData Power BI Connectors to visualize Azure Analysis Services data in Power BI.
-
Integrate with live Coda Data in Jitterbit
Use CData Connect AI to connect to and integrate live Coda data in Jitterbit.
-
Access Live SageHR Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SageHR data from your Excel spreadsheets.
-
Create Spark-Connected Nintex Workflows
Use CData Connect AI to connect to Spark Data from Nintex Workflow Cloud and build custom workflows using live Spark data.
-
How to Connect to Live Pinterest Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Pinterest data securely in real time.
-
Import Microsoft Planner Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Planner Data and provide access to live Microsoft Planner data for custom reports in the Power BI Service.
-
Search External Paymo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Paymo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Paymo Data objects that you can access from apps and the dashboard.
-
Model, Search, and Visualize Live Campaigner Data in ThoughtSpot
Use CData Connect AI to connect to live Campaigner data for modeling, searching, and visualizing.
-
Access Intercom 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 Intercom data.
-
Access Snowflake Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Snowflake data from your Oracle system.
-
Build an OLAP Cube in SSAS from Figshare Data
Establish a connection to Figshare data data from SQL Server Analysis Services, and use the Figshare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Dash to Build to Web Apps on Everhour Data
Create Python applications that use pandas and Dash to build Everhour-connected web apps.
-
Integrate Trae with Live Dynamics 365 Business Central Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Dynamics 365 Business Central data from within the AI-powered IDE.
-
Provide OData Services of Paymo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Paymo data by developing a WCF Service Application.
-
Migrating data from Mistral AI to Google BigQuery using CData SSIS Components.
Easily push Mistral AI data to Google BigQuery using the CData SSIS Tasks for Mistral AI and Google BigQuery.
-
Visualize Opsgenie Data in Tableau
The CData ODBC driver for Opsgenie enables you integrate Opsgenie data into Tableau dashboards.
-
Import Real-Time Mocean Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mocean data in ColdFusion.
-
Migrating data from Oracle Eloqua Reporting to Google BigQuery using CData SSIS Components.
Easily push Oracle Eloqua Reporting data to Google BigQuery using the CData SSIS Tasks for Oracle Eloqua Reporting and Google BigQuery.
-
Design BIRT Reports on SAP Ariba Procurement Data
Provide current SAP Ariba Procurement data to your embedded analytics.
-
Access Mailjet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mailjet data from your Oracle system.
-
Connect to HubDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HubDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build a Simple VCL Application for SAP HANA XS Advanced Data
How to build a simple VCL Application to view SAP HANA XS Advanced data in RAD Studio using the CData ODBC Driver for SAP HANA XS Advanced.
-
How to Work with Sentry Data in AWS Glue Jobs Using JDBC
Connect to Sentry from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous REST Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable REST replication to Apache Cassandra.
-
Integrating Gumloop with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on CSV data within automated workflows.
-
Use the CData Software ODBC Driver for Tavily in MicroStrategy Desktop
Connect to Tavily data in MicroStrategy Desktop using the CData Software ODBC Driver for Tavily.
-
Integrate Live Amazon Marketplace 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 Amazon Marketplace data from within the IDE.
-
Access Live SAP HANA XS Advanced Data in Excel 365 Online (Excel for the web)
Connect to SAP HANA XS Advanced data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze SAP Business One Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Business One data for self-service data analytics.
-
How to connect to SpaceX Data with Squirrel SQL client
Connect to SpaceX data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Microsoft Teams Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Snowflake.
-
Getting Started with the CData Tableau Connector for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Raisers Edge NXT.
-
Bidirectional Access to Quickbase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Quickbase data in Filemaker Pro for Mac or Windows.
-
Build AI Agents with Google Drive 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 Drive data through CData Connect AI.
-
Automated Continuous MailerSend Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MailerSend replication to Azure SQL Database.
-
Analyze Facebook Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Facebook data in Microsoft R Open.
-
How to Query Avaza Data in MySQL Workbench
Execute MySQL queries against live Avaza data from MySQL Workbench.
-
Connect and Query Live Kafka Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Kafka data into Databricks and enable direct, live querying and analysis without replication.
-
Analyze Live Freshteam Data in SAS Viya
Use CData Connect AI to connect to Freshteam data from SAS Viya and deploy self-service analytics using live Freshteam data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for NetSuite
Provide connectivity to NetSuite data through an SAP BusinessObjects universe.
-
Access Live FHIR Data in Coginiti Pro
Connect to and query live FHIR data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze iContact Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of iContact data and visualize live iContact data in Infragistics Reveal.
-
How to integrate Metabase with Adobe Commerce Data
Use CData Connect AI to connect to live Adobe Commerce data and create an interactive dashboard in Metabase from Adobe Commerce data.
-
DB2 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to DB2 data through CData Connect AI using different applications and tools.
-
How to work with Avro Data in Apache Spark using SQL
Access and process Avro Data in Apache Spark using the CData Software JDBC Driver.
-
Build Google Campaign Manager 360-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Campaign Manager 360 data.
-
Automated Continuous Opsgenie Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Opsgenie replication to Google Cloud SQL.
-
Integrate Live Gong Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Gong from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gong data.
-
How to connect to Wave Financial Data from Spring Boot
Connect to Wave Financial in a Spring Boot Application using the CData JDBC Driver for Wave Financial
-
Visualize SAP HANA XS Advanced Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP HANA XS Advanced data.
-
Use ChatGPT to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Salesforce Pardot data for you.
-
Connect to ConstantContact Data from Crystal Reports
Use CData Connect AI to connect to and report on live ConstantContact data from Crystal Reports.
-
Query Discourse Data in ColdFusion
Write standard ColdFusion data access code to connect to Discourse data.
-
Replicate Multiple Azure Synapse Accounts via the CData Sync CLI
Replicate multiple Azure Synapse accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parallel
Provide connectivity to Parallel data through an SAP BusinessObjects universe.
-
Integrate Live Google Sheets 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 Google Sheets data from within the IDE.
-
Build Adobe Analytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Analytics Data from Zoho Analytics and import live Adobe Analytics data.
-
Query, Visualize, and Share live Bullhorn CRM Data in Redash
Use CData Connect AI to connect to live Bullhorn CRM data in Redash for querying, visualizing, and sharing.
-
A PostgreSQL Interface for MailChimp Data (MySQL Remoting via JDBC)
Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Synapse.
-
Connect to PhantomBuster Data from a Connection Pool in JBoss
Integrate PhantomBuster data into Java servlets: Use the Management Console in JBoss to install the PhantomBuster JDBC Driver.
-
Connect Missive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Missive data using the CData Python MCP Server.
-
Link Bright Data with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bright Data data in Filemaker Pro for Mac or Windows.
-
Integrate Theia IDE with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ActiveCampaign data from within the development environment.
-
Add Google Campaign Manager 360 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Campaign Manager 360 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Working with Guru Data in LINQPad
Execute LINQ queries to Guru data in LINQPad.
-
Create a Data Access Object for Microsoft Exchange Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Exchange data in JDBI.
-
How to import Dropbox Data into Apache Solr
Use the CData Software JDBC Driver for Dropbox in Data Import Handler and create an automated import of Dropbox data to Apache Solr Enterprise Search platform.
-
Natively Connect to CockroachDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CockroachDB data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Productboard in MicroStrategy Web
Connect to Productboard data in MicroStrategy Web using the CData Software ODBC Driver for Productboard.
-
Build AI/ML Models with Live Google Calendar Data using Dataiku
Connect Google Calendar Data with Dataiku using the CData JDBC Driver for Google Calendar.
-
Connect to VWO Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for VWO Data and connect to VWO data in Akorbi Digital RunMyProcess.
-
Visualize Live TaxJar Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live TaxJar data.
-
Moving Data from Square to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Square data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Dash to Build Web Apps on Exact Online Data via CData Connect AI
Build interactive Dash web apps on live Exact Online data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous ZohoInvoice Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to IBM DB2.
-
Build Charts with Browserless Data in Clear Analytics
Create dynamic charts and perform analytics based on Browserless data in Clear Analytics.
-
Replicate Amazon Marketplace Data from PowerShell
Write a quick PowerShell script to query Amazon Marketplace data. Use connectivity to the live data to replicate Amazon Marketplace data to SQL Server.
-
Access Bannerbear Data from MySQL in PHP
Connect to Bannerbear through the standard MySQL libraries in PHP.
-
Automated Continuous Mistral AI Replication to SQLite
Use CData Sync for automated, continuous, customizable Mistral AI replication to SQLite.
-
Create CouchDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to CouchDB Data from Klipfolio and build custom visualizations using live CouchDB data.
-
Build Harvest-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Harvest data.
-
Connect to SparkPost Data in Aqua Data Studio
Access SparkPost data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect Flowise AI Agents to Live Google Ad Manager 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 Google Ad Manager data without replication.
-
Perform Batch Operations with Box Data in Apache NiFi
Connect to Box data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect Salesforce Pardot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce Pardot with IBM WebSphere for seamless data integration and connectivity.
-
How to Work with iContact Data in AWS Glue Jobs Using JDBC
Connect to iContact from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Work with Rootly Data in FoxPro
Load Rootly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Python Connector for Yelp
Learn to install and license the CData Python Connector and configure a connection to live Yelp data.
-
How to integrate Discord with Apache Airflow
Access and process Discord data in Apache Airflow using the CData JDBC Driver.
-
How to Connect the Power BI Service to Wave Financial: Complete Guide
Connect to the CData Software Power BI Connector for Wave Financial from PowerBI.com to provide real-time Wave Financial data across the organization.
-
Integrate Open WebUI with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Campaign Manager 360 data from within the chat interface.
-
Back Up MailerSend data 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 MailerSend data data.
-
Getting Started with the CData Connect AI Python SDK for HubDB
Install the CData Connect AI Python SDK to read and write live HubDB data with standard DB-API 2.0 Python code.
-
Connect to Google Directory Data in Aqua Data Studio
Access Google Directory data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Work with MailChimp Data in AWS Glue Jobs Using JDBC
Connect to MailChimp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy
Connect to Amazon DynamoDB data in MicroStrategy Developer using the CData Software ODBC Driver for Amazon DynamoDB.
-
How to Visualize BambooHR 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 BambooHR data in Python.
-
How to connect to Oracle SCM Data from Spring Boot
Connect to Oracle SCM in a Spring Boot Application using the CData JDBC Driver for Oracle SCM
-
DataBind Controls to Everhour Data in C++Builder
DataBind to Everhour data in C++Builder with standard components and controls.