CData Software - Knowledge Base
Recent Articles
-
Access Live BigCommerce Data in Excel 365 Online (Excel for the web)
Connect to BigCommerce data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Dotmailer Data Replication to Teradata
Use CData Sync to Customize and automate Dotmailer data replication to Teradata.
-
How to import Odoo Data into Apache Solr
Use the CData Software JDBC Driver for Odoo in Data Import Handler and create an automated import of Odoo data to Apache Solr Enterprise Search platform.
-
Work with Google Tasks Data in FoxPro
Load Google Tasks data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for Square Data in Python with CData Connect AI
Build ETL pipelines that read and write live Square data in Python with petl and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To a JDBC Data Source for Drip
Create Drip data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Open WebUI with Live ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ConstantContact data from within the chat interface.
-
Choosing the Best Method to Connect OnePageCrm to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OnePageCrm data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Sendwithus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sendwithus data and build web apps with connectivity to live Sendwithus data.
-
Connect to SAP HANA XS Advanced Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP HANA XS Advanced data.
-
Model, Search, and Visualize Live Zoho Inventory Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho Inventory data for modeling, searching, and visualizing.
-
Integrate Strava with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Strava with External Services.
-
Connect to EnterpriseDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live EnterpriseDB data.
-
Query Act CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Act CRM data from Node.js.
-
Deploy the ADO.NET Provider for Slack on an SSRS Report Server
Connect to Slack 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.
-
Access Live Amazon Marketplace Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Marketplace data from your Excel spreadsheets.
-
How to Seamlessly Import Amazon S3 Data into IBM SPSS Modeler
Integrate Amazon S3 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Crystal Reports on Sentry Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sentry data.
-
Integrate Raisers Edge NXT Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Raisers Edge NXT data and integrate live Raisers Edge NXT data into your Power Automate tasks.
-
Create Amazon DynamoDB-Connected Business Apps in AppSheet
Connect to Amazon DynamoDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon DynamoDB data.
-
Using the CData Software ODBC Driver for Outlook in PyCharm
Connect to Outlook as an ODBC data source in PyCharm using the CData Software ODBC Driver for Outlook.
-
Extract, Transform, and Load Humanity Data in Informatica PowerCenter
Create a simple Workflow for Humanity data in Informatica PowerCenter.
-
Automated Continuous Oracle SCM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle SCM replication to SingleStore.
-
Connect to Cvent Data from Crystal Reports
Use CData Connect AI to connect to and report on live Cvent data from Crystal Reports.
-
Connect to ScrapingBee in SpagoBI
Create reports featuring live ScrapingBee data in SpagoBI Studio. Host ScrapingBee reports on SpagoBI Server.
-
Automated Continuous Eventbrite Replication to Vertica
Use CData Sync for automated, continuous, customizable Eventbrite replication to Vertica.
-
Visualize Live EmailOctopus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live EmailOctopus data.
-
Create Informatica Mappings From/To a JDBC Data Source for Tally
Create Tally data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Moving Data from Drip to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Drip data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Google Sheets Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Sheets data from HeidiSQL.
-
Use JayDeBeApi to access Gumroad Data in Python
Use standard Python scripting and the development environment of your choice to access live Gumroad data.
-
How to Work with HCL Domino Data in AWS Glue Jobs Using JDBC
Connect to HCL Domino from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for Avro
Create an ODBC connection to Avro in Informatica and browse and transfer Avro data.
-
DataBind Controls to SAP Business One Data in C++Builder
DataBind to SAP Business One data in C++Builder with standard components and controls.
-
Connect to Monday.com Data in ACL Analytics
Connect to Monday.com data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Monday.com data.
-
Connect to Billsby Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Billsby as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Hacker News in SAS for Real-Time Reporting and Analytics
Connect to real-time Hacker News data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hacker News.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy
Connect to Mixpanel data in MicroStrategy Developer using the CData Software JDBC Driver for Mixpanel.
-
Automate Teamwork Data Replication to Couchbase
Use CData Sync to Customize and automate Teamwork data replication to Couchbase.
-
Use Dash to Build to Web Apps on Microsoft OneDrive Data
Create Python applications that use pandas and Dash to build Microsoft OneDrive-connected web apps.
-
Automated Continuous Sendwithus Replication to Oracle
Use CData Sync for automated, continuous, customizable Sendwithus replication to Oracle.
-
ETL Humanity in Oracle Data Integrator
This article shows how to transfer Humanity data into a data warehouse using Oracle Data Integrator.
-
How to Seamlessly Import SAP HANA XS Advanced Data into IBM SPSS Modeler
Integrate SAP HANA XS Advanced data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Prepare, Blend, and Analyze MongoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live MongoDB data for self-service data analytics.
-
Analyze Square Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Square data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous VWO Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable VWO replication to PostgreSQL.
-
Integrating Dataiku with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Authorize.Net data.
-
How to connect to Insightly Data from Spring Boot
Connect to Insightly in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Cursor with Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Guru data from within the editor.
-
Integrate Live Power BI XMLA Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Power BI XMLA data from within the IDE.
-
Work with Live xBase Data in Power Query
Use CData Connect AI to connect to xBase data and work with live xBase data in Microsoft Power Query.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Desktop
Connect to Shippo data in MicroStrategy Desktop using the CData Software JDBC Driver for Shippo.
-
Build MVC Applications with Connectivity to Unbounce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Unbounce from an ASP.NET MVC application.
-
Building Dynamic Web Pages with SAP SuccessFactors LMS Data Using AngularJS
Create single-page applications with live connectivity to SAP SuccessFactors LMS using the CData API Server.
-
Connect and Query Live GitHub Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitHub data into Databricks and enable direct, live querying and analysis without replication.
-
Moving Data from Mistral AI to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mistral AI data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Grok to Talk to Your Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Neo4J data for you.
-
Integrating Antigravity CLI with Vercel data via CData CLI
Connect Vercel data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous FHIR Replication to SQL Server
Use CData Sync for automated, continuous, customizable FHIR replication to SQL Server.
-
Connect to Avro Data in CloverDX (formerly CloverETL)
Transfer Avro data using the visual workflow in the CloverDX data integration tool.
-
Integrate OpenCode with Live SAP Business Warehouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Business Warehouse data from within your AI coding agent.
-
Analyze AdRoll Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AdRoll data in Microsoft R Open.
-
Migrating data from Impala to Snowflake using CData SSIS Components.
Easily push Impala data to Snowflake using the CData SSIS Tasks for Impala and Snowflake.
-
Integrating Cursor with AfterShip 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.
-
Integrate with SAP Fieldglass Data in JReport Designer
Create charts and reports based on SAP Fieldglass data in JReport Designer.
-
Integrating Gumloop with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BigCommerce data within automated workflows.
-
How to connect to Factorial Data from IntelliJ
Integrate connectivity to Factorial data with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access SAP Ariba Procurement Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Ariba Procurement data.
-
Feed Salesforce Data 360 Data into FineReport
How to set Salesforce Data 360 data as a JDBC data source in FineReport.
-
Connect to Impala Data from PowerBuilder via ADO.NET
This article demonstrates how to access Impala data from Appeon PowerBuilder using the CData ADO.NET Provider for Impala.
-
Getting Started with the CData ADO.NET Provider for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Projects.
-
How to Query Live Adobe Experience Manager Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Experience Manager data data in natural language using Python.
-
Access Live SQL Analysis Services Data in Coginiti Pro
Connect to and query live SQL Analysis Services data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live ZendeskSell Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZendeskSell data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search External QuickBooks Online Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks Online data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Online Data objects that you can access from apps and the dashboard.
-
Working with Oracle HCM Cloud Data in LINQPad
Execute LINQ queries to Oracle HCM Cloud data in LINQPad.
-
Integrate Live SAS Data Sets Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAS Data Sets data from within the IDE.
-
How to Query Rebilly Data in MySQL Workbench
Execute MySQL queries against live Rebilly data from MySQL Workbench.
-
Build Apps with Live Xero Data Using the Low-Code Development Platform of Mendix
Connect Xero data with Mendix to build apps using the CData JDBC Driver for Xero.
-
Excel Spreadsheet Automation on Avaza Data with the QUERY Formula
Pull data from Avaza, automate spreadsheets, and more with the QUERY formula.
-
Working with Google Sheets Data in LINQPad
Execute LINQ queries to Google Sheets data in LINQPad.
-
Create HubSpot-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to HubSpot Data from OutSystems and build custom enterprise apps using live HubSpot data.
-
How to Connect to & Open Elorus Data in Microsoft Excel
This article uses the CData ODBC driver for Elorus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google's Vertex AI Agent with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ZohoPeople data within intelligent workflows.
-
Viewing Jira Assets Data in RAD Studio Data Explorer
How to view Jira Assets data in RAD Studio Data Explorer using the CData ODBC Driver for Jira Assets.
-
Create Power BI Reports on Real-Time Discord Data
Use the CData ODBC Driver for Discord to visualize Discord data in Power BI Desktop.
-
Connect and Query Live Zoho Projects Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Projects data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Pinterest Data from PowerBuilder via JDBC
This article demonstrates how to access Pinterest data from PowerBuilder using the Pinterest JDBC Driver.
-
Build Act CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Act CRM data.
-
Establish a Live Connection with Oracle Eloqua Data using Tableau Bridge
The CData ODBC Driver for Oracle Eloqua enables you to integrate live Oracle Eloqua data into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Live RSS 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 RSS feeds through a conversational interface.
-
Analyze Live MailChimp Data in SAS Viya
Use CData Connect AI to connect to MailChimp data from SAS Viya and deploy self-service analytics using live MailChimp data.
-
Access Live Raisers Edge NXT Data in AWS Lambda
Connect to live Raisers Edge NXT data in AWS Lambda using the CData JDBC Driver.
-
Seamlessly Bring Google Directory Data into Retool Using CData Connect AI
Integrate Google Directory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Landbot Data from PowerShell
Write a quick PowerShell script to query Landbot data. Use connectivity to the live data to replicate Landbot data to SQL Server.
-
How to integrate Metabase with MarkLogic Data
Use CData Connect AI to connect to live MarkLogic data and create an interactive dashboard in Metabase from MarkLogic data.
-
Automate Google Spanner Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Spanner data replication to Azure Data Lake.
-
Build a Simple VCL Application for ServiceNow Data
How to build a simple VCL Application to view ServiceNow data in RAD Studio using the CData ODBC Driver for ServiceNow.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Authorize.Net
Provide connectivity to Authorize.Net data through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Couchbase Data in ThoughtSpot
Use CData Connect AI to connect to live Couchbase data for modeling, searching, and visualizing.