CData Software - Knowledge Base
Recent Articles
-
Connect to Pipeliner CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pipeliner CRM to connect to Pipeliner CRM and execute queries in PowerBuilder.
-
Automated Continuous Elorus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Elorus replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for SendInBlue
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect and process NASA from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live NASA.
-
Automated Cvent Data Replication to Teradata
Use CData Sync to Customize and automate Cvent replication to Teradata.
-
Automated Continuous ChargeOver Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ChargeOver replication to Google BigQuery.
-
Analyze Pipedrive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipedrive in Microsoft R Open.
-
Use the CData Software ODBC Driver for Nethunt in MicroStrategy Desktop
Connect to Nethunt in MicroStrategy Desktop using the CData Software ODBC Driver for Nethunt.
-
How to Query Humanity Data in MySQL Workbench
Execute MySQL queries against live Humanity from MySQL Workbench.
-
Integrate Cursor with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Gmail from within the editor.
-
Connect SAP Ariba Source to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Ariba Source with IBM WebSphere for seamless data integration and connectivity.
-
Build Visualizations of ZohoExpense Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoExpense in Birst.
-
How to Build an ETL App for Spotify Data in Python with CData
Create ETL applications and real-time data pipelines for Spotify in Python with petl.
-
Visualize LionDesk Data in TIBCO Spotfire through ADO.NET
Integrate LionDesk into dashboards in TIBCO Spotfire.
-
Create Datasets from Testmonitor in Domo Workbench and Build Visualizations of Testmonitor Data in Domo
Use the CData Software ODBC Driver for Testmonitor to create datasets from Testmonitor in Domo Workbench and then build visualizations in the Domo service.
-
Connect to SingleStore Data in Claris FileMaker Pro
Use the CData ODBC Driver for SingleStore in FileMaker Pro to connect to SingleStore and work with SingleStore in your FileMaker applications.
-
Visualize Sage 300 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage 300.
-
Build Dashboards with Pinecone Data in DBxtra
Create dynamic dashboards and perform analytics based on Pinecone in DBxtra.
-
Explore Geographical Relationships in OpenWeatherMap Data with Power Map
Create data visualizations with OpenWeatherMap in Power Map.
-
Analyze HubDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HubDB in Microsoft R Open.
-
Automate Stripe Data Replication to Azure Synapse
Use CData Sync to customize and automate Stripe replication to Azure Synapse.
-
Connect to Foursquare from Asprova with CData Software ODBC Driver for Foursquare
This article shows how to connect faster to Foursquare data from Asprova.
-
Back Up Couchbase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Couchbase. In this article, we will employ an SSIS workflow to populate a database with Couchbase data.
-
Create Power BI Reports on Real-Time Zoho Projects Data
Use the CData ODBC Driver for Zoho Projects to visualize Zoho Projects in Power BI Desktop.
-
Visualize Live ShipEngine Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ShipEngine.
-
Connect to Tickspot Data in JRuby
Create a simple JRuby app with access to live Tickspot.
-
Build AI/ML Models with Live Bugsnag Data using Dataiku
Connect Bugsnag Data with Dataiku using the CData API Driver for JDBC.
-
Use ChatGPT to Talk to Your Odoo 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 Odoo ERP for you.
-
Integrate Samanage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Samanage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Samanage.
-
Automated Continuous Quickbase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Quickbase replication to delimited files (CSV/TSV).
-
Automate LightSpeedRetail Data Replication to Azure Synapse
Use CData Sync to customize and automate LightSpeedRetail replication to Azure Synapse.
-
How to connect PolyBase to Pingdom
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pingdom.
-
How to Seamlessly Import Teradata Data into IBM SPSS Modeler
Integrate Teradata data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Google Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Analytics with the CData JDBC Driver for Google Analytics.
-
How to Connect to & Open Google Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for Google Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Microsoft OneDrive Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft OneDrive and visualize live Microsoft OneDrive in Infragistics Reveal.
-
How to connect and process Bugsnag from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bugsnag.
-
Connect to MailChimp Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailChimp.
-
How to Query Live Power BI XMLA Data in Perplexity MacOS Desktop
Connect to and query live Power BI XMLA Data in Perplexity Desktop using CData MCP Server.
-
Create Dynamic Mocean Grids Using the Infragistics XamDataGrid
Learn how you can connect Mocean to Infragistics XamDataGrid to build dynamic grids.
-
Query SAP HANA Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP HANA from Node.js.
-
Automate CampaignMonitor Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CampaignMonitor from PowerShell? This article demonstrates how to utilize the CampaignMonitor Cmdlets for tasks like connecting to CampaignMonitor, automating operations, downloading data, and more.
-
How to Design Kintone Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Kintone from mobile and tablet Power Apps.
-
Build Dashboards with Rebilly Data in DBxtra
Create dynamic dashboards and perform analytics based on Rebilly in DBxtra.
-
How to load Microsoft Planner data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Planner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Charts to Bugsnag Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bugsnag from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect to & Open ZohoInvoice Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoInvoice to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish Crystal Reports on MailChimp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MailChimp.
-
Use the CData Software JDBC Driver for Nuclia in MicroStrategy
Connect to Nuclia in MicroStrategy Developer using the CData Software JDBC Driver for Nuclia.
-
How to create Reckon federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon in MySQL .
-
Getting Started with the CData Python Connector for Excel Online
Learn to install and license the CData Python Connector
-
Query Authorize.Net Data in DataGrip
Create a Data Source for Authorize.Net in DataGrip and use SQL to query live Authorize.Net.
-
How to Access Live Redis Data in Visual Studio Code via Cline
Run CData MCP Server for Redis on Windows Subsytem for Linux (WSL) and connect to live Redis from the Cline extension in Visual Studio Code.
-
Automated Continuous Shortcut Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shortcut replication to AlloyDB.
-
Visualize Toggl Data in Sisense
Create an ElastiCube in Sisense app with access to Toggl.
-
Integrating Antigravity CLI with Flowlu via CData CLI
Connect Flowlu to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to create an RPA flow for Teamwork Data in UiPath Studio
Use the Teamwork ODBC Driver to create workflows that access real-time Teamwork without any coding.
-
Query Salesforce Marketing Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Marketing Cloud from Node.js.
-
How to Work with Bitbucket Data in AWS Glue Jobs Using JDBC
Connect to Bitbucket from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous CockroachDB Replication to SQLite
Use CData Sync for automated, continuous, customizable CockroachDB replication to SQLite.
-
View Reports on Real-Time JotForm Data in Power BI Report Server
Use the CData ODBC Driver for JotForm to visualize JotForm in Power BI Desktop and then publish them to Power BI Report Server.
-
Prepare, Blend, and Analyze Epicor Kinetic Data in Alteryx Designer (Connect AI)
Build workflows to access live Epicor Kinetic for self-service data analytics.
-
Automated Continuous HBase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache HBase replication to OneLake in Microsoft Fabric.
-
How to connect to HDFS Data in DBVisualizer
Integrate Apache HDFS with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Redshift Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Redshift as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Telegram
Provide connectivity to Telegram through an SAP BusinessObjects universe.
-
Enable the Dynamics 365 Business Central JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dynamics 365 Business Central.
-
Access Live Mouseflow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mouseflow into the statistical analysis tools available in SAS JMP. This article shows how to use Mouseflow in the Graph Builder and Query Builder.
-
Automated SAP HANA XS Advanced Data Replication to Teradata
Use CData Sync to Customize and automate SAP HANA XS Advanced replication to Teradata.
-
Connect to Real-Time Avaza Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Avaza in Power Apps.
-
Connect to Box Data from HeidiSQL
Use CData Connect AI to connect to and query live Box from HeidiSQL.
-
Connect to Google Campaign Manager 360 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Campaign Manager 360.
-
Build a PostgreSQL Interface for QuickBooks Time Data using the CData JDBC Driver
Use the Remoting features of the QuickBooks Time JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to NetSuite Data from PowerBuilder via JDBC
This article demonstrates how to access NetSuite CRM & ERP from PowerBuilder using the NetSuite JDBC Driver.
-
Automate Act-On Data Replication to Azure Synapse
Use CData Sync to customize and automate Act-On replication to Azure Synapse.
-
How to create an RPA flow for Twitter Ads Data in UiPath Studio
Use the Twitter Ads ODBC Driver to create workflows that access real-time Twitter Ads without any coding.
-
Design BIRT Reports on Office 365 Data
Provide current Microsoft Office 365 to your embedded analytics.
-
Integrating Claude Code with MailChimp Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MailChimp within assisted coding and automated development workflows.
-
Automated IBM Informix Data Replication to Teradata
Use CData Sync to Customize and automate IBM Informix replication to Teradata.
-
How to Connect to Elasticsearch Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Elasticsearch. Leverage the pyodbc module for ODBC in Python.
-
ETL Salesforce CRM Analytics in Oracle Data Integrator
This article shows how to transfer Salesforce CRM Analytics into a data warehouse using Oracle Data Integrator.
-
Access Live Neo4J Data in Excel 365 Online (Excel for the web)
Connect to Neo4J from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Webflow Data in NetBeans
Connect to Webflow in NetBeans with the data source configuration wizard.
-
Integrate with Neo4J Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Neo4J to a JSON file on disk.
-
Build Agents in Relevance AI with Access to Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAS Data Sets within intelligent agent workflows.
-
Deploy the ADO.NET Provider for Postmark on an SSRS Report Server
Connect to Postmark from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Act CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Act CRM. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live Stack Exchange Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Stack Exchange to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to and Visualize Live Asana Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Asana.
-
Connect to Strava Data in HULFT Integrate
Connect to Strava as a JDBC data source in HULFT Integrate
-
Use the CData SSIS Components to Insert New or Update Existing JSON Records from SQL Server
Easily push SQL Server data to JSON using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into JSON or update existing records with data from a SQL Server database.
-
How to work with Float Data in Apache Spark using SQL
Access and process Float Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Wave Financial Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Wave Financial replication to PostgreSQL.
-
Integrate Goose with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sage 200 from within the local AI agent.
-
Use Biml to Build SSIS Tasks to Replicate DB2 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM DB2 to SQL Server.
-
Create FTP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FTP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Pipelines with Live GitHub Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GitHub from Google Cloud Data Fusion, enabling the integration of live GitHub into the building and management of effective data pipelines.
-
Automated Continuous SAP Concur Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Concur replication to MySQL.
-
Build Charts with Deel Data in Clear Analytics
Create dynamic charts and perform analytics based on Deel in Clear Analytics.
-
Connect Notion to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Notion using the CData Python MCP Server.