CData Software - Knowledge Base
Recent Articles
-
Automate Reply.io Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reply.io data replication to Azure Data Lake.
-
Create Data Visualizations Based On Bitly Data in Mode
Use CData Connect AI to connect to Bitly Data from Mode and build visualizations using live Bitly data.
-
Create MarkLogic-Connected Business Apps in AppSheet
Connect to MarkLogic Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MarkLogic data.
-
Connect to Azure DevOps Data in Ruby
Connect to Azure DevOps data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous LDAP Replication to Oracle
Use CData Sync for automated, continuous, customizable LDAP replication to Oracle.
-
Import SAP Fieldglass Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Fieldglass Data from Azure Data Factory and import live SAP Fieldglass data.
-
Building Dynamic Web Pages with Gmail Data Using AngularJS
Create single-page applications with live connectivity to Gmail using the CData API Server.
-
Building Dynamic Web Pages with Shopify Data Using AngularJS
Create single-page applications with live connectivity to Shopify using the CData API Server.
-
Query Printify Data as a MySQL Database in Node.js
Execute MySQL queries against Printify data from Node.js.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data for you.
-
How to Connect to & Open Oracle Eloqua Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Eloqua to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Reports with Elasticsearch Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elasticsearch data.
-
Access Live Amazon Athena Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Athena data from your Excel spreadsheets.
-
Connect to Printify in SpagoBI
Create reports featuring live Printify data in SpagoBI Studio. Host Printify reports on SpagoBI Server.
-
Query Google Analytics Data in DataGrip
Create a Data Source for Google Analytics in DataGrip and use SQL to query live Google Analytics data.
-
Integrating Dataiku with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Exchange data.
-
Use the CData ODBC Driver for Salesforce CRM Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce CRM Analytics data in Excel.
-
Connect to Power BI XMLA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Power BI XMLA data.
-
Integrate with Bugsnag Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bugsnag data to a JSON file on disk.
-
Connect to Exact Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Exact Online data.
-
ETL Sendwithus in Oracle Data Integrator
This article shows how to transfer Sendwithus data into a data warehouse using Oracle Data Integrator.
-
Connect to Bitbucket Data in DBArtisan
Use wizards in DBArtisan to configure Bitbucket data as a data source.
-
Connect to Grafana Data in NetBeans
Connect to Grafana data in NetBeans with the data source configuration wizard.
-
Create Datasets from ZendeskSell in Domo Workbench and Build Visualizations of ZendeskSell Data in Domo
Use the CData Software ODBC Driver for ZendeskSell to create datasets from ZendeskSell data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Microsoft Ads Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Ads Data from Cognos Analytics and analyze live Microsoft Ads data.
-
Integrate Goose with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Spark data from within the local AI agent.
-
How to Connect DBeaver to Amplitude via a JDBC Driver
Manage Amplitude data with visual tools in DBeaver like the query browser.
-
Integrate Live SAP Ariba Procurement Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Procurement from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Procurement data.
-
Integrating Dataiku with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MongoDB data.
-
Connect to Hive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hive to connect to Hive data from Web applications running on WebLogic.
-
Access Live Twitter Ads Data in Excel 365 Online (Excel for the web)
Connect to Twitter Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use JayDeBeApi to access SAP BusinessObjects BI Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP BusinessObjects BI data.
-
Visualize Avalara AvaTax Data in Sisense
Create an ElastiCube in Sisense app with access to Avalara AvaTax data.
-
How to Connect to Zoho Books Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Books data. Leverage the pyodbc module for ODBC in Python.
-
Query Figshare Data in DataGrip
Create a Data Source for Figshare in DataGrip and use SQL to query live Figshare data.
-
Object-Relational Mapping (ORM) with ClickUp 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 ClickUp data into a Java-based ORM framework, Hibernate.
-
Automated Continuous SendGrid Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SendGrid replication to AlloyDB.
-
How to Access Live Smartsheet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Smartsheet enables you to integrate Smartsheet data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Act-On Data in Google Apps Script via Connect AI
Use CData Connect AI to access Act-On data in Google Apps Script.
-
Getting Started with the CData SSIS Components for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SuiteCRM.
-
How to connect to Teamgate Data in DBVisualizer
Integrate Teamgate data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate MariaDB Data to Multiple Databases
Replicate MariaDB data to disparate databases with a point-and-click configuration.
-
Connect to Zendesk Data in Ruby
Connect to Zendesk data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Kafka Data in TIBCO Spotfire through ADO.NET
Integrate Kafka data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for EmailOctopus in MicroStrategy Web
Connect to EmailOctopus data in MicroStrategy Web using the CData Software ODBC Driver for EmailOctopus.
-
Automated Continuous GitLab Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable GitLab replication to Apache Cassandra.
-
Build AI Agents with Typeform 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 Typeform data through CData Connect AI.
-
How to work with BigCommerce Data in Apache Spark using SQL
Access and process BigCommerce Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy Web
Connect to Discord data in MicroStrategy Web using the CData Software ODBC Driver for Discord.
-
Automated Continuous LDAP Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LDAP replication to Apache Cassandra.
-
Analyze Live Presto Data in SAS Viya
Use CData Connect AI to connect to Presto data from SAS Viya and deploy self-service analytics using live Presto data.
-
How to connect to SendInBlue Data from Spring Boot
Connect to SendInBlue in a Spring Boot Application using the CData API Driver for JDBC
-
Build a Simple VCL Application for Cosmos DB Data
How to build a simple VCL Application to view Cosmos DB data in RAD Studio using the CData ODBC Driver for Cosmos DB.
-
Replicate Multiple Active Directory Accounts via the CData Sync CLI
Replicate multiple Active Directory accounts to one or many databases.
-
Connect to HBase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HBase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Google Cloud Storage Data in TIBCO Data Virtualization
Use the Google Cloud Storage Tibco DV Adapter to create a Google Cloud Storage data data source in TIBCO Data Virtualization Studio and gain access to live Google Cloud Storage data from your TDV Server.
-
Import Real-Time FormSite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FormSite data in ColdFusion.
-
How to import Foursquare Data into Apache Solr
Use the CData Software JDBC Driver for Foursquare in Data Import Handler and create an automated import of Foursquare data to Apache Solr Enterprise Search platform.
-
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.
-
Analyze Guru Data in Cognos Analytics
Use CData Connect AI to connect to Guru Data from Cognos Analytics and analyze live Guru data.
-
Operational Reporting on FTP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FTP data.
-
Build Dashboards with Twilio Data in DBxtra
Create dynamic dashboards and perform analytics based on Twilio data in DBxtra.
-
Access Live AlloyDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AlloyDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to and Visualize Live BigQuery Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live BigQuery data.
-
Integrate Live Active Directory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Active Directory data to Blue Prism using the CData ODBC Driver for Active Directory to create automated workflows for repetitive business tasks.
-
Rapidly Develop Couchbase-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 Couchbase.
-
Create Power BI Reports on Real-Time MongoDB Data
Use the CData ODBC Driver for MongoDB to visualize MongoDB data in Power BI Desktop.
-
Getting Started with the CData Tableau Connector for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect the Power BI Service to RSS: Complete Guide
Connect to the CData Software Power BI Connector for RSS from PowerBI.com to provide real-time RSS feeds across the organization.
-
Create Clari Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clari from PowerBI.com to create Power BI Dataflows with real-time data.
-
Establish a Live Connection with Pinecone Data using Tableau Bridge
The CData ODBC Driver for Pinecone enables you to integrate live Pinecone data into Tableau Cloud dashboards using the Tableau Bridge.
-
Bridge Oracle Eloqua Reporting Connectivity with Apache NiFi
Access and process Oracle Eloqua Reporting data in Apache NiFi using the CData JDBC Driver.
-
Connect to and Query Clockify Data in QlikView over ODBC
Create data visualizations with Clockify data in QlikView.
-
Automated Continuous Cassandra Replication to Oracle
Use CData Sync for automated, continuous, customizable Cassandra replication to Oracle.
-
Automate Adobe Experience Manager Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Experience Manager data from PowerShell? This article demonstrates how to utilize the Adobe Experience Manager Cmdlets for tasks like connecting to Adobe Experience Manager data, automating operations, downloading data, and more.
-
Integrate Live Optimizely Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Optimizely from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Optimizely data.
-
Create Couchbase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Couchbase Data from Klipfolio and build custom visualizations using live Couchbase data.
-
Automated Continuous Google Search Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Search replication to delimited files (CSV/TSV).
-
Query Live Grafana Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Grafana data directly from the development environment.
-
Build Visualizations of Sybase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase data in Birst.
-
Access Mailgun 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 Mailgun data.
-
Build Dashboards with Act CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Act CRM data in Dundas BI.
-
Query Live Redshift 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 Redshift data through a conversational interface.
-
View Reports on Real-Time Placid Data in Power BI Report Server
Use the CData ODBC Driver for Placid to visualize Placid data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create SSAS Tabular Models from Codat Data
How to build a SQL Server Analysis Service Tabular Model from Codat data using CData drivers.
-
Integrate Google Drive Data in Pentaho Data Integration
Build ETL pipelines based on Google Drive data in the Pentaho Data Integration tool.
-
A PostgreSQL Interface for Shippo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Shippo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for Coinbase
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Sendwithus Data in Ruby
Connect to Sendwithus data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous FreeAgent Replication to Oracle
Use CData Sync for automated, continuous, customizable FreeAgent replication to Oracle.
-
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.
-
Automated Continuous Azure Blob Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to SQLite.
-
Connect to Acumatica Data from PowerBuilder via JDBC
This article demonstrates how to access Acumatica data from PowerBuilder using the Acumatica JDBC Driver.
-
Connect to Clockify 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 Clockify and work with Clockify data in your FileMaker application.
-
How to Connect to Live SQL Analysis Services 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 SQL Analysis Services data for you.
-
Access Azure Analysis Services Data from MySQL in PHP
Connect to Azure Analysis Services through the standard MySQL libraries in PHP.
-
ETL PagerDuty in Oracle Data Integrator
This article shows how to transfer PagerDuty data into a data warehouse using Oracle Data Integrator.
-
Connect to Typeform Data from PowerBuilder via ADO.NET
This article demonstrates how to access Typeform data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
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.
-
How to Work with SendPulse Data in ETL Validator JDBC
Connect to SendPulse from ETL Validator jobs using the CData Software JDBC Driver.