CData Software - Knowledge Base
Recent Articles
-
Integrate Bitbucket Data into Power Automate Desktop using CData Connect
CData Connect for Bitbucket Data enables you to integrate Bitbucket data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Short.io Accounts
Replicate multiple Short.io accounts to one or many databases.
-
Easily Integrate Salesforce CRM Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce CRM Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a Singer.io Tap for BambooHR With the CData Python Connector
Learn how to easily build a Singer.io Tap for live BambooHR data using the CData Python Connector.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy
Connect to Pinterest data in MicroStrategy Developer using the CData Software JDBC Driver for Pinterest.
-
Integrating Bright Data Data in Talend Cloud Data Management Platform
Connect Bright Data Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Adobe Target Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Target data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect the Power BI Service to Act-On: Complete Guide
Connect to the CData Software Power BI Connector for Act-On from PowerBI.com to provide real-time Act-On data across the organization.
-
Access Live LDAP Objects in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live LDAP objects from your Excel spreadsheets.
-
Integrate Theia IDE with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Grafana data from within the development environment.
-
Automated Sybase IQ Data Replication to Teradata
Use CData Sync to Customize and automate Sybase IQ data replication to Teradata.
-
Connect to IBM Cloud Object Storage Data in Jaspersoft Studio
Execute SQL to remote IBM Cloud Object Storage data in Jaspersoft Studio.
-
Integrating Claude Code with Zoho Creator Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho Creator data within assisted coding and automated development workflows.
-
Access Live Vertica 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 Vertica data through MCP integration.
-
Connect to Moosend Data in RazorSQL
Connect to Moosend from wizards and query Moosend data from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with MongoDB 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 MongoDB data into a Java-based ORM framework, Hibernate.
-
Integrate with Gorgias Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gorgias data to a JSON file on disk.
-
Integrate PostgreSQL Data in the Pentaho Report Designer
Publish reports based on PostgreSQL data in the Pentaho BI tool.
-
Build a PostgreSQL Interface for Kafka Data using the CData JDBC Driver
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Microsoft Entra ID Data in DataGrip
Create a Data Source for Microsoft Entra ID in DataGrip and use SQL to query live Microsoft Entra ID data.
-
Integrate Live Oracle Sales Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Sales data and integrate live Oracle Sales data into apps built in Microsoft Power Apps.
-
Integrating Codex with TigerGraph 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.
-
Connect to eBay Analytics Data from a Connection Pool in Jetty
The eBay Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to eBay Analytics data from Web apps in Jetty.
-
Connect to SageHR Data in CloverDX (formerly CloverETL)
Transfer SageHR data using the visual workflow in the CloverDX data integration tool.
-
Add Attio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Attio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Apps with Live Chargebee Data Using the Low-Code Development Platform of Mendix
Connect Chargebee data with Mendix to build apps using the CData API Driver for JDBC.
-
Enable the Zoho CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho CRM data.
-
Use the CData Software ODBC Driver for Hacker News in MicroStrategy Desktop
Connect to Hacker News data in MicroStrategy Desktop using the CData Software ODBC Driver for Hacker News.
-
Back Up Perplexity data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Perplexity data data.
-
Connect to Twitter Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Twitter Ads data in Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Office 365
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Office 365.
-
How to connect PolyBase to SuiteCRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SuiteCRM data.
-
A Comparison of Database Drivers for MySQL
A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)
-
Getting Started with the CData Connect AI Python SDK for ZohoPeople
Install the CData Connect AI Python SDK to read live ZohoPeople data with standard DB-API 2.0 Python code.
-
Manage Microsoft Planner Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Planner.
-
Integrate LibreChat with Live RSS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live RSS feeds from within the chat interface.
-
Automated Continuous Zoho CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Apache Kafka.
-
Integrate Live SAP Netweaver Gateway Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Netweaver Gateway data and integrate live SAP Netweaver Gateway data into apps built in Microsoft Power Apps.
-
Connect to SAP Ariba Procurement Data in DBeaver
Use the CData ODBC Driver to connect to SAP Ariba Procurement data in DBeaver.
-
Validate Power BI XMLA Data with QuerySurge
Access and validate Power BI XMLA data in QuerySurge using the CData JDBC Driver.
-
Connect to OData Services in Aqua Data Studio
Access OData services from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Impala Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Impala data from your Excel spreadsheets.
-
Working with PolarTeamPro Data in LINQPad
Execute LINQ queries to PolarTeamPro data in LINQPad.
-
Deploy the ADO.NET Provider for Tavily on an SSRS Report Server
Connect to Tavily 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.
-
Visualize Live AfterShip Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live AfterShip data into custom reports in Power BI.
-
Visualize Live Freshservice Data in the Power BI Service
Use CData Connect AI to connect to live Freshservice data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LlamaIndex with ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ZohoExpense data in real time.
-
Create a Data Access Object for PDFMonkey Data using JDBI
A brief overview of creating a SQL Object API for PDFMonkey data in JDBI.
-
Seamlessly Bring Zoom Data into Retool Using CData Connect AI
Integrate Zoom data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Zoho Creator Data in Excel 365 Online (Excel for the web)
Connect to Zoho Creator data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for MongoDB in MicroStrategy Desktop
Connect to MongoDB data in MicroStrategy Desktop using the CData Software ODBC Driver for MongoDB.
-
How to create Foursquare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Foursquare data in MySQL .
-
How to Connect to Mailgun Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mailgun data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Mixpanel Data in TIBCO Spotfire through ADO.NET
Integrate Mixpanel data into dashboards in TIBCO Spotfire.
-
Integrate with Sage Intacct Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Intacct data in SnapLogic.
-
Automated Continuous Postmark Replication to SingleStore
Use CData Sync for automated, continuous, customizable Postmark replication to SingleStore.
-
Working with SparkPost Data in LINQPad
Execute LINQ queries to SparkPost data in LINQPad.
-
QuickBooks Online Reporting in OBIEE with the QuickBooks Online JDBC Driver
Deploy the QuickBooks Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Acumatica Data in UiPath Studio
Use the Acumatica ODBC Driver to create workflows that access real-time Acumatica data without any coding.
-
Prepare, Blend, and Analyze Amplitude Data in Alteryx Designer (ODBC)
Build workflows to access live Amplitude data for self-service data analytics.
-
Visualize Live ConvertKit Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertKit data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting Agentforce with Trello Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Trello data for you.
-
How to use SQLAlchemy ORM to access Hubstaff Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hubstaff data.
-
Access Live Gmail Data in Excel 365 Online (Excel for the web)
Connect to Gmail data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Configure the CData JDBC Driver for CouchDB in a Connection Pool in Tomcat
Connect to CouchDB data from a connection pool in Tomcat.
-
Establish a Live Connection with Dynamics 365 Data using Tableau Bridge
The CData ODBC Driver for Dynamics 365 enables you to integrate live Dynamics 365 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Stack Exchange Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Stack Exchange data replication to OneLake in Microsoft Fabric.
-
Visualize Live Neo4J Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Neo4J data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to CampaignMonitor Data in DBVisualizer
Integrate CampaignMonitor data with visual data analysis tools and data connection wizards in DBVisualizer
-
Import Real-Time Mailgun Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mailgun data in ColdFusion.
-
How to create an RPA flow for JobNimbus Data in UiPath Studio
Use the JobNimbus ODBC Driver to create workflows that access real-time JobNimbus data without any coding.
-
DataBind Controls to Calendly Data in Delphi
DataBind to Calendly data in Delphi with standard data access components and controls.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LDAP
Provide connectivity to LDAP objects through an SAP BusinessObjects universe.
-
Use Claude to Talk to Your Mailgun 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 Mailgun data for you.
-
Choosing the Best Method to Connect LinkedIn to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LinkedIn data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Configure the CData JDBC Driver for Dynamics 365 Business Central in a Connection Pool in Tomcat
Connect to Dynamics 365 Business Central data from a connection pool in Tomcat.
-
How to Work with ZohoInvoice Data in AWS Glue Jobs Using JDBC
Connect to ZohoInvoice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy
Connect to SQL Server data in MicroStrategy Developer using the CData Software ODBC Driver for SQL Server.
-
Visualize Microsoft Planner Data in Tableau
The CData ODBC driver for Microsoft Planner enables you integrate Microsoft Planner data into Tableau dashboards.
-
Establish a Live Connection with Eventbrite Data using Tableau Bridge
The CData ODBC Driver for Eventbrite enables you to integrate live Eventbrite data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Automated Dynamics NAV-Connected Workflows in Zapier
Use CData Connect AI to connect to live Dynamics NAV data and build automated workflows in Zapier.
-
Replicate Multiple Apollo Accounts via the CData Sync CLI
Replicate multiple Apollo accounts to one or many databases.
-
Connect to Acumatica Data in ACL Analytics
Connect to Acumatica data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Acumatica data.
-
Connect to Humanity Data in HULFT Integrate
Connect to Humanity as a JDBC data source in HULFT Integrate
-
Connect to SingleStore Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SingleStore and the SQL Gateway to access SingleStore data from Google Apps Script.
-
Connect to Marketo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Marketo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to update Hive from Excel
This article explains how to transfer data from Excel to Hive using the Excel Add-In for Hive.
-
Choosing the Best Method to Connect Perigon to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Perigon data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to create GetResponse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GetResponse data in MySQL .
-
How to connect PolyBase to Mistral AI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mistral AI data.
-
Automated Continuous Apify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Apify replication to Amazon Redshift.
-
Extract, Transform, and Load PabblySubscriptions Data in Informatica PowerCenter
Create a simple Workflow for PabblySubscriptions data in Informatica PowerCenter.
-
Integrating LangChain with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Avalara AvaTax data within automated workflows.
-
Connect to Instantly Data in NetBeans
Connect to Instantly data in NetBeans with the data source configuration wizard.
-
Natively Connect to ZohoDesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoDesk data. Leverage the native support for ODBC in PHP.
-
How to Work with Postmark Data in ETL Validator JDBC
Connect to Postmark from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Ontraport Replication to SingleStore
Use CData Sync for automated, continuous, customizable Ontraport replication to SingleStore.
-
Integrate Live Google Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Analytics data to Blue Prism using the CData ODBC Driver for Google Analytics to create automated workflows for repetitive business tasks.
-
Design BIRT Reports on FHIR Data
Provide current FHIR data to your embedded analytics.
-
LINQ to Salesforce Marketing 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 Salesforce Marketing Data Provider.