CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for Placid
Create an ODBC connection to Placid in Informatica and browse and transfer Placid data.
-
Automated Continuous Hubstaff Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Hubstaff replication to Apache Kafka.
-
How to connect and process Snowflake data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snowflake data.
-
Automated Continuous Oracle Sales Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Cassandra.
-
Work with Live Act CRM Data in Power Query
Use CData Connect AI to connect to Act CRM data and work with live Act CRM data in Microsoft Power Query.
-
Automated Continuous Greenplum Replication to SQL Server
Use CData Sync for automated, continuous, customizable Greenplum replication to SQL Server.
-
Stream JSON Services into Apache Kafka Topics
Access and stream JSON services in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query SharePoint Data as a MySQL Database in Node.js
Execute MySQL queries against SharePoint data from Node.js.
-
How to Access Live Discourse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Discourse enables you to integrate Discourse data into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for SendInBlue Data using the CData ODBC Driver
Use the SQL Gateway and SendInBlue ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Rebilly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Rebilly data.
-
Automated Continuous MessageBird Replication to Oracle
Use CData Sync for automated, continuous, customizable MessageBird replication to Oracle.
-
Add Procore Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Procore with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous SpaceX Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SpaceX data replication to OneLake in Microsoft Fabric.
-
Connect to Datadog in SpagoBI
Create reports featuring live Datadog data in SpagoBI Studio. Host Datadog reports on SpagoBI Server.
-
Access Live Opsgenie Data in Coginiti Pro
Connect to and query live Opsgenie data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Paylocity Data in TIBCO Spotfire through ADO.NET
Integrate Paylocity data into dashboards in TIBCO Spotfire.
-
Replicate Multiple Cohere Accounts via the CData Sync CLI
Replicate multiple Cohere accounts to one or many databases.
-
Use ChatGPT to Talk to Your SAP Fieldglass 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 SAP Fieldglass data for you.
-
Extract, Transform, and Load ServiceNow Data in Informatica PowerCenter
Create a simple Workflow for ServiceNow data in Informatica PowerCenter.
-
Getting Started with the CData JDBC Driver for Drip
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Drip.
-
Build Dashboards with Zoho CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho CRM data in Dundas BI.
-
Visualize Live Reckon Data in the Power BI Service
Use CData Connect AI to connect to live Reckon data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to load Salesforce Marketing data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Marketing data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Extract, Transform, and Load Mouseflow Data in Informatica PowerCenter
Create a simple Workflow for Mouseflow data in Informatica PowerCenter.
-
Consume Google Calendar OData Feeds in PowerBuilder
This article demonstrates how to consume Google Calendar data as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy Web
Connect to Rootly data in MicroStrategy Web using the CData Software JDBC Driver for Rootly.
-
ZohoSubscriptions Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ZohoSubscriptions data through CData Connect AI using different applications and tools.
-
Access Nuclia Data from MySQL in Amazon QuickSight
Connect to Nuclia and build visualizations of Nuclia data using a MySQL Connection in Amazon QuickSight.
-
Connecting Pipedream with Instagram 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 Instagram data in real time.
-
Access Zoho Recruit Data from MySQL in Amazon QuickSight
Connect to Zoho Recruit and build visualizations of Zoho Recruit data using a MySQL Connection in Amazon QuickSight.
-
Query Sugar CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sugar CRM data from Node.js.
-
Migrating data from BigCommerce to Databricks using CData SSIS Components.
Easily push BigCommerce data to Databricks using the CData SSIS Tasks for BigCommerce and Databricks.
-
Integrate Zuora with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zuora with External Services.
-
Use Manus AI to Talk to Your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Marketo data.
-
Connect to MailerLite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailerLite data.
-
Query Recurly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Recurly data from Node.js.
-
How to load Greenhouse data into Elasticsearch via Logstash
Introducing a simple method to load Greenhouse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to ConstantContact Data in Jaspersoft Studio
Execute SQL to remote ConstantContact data in Jaspersoft Studio.
-
Connect to Excel Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Excel Online and the Script function in FileMaker Pro to connect to Excel Online and work with Excel Online data in your FileMaker application.
-
Connect to AdRoll Data in RapidMiner
Integrate AdRoll data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Seamlessly Import ConvertKit Data into IBM SPSS Modeler
Integrate ConvertKit data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Multiple Bullhorn CRM Accounts via the CData Sync CLI
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
How to Visualize Dynamics CRM 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 Dynamics CRM data in Python.
-
Create Microsoft Dataverse-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Dataverse Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Dataverse data.
-
Getting Started with the CData JDBC Driver for Parquet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Parquet.
-
Integrate Cline with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle HCM Cloud data from within your IDE.
-
Object-Relational Mapping (ORM) with WordPress 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 WordPress data into a Java-based ORM framework, Hibernate.
-
Integrating LangChain with Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Timely data within automated workflows.
-
Access Live SharePoint Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SharePoint data through MCP integration.
-
Automated Continuous Amazon S3 Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon S3 replication to SQLite.
-
Integrate OnePageCrm with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OnePageCrm with External Services.
-
How to Connect to Live Figshare Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Figshare data for you.
-
Automated Continuous Smartsheet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Smartsheet replication to Snowflake.
-
How to update SingleStore from Excel
This article explains how to transfer data from Excel to SingleStore using the Excel Add-In for SingleStore.
-
Connect to Microsoft Planner Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Planner data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Planner.
-
How to Connect to Flowlu Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Flowlu data. Leverage the pyodbc module for ODBC in Python.
-
How to Visualize MailChimp Data in Python with pandas
Use pandas and other modules to analyze and visualize live MailChimp data in Python.
-
Add Deel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Deel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Snowflake Data in Pentaho Data Integration
Build ETL pipelines based on Snowflake data in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from Egnyte Data
Establish a connection to Egnyte data data from SQL Server Analysis Services, and use the Egnyte Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live MariaDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MariaDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to RabbitMQ Data in C++Builder
DataBind to RabbitMQ data in C++Builder with standard components and controls.
-
Automate Zoho CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho CRM data replication to Azure Synapse.
-
Bidirectional Access to LDAP Objects from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LDAP objects in Filemaker Pro for Mac or Windows.
-
Create Datasets from CapsuleCRM in Domo Workbench and Build Visualizations of CapsuleCRM Data in Domo
Use the CData Software ODBC Driver for CapsuleCRM to create datasets from CapsuleCRM data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Float Replication to MySQL
Use CData Sync for automated, continuous, customizable Float replication to MySQL.
-
Query, Visualize, and Share live Dynamics CRM Data in Redash
Use CData Connect AI to connect to live Dynamics CRM data in Redash for querying, visualizing, and sharing.
-
Integrate Trae with Live Square Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Square data from within the AI-powered IDE.
-
Connect to Amazon Athena Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Athena data.
-
Getting Started with the CData Tableau Connector for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access SAP Ariba Source Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Ariba Source data from your Oracle system.
-
Automated Continuous SAP Hybris C4C Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Databricks.
-
Connect to Avaza Data from PowerBuilder via JDBC
This article demonstrates how to access Avaza data from PowerBuilder using the Avaza JDBC Driver.
-
Bind Live Paylocity Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Paylocity data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Visualizations of CapsuleCRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CapsuleCRM data in Birst.
-
Query Email Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Email data from Node.js.
-
Build Sage Cloud Accounting-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage Cloud Accounting data.
-
Replicate ScrapingBee Data from PowerShell
Write a quick PowerShell script to query ScrapingBee data. Use connectivity to the live data to replicate ScrapingBee data to SQL Server.
-
Excel Spreadsheet Automation on BigCommerce Data with the QUERY Formula
Pull data from BigCommerce, automate spreadsheets, and more with the QUERY formula.
-
Query, Visualize, and Share live Microsoft Teams Data in Redash
Use CData Connect AI to connect to live Microsoft Teams data in Redash for querying, visualizing, and sharing.
-
Build Dashboards with Google Cloud Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Cloud Storage data in Dundas BI.
-
Build a Singer.io Tap for Trello With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Trello data using the CData Python Connector.
-
How to Connect to Redis Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Redis data. Leverage the pyodbc module for ODBC in Python.
-
Build Charts with EnterpriseDB Data in Clear Analytics
Create dynamic charts and perform analytics based on EnterpriseDB data in Clear Analytics.
-
Automated Outreach.io Data Replication to Teradata
Use CData Sync to Customize and automate Outreach.io data replication to Teradata.
-
Integrating Antigravity CLI with Reply.io data via CData CLI
Connect Reply.io data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect SharePoint with Google Sheets Data through external lists
Provide Google Sheets data to SharePoint users as an external list.
-
How to Connect to Live Guru Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Guru data for you.
-
Connect ZarMoney to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZarMoney with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData JDBC Driver for TigerGraph
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for TigerGraph.
-
Getting Started with the CData ADO.NET Provider for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for QuickBooks Time.
-
Integrate Live Databricks Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Databricks data to Blue Prism using the CData ODBC Driver for Databricks to create automated workflows for repetitive business tasks.
-
Access Live Bitbucket Data in Excel 365 Online (Excel for the web)
Connect to Bitbucket data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate Beeminder Data Replication to Azure Synapse
Use CData Sync to customize and automate Beeminder data replication to Azure Synapse.
-
Create Paymo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Paymo Data from Klipfolio and build custom visualizations using live Paymo data.
-
How to Connect to Live Guru Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Guru data without replication.
-
How to Build an ETL App for ShipEngine Data in Python with CData
Create ETL applications and real-time data pipelines for ShipEngine data in Python with petl.
-
Automated Continuous Opsgenie Replication to MongoDB
Use CData Sync for automated, continuous, customizable Opsgenie replication to MongoDB.
-
Stream Microsoft Teams Data into Apache Kafka Topics
Access and stream Microsoft Teams data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.