CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Outreach.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Outreach.io to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Amplitude Data in Talend Cloud Data Management Platform
Connect Amplitude Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect Google Ads Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Ads data in real time using natural language.
-
Analyze Sage Intacct Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sage Intacct and visualize live Sage Intacct in Infragistics Reveal.
-
How to create an RPA flow for Epicor Kinetic Data in UiPath Studio
Use the Epicor Kinetic ODBC Driver to create workflows that access real-time Epicor Kinetic without any coding.
-
Use the CData Software ODBC Driver for Moosend in MicroStrategy
Connect to Moosend in MicroStrategy Developer using the CData Software ODBC Driver for Moosend.
-
Integrate Tavily with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Tavily with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Tavily.
-
How to connect to Todoist Data with Squirrel SQL client
Connect to Todoist and execute queries in the Squirrel SQL Client.
-
Automated Continuous Jira Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira replication to IBM DB2.
-
Connect to Amplitude Data in Jaspersoft Studio
Execute SQL to remote Amplitude in Jaspersoft Studio.
-
Integrating Antigravity CLI with Certinia via CData CLI
Connect Certinia to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Feed SQL Server Data into FineReport
How to set Microsoft SQL Server as a JDBC data source in FineReport.
-
Connect to SAP Concur Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Concur as an External Source in Dremio.
-
Access Mocean Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mocean from your Oracle system.
-
Build Data Flows from Close to SQL Server using SSIS
Easily back up Close to SQL Server using the SSIS components for Close.
-
Visualize Live iContact Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live iContact.
-
Automate Freshdesk Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Freshdesk and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting Moonlit Workflow with Microsoft Dataverse 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 Microsoft Dataverse (CDS) in real time.
-
How to Access Live Gmail Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gmail enables you to integrate Gmail into workflows built using Microsoft Power Automate Desktop.
-
Use the CData API Server to Access ShipStation Data in Microsoft PowerPivot
Use the CData API Server to connect to live ShipStation in the Power Pivot business intelligence tool.
-
How to Connect to Live Basecamp Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Basecamp securely in real time.
-
Connect to Epicor Kinetic Data in RazorSQL
Connect to Epicor Kinetic from wizards and query Epicor Kinetic from the GUI in the RazorSQL database management tool.
-
Connect to Invoiced Data in RapidMiner
Integrate Invoiced with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Hugging Face Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Hugging Face using standard SQL.
-
Replicate Multiple IBM Informix Accounts via the CData Sync CLI
Replicate multiple IBM Informix accounts to one or many databases.
-
How to connect SharePoint with Raisers Edge NXT Data through external lists
Provide Raisers Edge NXT to SharePoint users as an external list.
-
Object-Relational Mapping (ORM) with PabblySubscriptions 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 PabblySubscriptions into a Java-based ORM framework, Hibernate.
-
How to work with Azure Data Lake Storage Data in Apache Spark using SQL
Access and process Azure Data Lake Storage Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Wrike Data to Multiple Databases
Replicate Wrike to disparate databases with a point-and-click configuration.
-
Connect to LaunchDarkly Data in Jaspersoft Studio
Execute SQL to remote LaunchDarkly in Jaspersoft Studio.
-
Connect to Apify Data from PowerBuilder via JDBC
This article demonstrates how to access Apify from PowerBuilder using the Apify JDBC Driver.
-
Add Epicor Kinetic Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Epicor Kinetic with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Cloudant Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cloudant replication to SQL Server.
-
How to Access GetResponse Data Using Entity Framework
This article shows how to access GetResponse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Sybase IQ Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Azure SQL Database.
-
How to create an RPA flow for Google Contacts Data in UiPath Studio
Use the Google Contacts ODBC Driver to create workflows that access real-time Google Contacts without any coding.
-
Access Live SAP SuccessFactors Data in Excel 365 Online (Excel for the web)
Connect to SAP SuccessFactors from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to work with eBay Analytics Data in Apache Spark using SQL
Access and process eBay Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
Model, Search, and Visualize Live Avalara AvaTax Data in ThoughtSpot
Use CData Connect AI to connect to live Avalara AvaTax for modeling, searching, and visualizing.
-
Connect to Active Directory Data in JRuby
Create a simple JRuby app with access to live Active Directory.
-
How to update Google Spanner from Excel
This article explains how to transfer data from Excel to Google Spanner using the Excel Add-In for Google Spanner.
-
Build AI/ML Models with Live JobNimbus Data using Dataiku
Connect JobNimbus Data with Dataiku using the CData API Driver for JDBC.
-
Build a PostgreSQL Interface for Phoenix Data using the CData JDBC Driver
Use the Remoting features of the Phoenix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Google Cloud Storage Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Cloud Storage. Leverage the native support for ODBC in PHP.
-
Analyze SuiteCRM Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SuiteCRM and visualize live SuiteCRM in Infragistics Reveal.
-
How to work with TaxJar Data in Apache Spark using SQL
Access and process TaxJar Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for Facebook Ads Data using the CData ODBC Driver
Use the SQL Gateway and Facebook Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor CLI with QuickBooks Time 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 ODBC Driver for Procore in Microsoft Power Query
You can use the CData Procore ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Procore into Microsoft Power Query.
-
Access Live CockroachDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to CockroachDB from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Dataiku with Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Atlassian Jira.
-
How to connect to Sage 300 Data from Spring Boot
Connect to Sage 300 in a Spring Boot Application using the CData JDBC Driver for Sage 300
-
Connect to and Query SAP Hybris C4C Data in QlikView over ODBC
Create data visualizations with SAP Hybris C4C in QlikView.
-
Integrate LibreChat with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Facebook from within the chat interface.
-
How to Seamlessly Import Strava Data into IBM SPSS Modeler
Integrate Strava data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
ETL SQL Analysis Services in Oracle Data Integrator
This article shows how to transfer SQL Analysis Services into a data warehouse using Oracle Data Integrator.
-
How to Work with Pipeliner CRM Data in ETL Validator JDBC
Connect to Pipeliner CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Data Flows from Workday to SQL Server using SSIS
Easily back up Workday to SQL Server using the SSIS components for Workday.
-
Connect to Quickbase Data in NetBeans
Connect to Quickbase in NetBeans with the data source configuration wizard.
-
Create Sugar CRM-Connected Business Apps in AppSheet
Connect to Sugar CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sugar CRM.
-
Analyze Google Directory Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Directory and visualize Google Directory in SAP Analytics Cloud.
-
Build Dashboards with Active Directory Data in Dundas BI
Create dynamic dashboards and perform analytics based on Active Directory in Dundas BI.
-
How to Connect to Live Google Search Results 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 Google Search without replication.
-
Getting Started with the CData Connect AI Python SDK for Freshdesk
Install the CData Connect AI Python SDK to read and write live Freshdesk with standard DB-API 2.0 Python code.
-
How to Connect to & Open SAS Data Sets Data in Microsoft Excel
This article uses the CData ODBC driver for SAS Data Sets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Manage Sugar CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sugar CRM.
-
Integrate DB2 Data into Power Automate Desktop using CData Connect
CData Connect for DB2 Data enables you to integrate IBM DB2 into workflows built using Microsoft Power Automate Desktop.
-
Publish Freshdesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshdesk.
-
How to Connect the Power BI Service to SharePoint: Complete Guide
Connect to the CData Software Power BI Connector for SharePoint from PowerBI.com to provide real-time Microsoft SharePoint across the organization.
-
Build Automated Microsoft Exchange-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Exchange and build automated workflows in Zapier.
-
Use the CData Software JDBC Driver for WooCommerce in MicroStrategy
Connect to WooCommerce in MicroStrategy Developer using the CData Software JDBC Driver for WooCommerce.
-
Access Live SageHR Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SageHR in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate Metabase with Klaviyo Data
Use CData Connect AI to connect to live Klaviyo and create an interactive dashboard in Metabase from Klaviyo.
-
Connect to Adobe Commerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Adobe Commerce, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Avalara AvaTax Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to MongoDB.
-
Use Dash to Build to Web Apps on Authorize.Net Data
Create Python applications that use pandas and Dash to build Authorize.Net-connected web apps.
-
How to connect and process Box from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Box.
-
Connect Google Sheets to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Sheets with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect Flowise AI Agents to Live FTP Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live FTP Servers without replication.
-
Connect to Zoho Creator Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Creator.
-
Create Dynamic Oracle Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Amazon Marketplace Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon Marketplace and integrate live Amazon Marketplace into apps built in Microsoft Power Apps.
-
Getting Started with the CData Power BI Connector for Everhour
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Blackbaud FE NXT Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Blackbaud FE NXT. Leverage the pyodbc module for ODBC in Python.
-
Connect to Smartsheet Data from a Connection Pool in Jetty
The Smartsheet JDBC Driver supports connection pooling: This article shows how to connect faster to Smartsheet from Web apps in Jetty.
-
Automated Continuous ZarMoney Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZarMoney replication to SQL Server.
-
Connect to SAP Concur Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Concur.
-
Enable the SAS Data Sets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAS Data Sets.
-
Automated Continuous Bannerbear Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Bannerbear replication to IBM DB2.
-
Replicate PhantomBuster Data from PowerShell
Write a quick PowerShell script to query PhantomBuster. Use connectivity to the live data to replicate PhantomBuster to SQL Server.
-
Create Bullhorn CRM-Connected Business Apps in AppSheet
Connect to Bullhorn CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Bullhorn CRM.
-
A PostgreSQL Interface for Bitly Data using the CData ODBC Driver
Use the SQL Gateway and Bitly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Wave Financial Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Wave Financial replication to Apache Kafka.
-
Connect Perigon to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Perigon using the CData Python MCP Server.
-
Visualize Facebook Ads Data in TIBCO Spotfire through ADO.NET
Integrate Facebook Ads into dashboards in TIBCO Spotfire.
-
Create Salesforce-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce Data from Nintex Workflow Cloud and build custom workflows using live Salesforce & Force.com.
-
View Reports on Real-Time SAP Ariba Source Data in Power BI Report Server
Use the CData ODBC Driver for SAP Ariba Source to visualize SAP Ariba Source in Power BI Desktop and then publish them to Power BI Report Server.
-
Use JayDeBeApi to access Azure Analysis Services Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Analysis Services.
-
How to create an RPA flow for Klaviyo Data in UiPath Studio
Use the Klaviyo ODBC Driver to create workflows that access real-time Klaviyo without any coding.
-
Publish Dynamics 365 Business Central-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dynamics 365 Business Central.