CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Slack Data in OpenOffice Base
Connect to Slack data in OpenOffice Base using the CData ODBC Driver for Slack and generate reports with live data insights.
-
Connect to Live IBM Informix Data in MicroStrategy through CData Connect AI
Create a live connection to IBM Informix Data in CData Connect AI and connect to your IBM Informix from MicroStrategy.
-
Integrating Claude Code CLI with Sage Intacct 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.
-
Prepare, Blend, and Analyze Couchbase Data in Alteryx Designer (ODBC)
Build workflows to access live Couchbase for self-service data analytics.
-
Connect to AfterShip Data in RapidMiner
Integrate AfterShip with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Live Facebook Data in SAS Viya
Use CData Connect AI to connect to Facebook from SAS Viya and deploy self-service analytics using live Facebook.
-
DataBind Odoo Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Odoo with the DevExpress Windows Forms and Web controls to provide Odoo ERP to a chart.
-
Integrate with Nethunt Data in JReport Designer
Create charts and reports based on Nethunt in JReport Designer.
-
How to connect SharePoint with Sage 200 Data through external lists
Provide Sage 200 to SharePoint users as an external list.
-
Visualize Live Act-On Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Act-On using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Charts with Jodoo Data in Clear Analytics
Create dynamic charts and perform analytics based on Jodoo in Clear Analytics.
-
Getting Started with the CData ADO.NET Provider for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Entra ID.
-
Model Google Directory Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Directory, enabling the direct import of real-time Google Directory.
-
Getting Started with the CData ADO.NET Provider for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Data Catalog.
-
Use the CData Software ODBC Driver for Workday in SAS for Real-Time Reporting and Analytics
Connect to real-time Workday in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Workday.
-
Connect to Basecamp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp and execute queries in PowerBuilder.
-
Bidirectional Access to Aircall Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Aircall in Filemaker Pro for Mac or Windows.
-
Integrating LangChain with Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Splunk within automated workflows.
-
Create a Data Access Object for Google Forms Data using JDBI
A brief overview of creating a SQL Object API for Google Forms in JDBI.
-
Connect to Snapchat Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Snapchat Ads from PowerBuilder using the Snapchat Ads JDBC Driver.
-
Analyze Perplexity Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Perplexity in Microsoft R Open.
-
Create ClickTime Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ClickTime data access from reports, embedded analytics, and more.
-
How to work with Figshare Data in Apache Spark using SQL
Access and process Figshare Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate ScrapingBee with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ScrapingBee with External Services.
-
Establish a Live Connection with Mistral AI Data using Tableau Bridge
The CData ODBC Driver for Mistral AI enables you to integrate live Mistral AI into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Apps with Live Dynamics 365 Business Central in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 Business Central into the Adalo platform and build custom mobile and web applications with real-time Dynamics 365 Business Central.
-
Create Informatica Mappings From/To a JDBC Data Source for IBM Informix
Create IBM Informix data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dynamics 365 Business Central-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Dynamics 365 Business Central to explore live Dynamics 365 Business Central Data in Gemini Code Assist to assist with building Dynamics 365 Business Central-powered applications.
-
Build AI/ML Models with Live Google Campaign Manager 360 Data using Dataiku
Connect Google Campaign Manager 360 Data with Dataiku using the CData JDBC Driver for Google Campaign Manager 360.
-
How to Connect to Live Slack Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Slack without replication.
-
How to Connect to Live eBay Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your eBay for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SFTP
Provide connectivity to SFTP through an SAP BusinessObjects universe.
-
Using the CData Software ODBC Driver for Exa in PyCharm
Connect to Exa as an ODBC data source in PyCharm using the CData Software ODBC Driver for Exa.
-
How to Import Data from XML into Google Sheets
Import XML Files into a Google spreadsheet that is automatically refreshed.
-
How to Import Data from SAP Business One into Google Sheets
Import SAP Business One into a Google spreadsheet that is automatically refreshed.
-
Analyze Sage Cloud Accounting Data in Cognos Analytics
Use CData Connect AI to connect to Sage Cloud Accounting Data from Cognos Analytics and analyze live Sage Business Cloud Accounting.
-
Automated Continuous Freshsales Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Freshsales replication to Azure SQL Database.
-
Build Data Flows from Acumatica to SQL Server using SSIS
Easily back up Acumatica ERP to SQL Server using the SSIS components for Acumatica.
-
Integrate Live SQL Analysis Services Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SQL Analysis Services from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SQL Analysis Services.
-
Validate Vimeo Data with QuerySurge
Access and validate Vimeo in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Front in MicroStrategy
Connect to Front in MicroStrategy Developer using the CData Software JDBC Driver for Front.
-
How to Connect to Live DB2 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your IBM DB2 for you.
-
Choosing the Best Method to Connect Zoom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoom from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Klipfolio Data in HULFT Integrate
Connect to Klipfolio as a JDBC data source in HULFT Integrate
-
Access Brex 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 Brex.
-
Automated Continuous HBase Replication to SQLite
Use CData Sync for automated, continuous, customizable HBase replication to SQLite.
-
How to integrate FreshBooks with Apache Airflow
Access and process FreshBooks in Apache Airflow using the CData JDBC Driver.
-
Connect to Adobe Commerce Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Commerce.
-
How to connect PolyBase to Access
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Access.
-
Automated Continuous Certinia Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Certinia replication to IBM DB2.
-
Getting Started with the CData Excel Add-In for SpaceX
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SpaceX.
-
Configure the CData JDBC Driver for Opsgenie in a Connection Pool in Tomcat
Connect to Opsgenie from a connection pool in Tomcat.
-
Connect to Real-Time ConvertAPI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConvertAPI in Power Apps.
-
Integrating LangChain with GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitLab within automated workflows.
-
Connect to Bitbucket Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Agno to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP SuccessFactors LMS for you.
-
Migrating data from Humanity to Google BigQuery using CData SSIS Components.
Easily push Humanity to Google BigQuery using the CData SSIS Tasks for Humanity and Google BigQuery.
-
Build a PostgreSQL Interface for Mailjet Data using the CData JDBC Driver
Use the Remoting features of the Mailjet JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to GitHub Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GitHub. Leverage the pyodbc module for ODBC in Python.
-
Back Up Zoho Projects to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Projects. In this article, we will employ an SSIS workflow to populate a database with Zoho Projects data.
-
How to Design Airtable Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Airtable from mobile and tablet Power Apps.
-
Automated Continuous eBay Replication to IBM DB2
Use CData Sync for automated, continuous, customizable eBay replication to IBM DB2.
-
Build Google Calendar-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Calendar Data and create custom apps in Bubble.
-
Back Up LightSpeedRetail 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 LightSpeedRetail data.
-
Integrating Claude Code CLI with GitLab 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Target
Create Adobe Target data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ADP Data in Ruby
Connect to ADP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Samanage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Samanage. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Google Sheets Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Sheets into custom reports in Power BI.
-
Access Live Supabase Data in Coginiti Pro
Connect to and query live Supabase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to and Visualize Live SAP Netweaver Gateway Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Netweaver Gateway.
-
Building Dynamic Web Pages with Tally Data Using AngularJS
Create single-page applications with live connectivity to Tally using the CData API Server.
-
Build Spark-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Spark SQL and build Spark-connected web apps with Axios.
-
Configure the CData JDBC Driver for Coda in a Connection Pool in Tomcat
Connect to Coda from a connection pool in Tomcat.
-
Access Live MariaDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MariaDB from your Excel spreadsheets.
-
Integrate Smartsheet Data into Power Automate Desktop using CData Connect
CData Connect for Smartsheet Data enables you to integrate Smartsheet into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access SurveyMonkey Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SurveyMonkey.
-
How to publish and share Procore Data dashboards with Tableau Server
The CData ODBC driver for Procore enables you integrate Procore into Tableau dashboards.
-
Connect to Reply.io from Asprova with CData Software ODBC Driver for Reply.io
This article shows how to connect faster to Reply.io data from Asprova.
-
How to Access Tanda Data Using Entity Framework
This article shows how to access Tanda using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI Agents with Jira Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Atlassian Jira through CData Connect AI.
-
Integrate Cursor with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce CRM Analytics from within the editor.
-
Build Apps with Live Exa Data Using the Low-Code Development Platform of Mendix
Connect Exa with Mendix to build apps using the CData API Driver for JDBC.
-
How to Seamlessly Import NetSuite Data into IBM SPSS Modeler
Integrate NetSuite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAP Business One Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Business One using standard SQL.
-
Access Live Jodoo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jodoo into the statistical analysis tools available in SAS JMP. This article shows how to use Jodoo in the Graph Builder and Query Builder.
-
Automate Tanda Data Replication to Azure Data Lake
Use CData Sync to customize and automate Tanda replication to Azure Data Lake.
-
Import QuickBooks Time Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to QuickBooks Time Data and provide access to live QuickBooks Time for custom reports in the Power BI Service.
-
Analyze Live Oracle Data in SAS Viya
Use CData Connect AI to connect to Oracle Database from SAS Viya and deploy self-service analytics using live Oracle Database.
-
DataBind Controls to Microsoft Exchange Data in Delphi
DataBind to Microsoft Exchange in Delphi with standard data access components and controls.
-
Integrating Cursor CLI with ZohoMarketingHub 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.
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy Web
Connect to Twilio in MicroStrategy Web using the CData Software ODBC Driver for Twilio.
-
A PostgreSQL Interface for Hubstaff Data using the CData ODBC Driver
Use the SQL Gateway and Hubstaff ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Tally Data from a Connection Pool in JBoss
Integrate Tally ERP into Java servlets: Use the Management Console in JBoss to install the Tally JDBC Driver.
-
Integrate with ZohoExpense Data in JReport Designer
Create charts and reports based on ZohoExpense in JReport Designer.
-
How to work with Landbot Data in Apache Spark using SQL
Access and process Landbot Data in Apache Spark using the CData Software JDBC Driver.
-
Query Act-On Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Act-On and perform CRUD operations on Act-On from Node.js.
-
Integrate PabblySubscriptions with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PabblySubscriptions with External Services.
-
Manage eBay Analytics Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for eBay Analytics.
-
How to connect to Azure DevOps Data in DBVisualizer
Integrate Azure DevOps with visual data analysis tools and data connection wizards in DBVisualizer