CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in SAP SuccessFactors Data with Power Map
Create data visualizations with SAP SuccessFactors data in Power Map.
-
How to Connect DBeaver to Miro via a JDBC Driver
Manage Miro data with visual tools in DBeaver like the query browser.
-
Using the CData Software ODBC Driver for Tanda in PyCharm
Connect to Tanda as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tanda.
-
Connect to FTP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to FTP.
-
Replicate PingOne Data from PowerShell
Write a quick PowerShell script to query PingOne data. Use connectivity to the live data to replicate PingOne data to SQL Server.
-
Using the CData Software ODBC Driver for Bright Data in PyCharm
Connect to Bright Data as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bright Data.
-
How to Connect to Live Twilio Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Twilio data securely in real time.
-
Use CData Connect AI to Access Salesforce CRM Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce CRM Analytics data in the Power Pivot business intelligence tool.
-
Build Charts with Bright Data Data in Clear Analytics
Create dynamic charts and perform analytics based on Bright Data data in Clear Analytics.
-
Create Sage 300 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage 300 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Stream Bannerbear Data into Apache Kafka Topics
Access and stream Bannerbear data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Devin with Live Jumpseller Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Jumpseller data.
-
Automate ZohoMarketingHub Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoMarketingHub data replication to SAP HANA.
-
Model, Search, and Visualize Live Adobe Experience Manager Data in ThoughtSpot
Use CData Connect AI to connect to live Adobe Experience Manager data for modeling, searching, and visualizing.
-
Bridge Slack Connectivity with Apache NiFi
Access and process Slack data in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for ConstantContact in a Connection Pool in Tomcat
Connect to ConstantContact data from a connection pool in Tomcat.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Time Data
Use CData Power BI Connectors to visualize QuickBooks Time data in Power BI.
-
Integrate LibreChat with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Klipfolio data from within the chat interface.
-
Viewing Dropbox Data in RAD Studio Data Explorer
How to view Dropbox data in RAD Studio Data Explorer using the CData ODBC Driver for Dropbox.
-
Integrating OpenCode with Superchat 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.
-
Replicate RabbitMQ Data from PowerShell
Write a quick PowerShell script to query RabbitMQ data. Use connectivity to the live data to replicate RabbitMQ data to SQL Server.
-
Connect to BigCommerce Data from PowerBuilder via ADO.NET
This article demonstrates how to access BigCommerce data from Appeon PowerBuilder using the CData ADO.NET Provider for BigCommerce.
-
Connect and Visualize Live Optimizely Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Optimizely data into the Databricks platform and create visualization dashboards with real-time Optimizely data.
-
Integrate Kafka Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Kafka data from Informatica Cloud.
-
Connect Coda to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coda with IBM WebSphere for seamless data integration and connectivity.
-
Back Up Excel Online data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Excel Online data data.
-
DataBind Controls to SAP Concur Data in C++Builder
DataBind to SAP Concur data in C++Builder with standard components and controls.
-
Rapidly Develop ADP-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 ADP.
-
Access Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data through MCP integration.
-
Automate Sage Intacct Data Replication to Azure Synapse
Use CData Sync to customize and automate Sage Intacct data replication to Azure Synapse.
-
Import SAP Business One Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Business One Data from Azure Data Factory and import live SAP Business One data.
-
Access Live LightSpeedRetail Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LightSpeedRetail data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import and Visualize Elorus Data in Power View
Create data visualizations based on Elorus data in Excel.
-
Build Twilio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Twilio data and build web apps with connectivity to live Twilio data.
-
Use Dash to Build to Web Apps on AgileCRM Data
Create Python applications that use pandas and Dash to build AgileCRM-connected web apps.
-
Automated PolarTeamPro Data Replication to Teradata
Use CData Sync to Customize and automate PolarTeamPro data replication to Teradata.
-
Getting Started with the CData ODBC Driver for Dropbox
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dropbox.
-
Integrate with Live SAP Netweaver Gateway Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Netweaver Gateway from the MuleSoft Anypoint Platform to integrate live SAP Netweaver Gateway data into custom reports and dashboards.
-
How to connect to Mode Data from Spring Boot
Connect to Mode in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect to Pushbullet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pushbullet data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Twitter Ads Data in Heroku for Use in Salesforce Connect
Replicate Twitter Ads data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Google Ads Data from MySQL in Amazon QuickSight
Connect to Google Ads and build visualizations of Google Ads data using a MySQL Connection in Amazon QuickSight.
-
Choosing the Best Method to Connect Zoho Recruit to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Recruit data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to and Query Zoho CRM Data in QlikView over ODBC
Create data visualizations with Zoho CRM data in QlikView.
-
Query SQL Analysis Services Data in ColdFusion
Write standard ColdFusion data access code to connect to SQL Analysis Services data.
-
Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy Web
Connect to SAP BusinessObjects BI data in MicroStrategy Web using the CData Software JDBC Driver for SAP BusinessObjects BI.
-
Create a Data Access Object for Wrike Data using JDBI
A brief overview of creating a SQL Object API for Wrike data in JDBI.
-
Visualize Browserless Data in Tableau
The CData ODBC driver for Browserless enables you integrate Browserless data into Tableau dashboards.
-
Connect Webex Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Webex data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Figshare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Figshare data. Leverage the pyodbc module for ODBC in Python.
-
Validate PingOne Data with QuerySurge
Access and validate PingOne data in QuerySurge using the CData JDBC Driver.
-
Visualize Snapchat Ads Data in TIBCO Spotfire through ADO.NET
Integrate Snapchat Ads data into dashboards in TIBCO Spotfire.
-
DataBind Pipeline CRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Pipeline CRM data to a chart.
-
View Reports on Real-Time Teamgate Data in Power BI Report Server
Use the CData ODBC Driver for Teamgate to visualize Teamgate data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build an OLAP Cube in SSAS from Scrapfly Data
Establish a connection to Scrapfly data data from SQL Server Analysis Services, and use the Scrapfly Data Provider to build OLAP cubes for use in analytics and reporting.
-
A PostgreSQL Interface for Browserless Data (MySQL Remoting via JDBC)
Use the Remoting features of the Browserless JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SuiteCRM Data Replication to SAP HANA
Use CData Sync to customize and automate SuiteCRM data replication to SAP HANA.
-
Integrating LlamaIndex with SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SingleStore data in real time.
-
Query Live Microsoft Planner 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 Microsoft Planner data through a conversational interface.
-
Provide OData Services of Cohere Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cohere data by developing a WCF Service Application.
-
A PostgreSQL Interface for ShipStation Data using the CData ODBC Driver
Use the SQL Gateway and ShipStation ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Spotify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Spotify data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Perigon Replication to Databricks
Use CData Sync for automated, continuous, customizable Perigon replication to Databricks.
-
Integrating Dataiku with SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SQL Analysis Services data.
-
DataBind Charts to Vault CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Vault CRM data 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.
-
Integrate Live Hive 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 Hive data from within the IDE.
-
Stream Adobe Commerce Data into Apache Kafka Topics
Access and stream Adobe Commerce data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live ShipStation 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 ShipStation data through MCP integration.
-
Integrating Reply.io Data in Talend Cloud Data Management Platform
Connect Reply.io Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData ODBC Driver for Tally in Microsoft Power Query
You can use the CData Tally ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tally data into Microsoft Power Query.
-
Work with Live Stripe Data in Power Query
Use CData Connect AI to connect to Stripe data and work with live Stripe data in Microsoft Power Query.
-
Getting Started with the CData ADO.NET Provider for Zoho Books
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Books.
-
Integrating Codex with Paylocity 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.
-
A PostgreSQL Interface for Front Data (MySQL Remoting via JDBC)
Use the Remoting features of the Front JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Okta Data using the CData ODBC Driver
Use the SQL Gateway and Okta ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect YouTube Analytics Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your YouTube Analytics data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live SuiteCRM Data in Excel 365 Online (Excel for the web)
Connect to SuiteCRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Freshsales with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshsales with External Services.
-
Replicate Freshteam Data to Multiple Databases
Replicate Freshteam data to disparate databases with a point-and-click configuration.
-
Create Zoho Creator-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Creator Data from Klipfolio and build custom visualizations using live Zoho Creator data.
-
Automated Continuous Gong Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Gong replication to Google BigQuery.
-
DataBind PingOne Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PingOne with the DevExpress Windows Forms and Web controls to provide PingOne data to a chart.
-
Automated Continuous Elorus Replication to SQL Server
Use CData Sync for automated, continuous, customizable Elorus replication to SQL Server.
-
Build Google Contacts-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Contacts data and build web apps with connectivity to live Google Contacts data.
-
How to Connect to Live LDAP Objects 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 LDAP objects without replication.
-
Connect to ConvertKit from a Connection Pool in WebLogic
Use the CData JDBC Driver for ConvertKit to connect to ConvertKit data from Web applications running on WebLogic.
-
Getting Started with the CData SSIS Components for CockroachDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CockroachDB.
-
Work with PabblySubscriptions Data in FoxPro
Load PabblySubscriptions data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Operational Reporting on Google Translate Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Translate data.
-
How to use SQLAlchemy ORM to access Drip Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Drip data.
-
Google Forms Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Forms data through CData Connect AI using different applications and tools.
-
Query Jodoo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jodoo data from Node.js.
-
Analyze Testmonitor Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Testmonitor data with the CData JDBC Driver for Testmonitor.
-
LINQ to Campaigner 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 Campaigner Data Provider.
-
Connect to LinkedIn Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LinkedIn and the SQL Gateway to access LinkedIn data from Google Apps Script.
-
Connect to WordPress Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to WordPress.
-
How to Connect to Power BI XMLA Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Power BI XMLA data. Leverage the pyodbc module for ODBC in Python.
-
Use CData Connect AI to Access BenchmarkEmail Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BenchmarkEmail data in the Power Pivot business intelligence tool.
-
Migrating data from Oracle Sales to Databricks using CData SSIS Components.
Easily push Oracle Sales data to Databricks using the CData SSIS Tasks for Oracle Sales and Databricks.
-
How to Access YouTube Analytics Data Using Entity Framework
This article shows how to access YouTube Analytics data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.