CData Software - Knowledge Base
Recent Articles
-
Access Coinbase Data from MySQL in PHP
Connect to Coinbase through the standard MySQL libraries in PHP.
-
Trigger Oracle Sales IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle Sales with standard wizards in Logic Apps.
-
Create SSAS Tabular Models from Tanda Data
How to build a SQL Server Analysis Service Tabular Model from Tanda using CData drivers.
-
Connect to Salesforce Pardot Data in HULFT Integrate
Connect to Salesforce Pardot as a JDBC data source in HULFT Integrate
-
Connect to Real-Time Dynamics 365 Business Central Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics 365 Business Central and Dataflow to import and use Dynamics 365 Business Central in Power Apps.
-
How to create an RPA flow for Rebilly Data in UiPath Studio
Use the Rebilly ODBC Driver to create workflows that access real-time Rebilly without any coding.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy
Connect to Customer.io in MicroStrategy Developer using the CData Software JDBC Driver for Customer.io.
-
How to update Avalara AvaTax from Excel
This article explains how to transfer data from Excel to Avalara AvaTax using the Excel Add-In for Avalara AvaTax.
-
Easily Integrate Airtable Data in Lazarus Pascal IDE
Learn how to easily integrate live Airtable in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Web
Connect to Authorize.Net in MicroStrategy Web using the CData Software JDBC Driver for Authorize.Net.
-
Automated Continuous Box Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Box replication to AlloyDB.
-
Analyze Mistral AI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mistral AI with the CData JDBC Driver for Mistral AI.
-
Integrating Instagram Data in Talend Cloud Data Management Platform
Connect Instagram Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Instagram.
-
Automated Continuous Pinterest Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pinterest replication to Amazon S3.
-
ETL WooCommerce in Oracle Data Integrator
This article shows how to transfer WooCommerce into a data warehouse using Oracle Data Integrator.
-
Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Data Lake Storage.
-
Visualize Nuclia 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 Nuclia into TIBCO Spotfire.
-
Query Microsoft Exchange Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Exchange from Node.js.
-
Create JSON-Connected Dashboards in Grafana
Connect to JSON Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to JSON.
-
Automated Continuous Act-On Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Act-On replication to AlloyDB.
-
Use the CData ODBC Driver for Cvent from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cvent in Excel.
-
Automated Continuous Freshsales Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshsales replication to AlloyDB.
-
Automated Continuous Splunk Replication to Oracle
Use CData Sync for automated, continuous, customizable Splunk replication to Oracle.
-
How to connect to Gong Data in DBVisualizer
Integrate Gong with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData ODBC Driver for Printful
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printful.
-
Automated Continuous Copper Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Copper replication to Apache Cassandra.
-
Publish Microsoft Planner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Planner.
-
Automate Printify Data Replication to Azure Synapse
Use CData Sync to customize and automate Printify replication to Azure Synapse.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Desktop
Connect to CloudConvert in MicroStrategy Desktop using the CData Software ODBC Driver for CloudConvert.
-
Natively Connect to Act CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Act CRM. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for WooCommerce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for WooCommerce.
-
Access RabbitMQ Data from MySQL in PHP
Connect to RabbitMQ through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Teamwork in MicroStrategy Desktop
Connect to Teamwork in MicroStrategy Desktop using the CData Software ODBC Driver for Teamwork.
-
Automated Continuous Google Cloud Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to PostgreSQL.
-
Explore Geographical Relationships in Jira Assets Data with Power Map
Create data visualizations with Jira Assets in Power Map.
-
How to connect and process Instagram from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instagram.
-
Publish Crystal Reports on Jira Assets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jira Assets.
-
Connect to Gong Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gong Data and connect to Gong in Akorbi Digital RunMyProcess.
-
Build Cloudflare-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Cloudflare Data in Cursor to assist with building Cloudflare-powered applications.
-
Replicate Snapchat Ads Data to Multiple Databases
Replicate Snapchat Ads to disparate databases with a point-and-click configuration.
-
Integrating OpenCode Terminal with Excel Online 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.
-
Load Close Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Close to a database.
-
Integrate VWO with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate VWO with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to VWO.
-
Add QuickBooks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Splunk Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Splunk Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query Presto Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Presto from Node.js.
-
How to Query Live LeadDesk Data in Claude Desktop
Connect to and query live LeadDesk Data in Claude Desktop using CData MCP Server.
-
Integrate LibreChat with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live HCL Domino from within the chat interface.
-
Integrate with EmailOctopus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy EmailOctopus to a JSON file on disk.
-
Create Power BI Reports on Real-Time Greenplum Data
Use the CData ODBC Driver for Greenplum to visualize Pivotal GreenPlum in Power BI Desktop.
-
Connect to Smartsheet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate Multiple Salesforce Accounts
Replicate multiple Salesforce accounts to one or many databases.
-
Create Datasets from Tally in Domo Workbench and Build Visualizations of Tally Data in Domo
Use the CData Software ODBC Driver for Tally to create datasets from Tally ERP in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Salesloft Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesloft. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Tableau Connector for Autopilot
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Google Contacts Data from PowerShell
Write a quick PowerShell script to query Google Contacts. Use connectivity to the live data to replicate Google Contacts to SQL Server.
-
Replicate Reckon Accounts Hosted Data to Multiple Databases via the CData Sync CLI
Replicate Reckon Accounts Hosted to disparate databases with a single configuration.
-
Connect to Confluence Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Atlassian Confluence.
-
Automated Continuous Facebook Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Oracle.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Desktop
Connect to Gong in MicroStrategy Desktop using the CData Software JDBC Driver for Gong.
-
Create Dashboards and Visualize Live Cosmos DB Data in Geckoboard
Use CData Connect AI to connect to live Azure Cosmos DB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect SharePoint with Salesloft Data through external lists
Provide Salesloft to SharePoint users as an external list.
-
How to Import Data from Teradata into Google Sheets
Import Teradata into a Google spreadsheet that is automatically refreshed.
-
Automated Bullhorn CRM Data Replication to Teradata
Use CData Sync to Customize and automate Bullhorn CRM replication to Teradata.
-
Integrate Live Copper Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Copper to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create FHIR-Connected Dashboards in Grafana
Connect to FHIR Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to FHIR.
-
Use the CData API Server to Access Discord Data in Microsoft PowerPivot
Use the CData API Server to connect to live Discord in the Power Pivot business intelligence tool.
-
Visualize Sage Intacct Data in Tableau
The CData ODBC driver for Sage Intacct enables you integrate Sage Intacct into Tableau dashboards.
-
How to integrate Anaplan with Apache Airflow
Access and process Anaplan in Apache Airflow using the CData JDBC Driver.
-
Connect to Epicor Kinetic Data in DBArtisan
Use wizards in DBArtisan to configure Epicor Kinetic as a data source.
-
How to connect to Notion Data from IntelliJ
Integrate connectivity to Notion with wizards in IntelliJ.
-
Visualize Live Nethunt Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Nethunt using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed GitHub to Power BI dashboards. Simply drag and drop GitHub into data visuals on the Power BI canvas.
-
Automate IBM Informix Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM Informix replication to Azure Data Lake.
-
Validate FormSite Data with QuerySurge
Access and validate FormSite in QuerySurge using the CData JDBC Driver.
-
Connect to Demio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Demio as an External Source in Dremio.
-
Automated Continuous Testmonitor Replication to SQLite
Use CData Sync for automated, continuous, customizable Testmonitor replication to SQLite.
-
Automate eBay Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate eBay Analytics replication to Azure Synapse.
-
A PostgreSQL Interface for Figshare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Figshare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Notion Replication to SingleStore
Use CData Sync for automated, continuous, customizable Notion replication to SingleStore.
-
Create SSAS Tabular Models from Planio Data
How to build a SQL Server Analysis Service Tabular Model from Planio using CData drivers.
-
Extract, Transform, and Load ShipStation Data in Informatica PowerCenter
Create a simple Workflow for ShipStation in Informatica PowerCenter.
-
Visualize Cloudant Data in Tableau
The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.
-
Getting Started with the CData Python Connector for Vercel
Learn to install and license the CData Python Connector
-
Query Hubstaff Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Hubstaff and perform CRUD operations on Hubstaff from Node.js.
-
Build MVC Applications with Connectivity to Spotify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spotify from an ASP.NET MVC application.
-
Getting Started with the CData Power BI Connector for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Spanner.
-
Access Live Email 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 Email through MCP integration.
-
Perform Batch Operations with OneNote Data in Apache NiFi
Connect to Microsoft OneNote and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Dataiku with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live YouTube Analytics.
-
Operational Reporting on Vault CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Veeva Vault & Vault CRM.
-
Choosing the Best Method to Connect MailerLite to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailerLite from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Kiro CLI with NASA 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 create Visio diagrams from Workday Data
Automatically update Workday with the changes you make to Visio master shapes.
-
Connect to Salesforce CRM Analytics Data in RapidMiner
Integrate Salesforce CRM Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Easily Query PolarTeamPro Data in OpenOffice Base
Connect to PolarTeamPro data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous LinkedIn Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to AlloyDB.
-
Extract, Transform, and Load FTP Data in Informatica PowerCenter
Create a simple Workflow for FTP Servers in Informatica PowerCenter.
-
Automated Continuous Couchbase Replication to Databricks
Use CData Sync for automated, continuous, customizable Couchbase replication to Databricks.
-
Query Adobe Analytics Data in DataGrip
Create a Data Source for Adobe Analytics in DataGrip and use SQL to query live Adobe Analytics.