CData Software - Knowledge Base
Recent Articles
-
How to create PayPal federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PayPal data in MySQL .
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 200
Create an ODBC connection to Sage 200 in Informatica and browse and transfer Sage 200 data.
-
Build Snowflake Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Snowflake data and build visualizations in Tableau Cloud.
-
How to connect to SAP Business Warehouse Data from IntelliJ
Integrate connectivity to SAP Business Warehouse data with wizards in IntelliJ.
-
Connect to Smartsheet Data in NetBeans
Connect to Smartsheet data in NetBeans with the data source configuration wizard.
-
Migrating data from Deel to Snowflake using CData SSIS Components.
Easily push Deel data to Snowflake using the CData SSIS Tasks for Deel and Snowflake.
-
Use Dash to Build to Web Apps on Oracle Financials Cloud Data
Create Python applications that use pandas and Dash to build Oracle Financials Cloud-connected web apps.
-
Operational Reporting on Accelo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Accelo data.
-
Automated Continuous Shopify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Shopify replication to Apache Cassandra.
-
Automated Continuous HCL Domino Replication to Vertica
Use CData Sync for automated, continuous, customizable HCL Domino replication to Vertica.
-
How to connect SharePoint with SAP Business Warehouse Data through external lists
Provide SAP Business Warehouse data to SharePoint users as an external list.
-
Visualize Telegram Data in Sisense
Create an ElastiCube in Sisense app with access to Telegram data.
-
Automated Continuous Dynamics CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to AlloyDB.
-
How to import Oracle HCM Cloud Data into Apache Solr
Use the CData Software JDBC Driver for Oracle HCM Cloud in Data Import Handler and create an automated import of Oracle HCM Cloud data to Apache Solr Enterprise Search platform.
-
Connect to Real-Time HubDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HubDB and Dataflow to import and use HubDB data in Power Apps.
-
Integrating GitHub Copilot with OData services 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.
-
Establish a Live Connection with Notion Data using Tableau Bridge
The CData ODBC Driver for Notion enables you to integrate live Notion data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to HubDB Data from AWS Glue
Use CData Connect AI to gain access to live HubDB data from your AWS Glue jobs.
-
Build Apps with Live EmailOctopus Data Using the Low-Code Development Platform of Mendix
Connect EmailOctopus data with Mendix to build apps using the CData API Driver for JDBC.
-
LINQ to Cassandra Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Cassandra Data Provider.
-
Load RSS Feeds to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load RSS feeds to a database.
-
Connect to HBase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to HBase.
-
Seamlessly Bring Google Contacts Data into Retool Using CData Connect AI
Integrate Google Contacts data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Cloudflare Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cloudflare Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Spotify Data from PowerBuilder via JDBC
This article demonstrates how to access Spotify data from PowerBuilder using the Spotify JDBC Driver.
-
Automate Microsoft Dataverse Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dataverse data replication to Couchbase.
-
Viewing OneNote Data in RAD Studio Data Explorer
How to view OneNote data in RAD Studio Data Explorer using the CData ODBC Driver for OneNote.
-
Connect to Sage Cloud Accounting Data from a Connection Pool in Jetty
The Sage Cloud Accounting JDBC Driver supports connection pooling: This article shows how to connect faster to Sage Cloud Accounting data from Web apps in Jetty.
-
Getting Started with the CData ADO.NET Provider for HubDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HubDB.
-
Deploy the ADO.NET Provider for Freshteam on an SSRS Report Server
Connect to Freshteam data 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.
-
Automated Continuous SAP Business One Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Business One replication to Google BigQuery.
-
Query Live Aweber 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 Aweber data through a conversational interface.
-
Connecting Moonlit Workflow with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Eloqua data in real time.
-
Build Google Sheets-Connected Apps in Choreo
Use CData Connect AI to connect to Google Sheets Data from Choreo and build custom apps using live Google Sheets data.
-
Connect to Wistia Data in CloverDX (formerly CloverETL)
Transfer Wistia data using the visual workflow in the CloverDX data integration tool.
-
LINQ to Webflow Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Webflow Data Provider.
-
Use the CData ODBC Driver for Couchbase in Microsoft Power Query
You can use the CData Couchbase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Couchbase data into Microsoft Power Query.
-
Configure the CData JDBC Driver for Perigon in a Connection Pool in Tomcat
Connect to Perigon data from a connection pool in Tomcat.
-
Automated Continuous LinkedIn Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LinkedIn replication to Amazon Redshift.
-
Use Claude to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Hybris C4C data for you.
-
Rapidly Develop Oracle HCM Cloud-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 Oracle HCM Cloud.
-
Build Facebook-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Facebook Data and create custom apps in Bubble.
-
Integrating Antigravity CLI with OpenWeatherMap data via CData CLI
Connect OpenWeatherMap data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid
Learn how you can connect Avalara AvaTax to Infragistics XamDataGrid to build dynamic grids.
-
Access Recurly 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 Recurly data.
-
How to connect to MailerLite Data from Spring Boot
Connect to MailerLite in a Spring Boot Application using the CData API Driver for JDBC
-
Replicate Multiple Invoiced Accounts via the CData Sync CLI
Replicate multiple Invoiced accounts to one or many databases.
-
Build Cloudflare-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Cloudflare data and build web apps with connectivity to live Cloudflare data.
-
How to connect to REST Data from Spring Boot
Connect to REST in a Spring Boot Application using the CData JDBC Driver for REST
-
Build Outlook-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Outlook data and build web apps with connectivity to live Outlook data.
-
Easily Integrate Keap Data in Lazarus Pascal IDE
Learn how to easily integrate live Keap data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect and process MailChimp data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailChimp data.
-
Deploy the ADO.NET Provider for Pipeliner CRM on an SSRS Report Server
Connect to Pipeliner CRM data 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.
-
Consume Jira Assets OData Feeds in PowerBuilder
This article demonstrates how to consume Jira Assets data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Stripe Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stripe replication to Apache Cassandra.
-
Create Data Visualizations Based On Square Data in Mode
Use CData Connect AI to connect to Square Data from Mode and build visualizations using live Square data.
-
Getting Started with the CData SSIS Components for Monday.com
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Monday.com.
-
Connect to Sendwithus Data from a Connection Pool in Jetty
The Sendwithus JDBC Driver supports connection pooling: This article shows how to connect faster to Sendwithus data from Web apps in Jetty.
-
Build Charts with SurveyMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on SurveyMonkey data in Clear Analytics.
-
Connect to Real-Time Hubstaff Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hubstaff data in Power Apps.
-
Rapidly Develop ChartMogul-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 ChartMogul.
-
Build Automated Authorize.Net-Connected Workflows in Zapier
Use CData Connect AI to connect to live Authorize.Net data and build automated workflows in Zapier.
-
Integrating Antigravity CLI with Microsoft Planner data via CData CLI
Connect Microsoft Planner data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Oracle SCM in MicroStrategy Desktop
Connect to Oracle SCM data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle SCM.
-
Access Microsoft Ads 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 Microsoft Ads data.
-
Query PingOne Data in DataGrip
Create a Data Source for PingOne in DataGrip and use SQL to query live PingOne data.
-
Integrate Azure Table with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Table with External Services.
-
Build MongoDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MongoDB data.
-
Connect to Jodoo Data in RapidMiner
Integrate Jodoo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Migrating data from BambooHR to Databricks using CData SSIS Components.
Easily push BambooHR data to Databricks using the CData SSIS Tasks for BambooHR and Databricks.
-
Create Informatica Mappings From/To a JDBC Data Source for PostgreSQL
Create PostgreSQL data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Paymo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Paymo replication to Amazon S3.
-
Getting Started with the CData Python Connector for Wave Financial
Learn to install and license the CData Python Connector and configure a connection to live Wave Financial data.
-
How to integrate Metabase with Dropbox Data
Use CData Connect AI to connect to live Dropbox data and create an interactive dashboard in Metabase from Dropbox data.
-
Load SAS xpt Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAS xpt data to a database.
-
Use the CData Software ODBC Driver for Mixpanel in MicroStrategy
Connect to Mixpanel data in MicroStrategy Developer using the CData Software ODBC Driver for Mixpanel.
-
Automated Continuous SAP ByDesign Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Databricks.
-
Connect to Oracle Financials Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Financials Cloud data as a data source.
-
Query Excel Online Data as a SQL Server Database in Node.js
Execute SQL Server queries against Excel Online data from Node.js.
-
How to Connect to Live DB2 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live DB2 data securely in real time.
-
Create Oracle SCM-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle SCM Data from Nintex Workflow Cloud and build custom workflows using live Oracle SCM data.
-
Automate SAP Business One Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Business One data from PowerShell? This article demonstrates how to utilize the SAP Business One Cmdlets for tasks like connecting to SAP Business One data, automating operations, downloading data, and more.
-
Automated Continuous Printify Replication to MySQL
Use CData Sync for automated, continuous, customizable Printify replication to MySQL.
-
Connect to Contentful Data in Ruby
Connect to Contentful data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Pipelines with Live Google Campaign Manager 360 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Campaign Manager 360 from Google Cloud Data Fusion, enabling the integration of live Google Campaign Manager 360 data into the building and management of effective data pipelines.
-
How to update Microsoft Entra ID from Excel
This article explains how to transfer data from Excel to Microsoft Entra ID using the Excel Add-In for Microsoft Entra ID.
-
Integrate Everhour Data in Pentaho Data Integration
Build ETL pipelines based on Everhour data in the Pentaho Data Integration tool.
-
Connect to Certinia Data in Google Apps Script via Connect AI
Use CData Connect AI to access Certinia data in Google Apps Script.
-
Automate FHIR Data Replication to SAP HANA
Use CData Sync to customize and automate FHIR data replication to SAP HANA.
-
How to Connect to ShipStation Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ShipStation data. Leverage the pyodbc module for ODBC in Python.
-
Building Dynamic Web Pages with EnterpriseDB Data Using AngularJS
Create single-page applications with live connectivity to EnterpriseDB using the CData API Server.
-
Integrating Cursor with Active Directory 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.
-
Design BIRT Reports on IBM Cloud Object Storage Data
Provide current IBM Cloud Object Storage data to your embedded analytics.
-
Connect to Tally Data in CloverDX (formerly CloverETL)
Transfer Tally data using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time Aircall Data in Power BI Report Server
Use the CData ODBC Driver for Aircall to visualize Aircall data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to AfterShip Data in DBArtisan
Use wizards in DBArtisan to configure AfterShip data as a data source.
-
Build MVC Applications with Connectivity to ZeroBounce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZeroBounce from an ASP.NET MVC application.
-
Analyze SendGrid Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendGrid data in Microsoft R Open.
-
Link Eventbrite with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Eventbrite data in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Zoho CRM Data using Tableau Bridge
The CData ODBC Driver for Zoho CRM enables you to integrate live Zoho CRM data into Tableau Cloud dashboards using the Tableau Bridge.