CData Software - Knowledge Base
Recent Articles
-
Replicate MarkLogic Data in Heroku for Use in Salesforce Connect
Replicate MarkLogic data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to XML from a Connection Pool in WebLogic
Use the CData JDBC Driver for XML to connect to XML data from Web applications running on WebLogic.
-
Integrating Cursor with Miro 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 GitHub Data with Power Map
Create data visualizations with GitHub data in Power Map.
-
Create VWO Dataflows on PowerBI.com
Connect to the CData Power BI Connector for VWO from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect the Power BI Service to Demio: Complete Guide
Connect to the CData Software Power BI Connector for Demio from PowerBI.com to provide real-time Demio data across the organization.
-
Connect to Excel Online 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 Excel Online data.
-
Extract, Transform, and Load Quickbase Data in Informatica PowerCenter
Create a simple Workflow for Quickbase data in Informatica PowerCenter.
-
Integrate Live Scrapfly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Scrapfly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous BambooHR Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable BambooHR replication to Apache Kafka.
-
Connect to and Query Monday.com Data in QlikView over ODBC
Create data visualizations with Monday.com data in QlikView.
-
Analyze SAP SuccessFactors Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP SuccessFactors data with the CData JDBC Driver for SAP SuccessFactors.
-
How to import Access Data into Apache Solr
Use the CData Software JDBC Driver for Access in Data Import Handler and create an automated import of Access data to Apache Solr Enterprise Search platform.
-
Integrating Microsoft Teams Data in Talend Cloud Data Management Platform
Connect Microsoft Teams Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Teams.
-
Connect to Datadog Data from PowerBuilder via JDBC
This article demonstrates how to access Datadog data from PowerBuilder using the Datadog JDBC Driver.
-
Build AI Agents with CouchDB 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 CouchDB data through CData Connect AI.
-
Use Databricks Agent Bricks to Talk to Your HCL Domino Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HCL Domino data for you.
-
Access Live MailChimp Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MailChimp data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a Simple VCL Application for Google Directory Data
How to build a simple VCL Application to view Google Directory data in RAD Studio using the CData ODBC Driver for Google Directory.
-
Create Informatica Mappings From/To an ODBC Data Source for YouTube Analytics
Create an ODBC connection to YouTube Analytics in Informatica and browse and transfer YouTube Analytics data.
-
Use the CData Software JDBC Driver for Gmail in MicroStrategy Web
Connect to Gmail data in MicroStrategy Web using the CData Software JDBC Driver for Gmail.
-
Use CData Connect AI to Access Reckon Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Reckon data in the Power Pivot business intelligence tool.
-
Connect to Figshare in SpagoBI
Create reports featuring live Figshare data in SpagoBI Studio. Host Figshare reports on SpagoBI Server.
-
Replicate Multiple Accelo Accounts via the CData Sync CLI
Replicate multiple Accelo accounts to one or many databases.
-
Work with Live ADP Data in Power Query
Use CData Connect AI to connect to ADP data and work with live ADP data in Microsoft Power Query.
-
Use Dash to Build to Web Apps on Nethunt Data
Create Python applications that use pandas and Dash to build Nethunt-connected web apps.
-
Automated Continuous DB2 for i Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable DB2 for i replication to Apache Cassandra.
-
Integrating Codex with Twilio 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 Teamwork-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teamwork data.
-
Automated Continuous Dynamics NAV Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to PostgreSQL.
-
Getting Started with the CData Power BI Connector for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Smartsheet.
-
Bidirectional Access to WordPress Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate WordPress data in Filemaker Pro for Mac or Windows.
-
Connect to Google Sheets Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Sheets data in Google Apps Script.
-
Connect to Figshare Data in JRuby
Create a simple JRuby app with access to live Figshare data.
-
Analyze GetResponse Data in Looker
Use CData Connect AI to connect to GetResponse Data from Looker and build custom apps using live GetResponse data.
-
Connect to Odoo Data in CloverDX (formerly CloverETL)
Transfer Odoo data using the visual workflow in the CloverDX data integration tool.
-
Create a Data Access Object for GraphQL Data using JDBI
A brief overview of creating a SQL Object API for GraphQL data in JDBI.
-
Build Data Flows from SendPulse to SQL Server using SSIS
Easily back up SendPulse data to SQL Server using the SSIS components for SendPulse.
-
A PostgreSQL Interface for Sage 200 Data using the CData ODBC Driver
Use the SQL Gateway and Sage 200 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live SAP ByDesign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP ByDesign data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Salesforce Marketing Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Oracle.
-
Getting Started with the CData JDBC Driver for Asana
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Asana.
-
Use Dash to Build to Web Apps on Impala Data
Create Python applications that use pandas and Dash to build Impala-connected web apps.
-
Create Salesforce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Data from OutSystems and build custom enterprise apps using live Salesforce data.
-
Connect to Okta Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Okta Data and connect to Okta data in Akorbi Digital RunMyProcess.
-
Connect to and Query RabbitMQ Data in QlikView over ODBC
Create data visualizations with RabbitMQ data in QlikView.
-
Access Google Calendar Data from MySQL in Amazon QuickSight
Connect to Google Calendar and build visualizations of Google Calendar data using a MySQL Connection in Amazon QuickSight.
-
Integrate Figshare Data in Pentaho Data Integration
Build ETL pipelines based on Figshare data in the Pentaho Data Integration tool.
-
Integrate ChartMogul Data in the Pentaho Report Designer
Publish reports based on ChartMogul data in the Pentaho BI tool.
-
Replicate Oracle Eloqua Data to Multiple Databases
Replicate Oracle Eloqua data to disparate databases with a point-and-click configuration.
-
Create Microsoft Entra ID-Connected Applications in Appsmith
Connect to Microsoft Entra ID Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Entra ID data.
-
Connect to SAP HANA Data in RazorSQL
Connect to SAP HANA from wizards and query SAP HANA data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Freshservice Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshservice replication to PostgreSQL.
-
Build Apps with Live SuiteCRM Data Using the Low-Code Development Platform of Mendix
Connect SuiteCRM data with Mendix to build apps using the CData JDBC Driver for SuiteCRM.
-
Moving Data from Google Search to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Search data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated Workflows with Live Google Spanner Data in Workato
Use CData Connect AI to connect to live Google Spanner data and build automated workflows in Workato.
-
Import Real-Time REST Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use REST data in ColdFusion.
-
How to integrate CouchDB with Apache Airflow
Access and process CouchDB data in Apache Airflow using the CData JDBC Driver.
-
Access Templated Data from MySQL in Amazon QuickSight
Connect to Templated and build visualizations of Templated data using a MySQL Connection in Amazon QuickSight.
-
Connect to Wave Financial Data in CloverDX (formerly CloverETL)
Transfer Wave Financial data using the visual workflow in the CloverDX data integration tool.
-
Load Dotmailer Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dotmailer data to a database.
-
Build Certinia Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Certinia data and build visualizations in Tableau.
-
Getting Started with the CData ADO.NET Provider for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Adobe Experience Manager.
-
How to Connect DBeaver to Elorus via a JDBC Driver
Manage Elorus data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Perplexity in MicroStrategy Web
Connect to Perplexity data in MicroStrategy Web using the CData Software ODBC Driver for Perplexity.
-
Visualize Salesforce CRM Analytics 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 Salesforce CRM Analytics data into TIBCO Spotfire.
-
Automate Oracle Eloqua Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Eloqua data replication to Azure Data Lake.
-
Build Salesforce CRM Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce CRM Analytics Data and create custom apps in Mendix.
-
Excel Spreadsheet Automation on MailerLite Data with the QUERY Formula
Pull data from MailerLite, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Excel in MicroStrategy Web
Connect to Excel data in MicroStrategy Web using the CData Software ODBC Driver for Excel.
-
Access Live SurveyMonkey Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SurveyMonkey data through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks data to SQL Server.
-
How to import Microsoft Planner Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Planner in Data Import Handler and create an automated import of Microsoft Planner data to Apache Solr Enterprise Search platform.
-
Automated Continuous Toggl Replication to SQLite
Use CData Sync for automated, continuous, customizable Toggl replication to SQLite.
-
Automate Intercom Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Intercom data from PowerShell? This article demonstrates how to utilize the Intercom Cmdlets for tasks like connecting to Intercom data, automating operations, downloading data, and more.
-
How to load Webflow data into Elasticsearch via Logstash
Introducing a simple method to load Webflow data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Codex with Reckon 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.
-
Access Live BigQuery Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BigQuery data from your Google Sheets.
-
Build a Simple VCL Application for Shopify Data
How to build a simple VCL Application to view Shopify data in RAD Studio using the CData ODBC Driver for Shopify.
-
How to Connect to Aweber Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Aweber data. Leverage the pyodbc module for ODBC in Python.
-
Access RSS Feeds as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access RSS feeds from your Oracle system.
-
Connecting Mastra with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Spark data, no replication required.
-
Replicate Multiple Databricks Accounts
Replicate multiple Databricks accounts to one or many databases.
-
Access Live ZohoExpense Data in Coginiti Pro
Connect to and query live ZohoExpense data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Stack Exchange Data in AWS Lambda
Connect to live Stack Exchange data in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import PabblySubscriptions Data into IBM SPSS Modeler
Integrate PabblySubscriptions data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PabblySubscriptions Data in DBArtisan
Use wizards in DBArtisan to configure PabblySubscriptions data as a data source.
-
How to connect to Vault CRM Data in DBVisualizer
Integrate Vault CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for Datadog
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Datadog.
-
Replicate Multiple Wrike Accounts
Replicate multiple Wrike accounts to one or many databases.
-
Explore Geographical Relationships in Google Tasks Data with Power Map
Create data visualizations with Google Tasks data in Power Map.
-
Easily Integrate CSV Data in Lazarus Pascal IDE
Learn how to easily integrate live CSV data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Manage Invoiced Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Invoiced.
-
Integrate with Zoho Books Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Books data in SnapLogic.
-
Connect to YouTube Analytics in SpagoBI
Create reports featuring live YouTube Analytics data in SpagoBI Studio. Host YouTube Analytics reports on SpagoBI Server.
-
Access Live Bugsnag Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bugsnag data into the statistical analysis tools available in SAS JMP. This article shows how to use Bugsnag data in the Graph Builder and Query Builder.
-
Viewing Clari Data in RAD Studio Data Explorer
How to view Clari data in RAD Studio Data Explorer using the CData ODBC Driver for Clari.
-
Automated Continuous ScrapingBee Replication to Vertica
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Vertica.
-
Use the CData ODBC Driver for Outreach.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outreach.io data in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for BenchmarkEmail
Create an ODBC connection to BenchmarkEmail in Informatica and browse and transfer BenchmarkEmail data.