CData Software - Knowledge Base

Recent Articles

---

• «
• 1006
• 1007
• 1008
• 1009
• 1010
• 1011
• 1012
• 1013
• 1014
• 1015
• »

• How to Query Live Epicor Kinetic Data in Claude Desktop

  Connect to and query live Epicor Kinetic Data in Claude Desktop using CData MCP Server.

• Integrating Boomi Agentstudio with YouTube Analytics Data via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to YouTube Analytics, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• How to Connect to Live FTP 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 FTP Servers without replication.

• Build Data Flows from Azure Data Catalog to SQL Server using SSIS

  Easily back up Azure Data Catalog to SQL Server using the SSIS components for Azure Data Catalog.

• Use the CData Software JDBC Driver for Dynamics 365 Business Central in MicroStrategy

  Connect to Dynamics 365 Business Central in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics 365 Business Central.

• Build Google Drive-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Drive.

• Edit and Search External Paylocity Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Paylocity to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Paylocity Data objects that you can access from apps and the dashboard.

• Enable the LightSpeedRetail JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with LightSpeedRetail.

• Integrating Mailjet Data in Talend Cloud Data Management Platform

  Connect Mailjet Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• How to Create Power BI Visual Reports with Real-Time SAP Business One Data

  Use CData Power BI Connectors to visualize SAP Business One in Power BI.

• Use the CData SSIS Components to Insert New or Update Existing SAP HANA Records from SQL Server

  Easily push SQL Server data to SAP HANA using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP HANA or update existing records with data from a SQL Server database.

• Getting Started with the CData SSIS Components for Paylocity

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Paylocity.

• Replicate Epicor Kinetic Data to Multiple Databases via the CData Sync CLI

  Replicate Epicor Kinetic to disparate databases with a single configuration.

• Getting Started with the CData JDBC Driver for SageHR

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SageHR.

• How to create ServiceDesk Plus federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for ServiceDesk Plus in MySQL .

• Connect Harvest to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Harvest using the CData Python MCP Server.

• Model GraphQL Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and GraphQL, enabling the direct import of real-time GraphQL.

• Connect to Airtable Data from a Connection Pool in JBoss

  Integrate Airtable into Java servlets: Use the Management Console in JBoss to install the Airtable JDBC Driver.

• How to Visualize GraphQL Data in Python with pandas

  Use pandas and other modules to analyze and visualize live GraphQL in Python.

• Getting Started with the CData ADO.NET Provider for Paymo

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Build AI Agents with Sugar CRM 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 Sugar CRM through CData Connect AI.

• How to import BenchmarkEmail Data into Apache Solr

  Use the CData Software JDBC Driver for BenchmarkEmail in Data Import Handler and create an automated import of BenchmarkEmail to Apache Solr Enterprise Search platform.

• A PostgreSQL Interface for Amazon DynamoDB Data (MySQL Remoting via JDBC)

  Use the Remoting features of the Amazon DynamoDB JDBC Driver to create a PostgreSQL entry-point for data access.

• How to connect to Google Directory Data from IntelliJ

  Integrate connectivity to Google Directory with wizards in IntelliJ.

• Automated Continuous Salesforce Pardot Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MongoDB.

• Use the CData ODBC Driver for Rootly from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Rootly to connect to Rootly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Rootly in Excel.

• Integrating Cursor CLI with Act-On 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 Perigon Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Perigon and work with Perigon in your FileMaker applications.

• Automated Continuous Cosmos DB Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to Apache Kafka.

• How to connect SharePoint with PostgreSQL Data through external lists

  Provide PostgreSQL to SharePoint users as an external list.

• Natively Connect to Freshdesk Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Freshdesk. Leverage the native support for ODBC in PHP.

• How to Connect the Power BI Service to Klaviyo: Complete Guide

  Connect to the CData Software Power BI Connector for Klaviyo from PowerBI.com to provide real-time Klaviyo across the organization.

• How to connect to Moosend Data with Squirrel SQL client

  Connect to Moosend and execute queries in the Squirrel SQL Client.

• How to create Visio diagrams from Splunk Data

  Automatically update Splunk with the changes you make to Visio master shapes.

• Automated Continuous Smartsheet Replication to SQLite

  Use CData Sync for automated, continuous, customizable Smartsheet replication to SQLite.

• Getting Started with the CData Connect AI Python SDK for Microsoft Exchange

  Install the CData Connect AI Python SDK to read and write live Microsoft Exchange with standard DB-API 2.0 Python code.

• Publish Reports with Samanage Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Samanage.

• Use the CData Software ODBC Driver for Redis in MicroStrategy Web

  Connect to Redis in MicroStrategy Web using the CData Software ODBC Driver for Redis.

• Create Data Visualizations Based On Azure DevOps Data in Mode

  Use CData Connect AI to connect to Azure DevOps Data from Mode and build visualizations using live

• Build Dashboards with GitLab Data in Dundas BI

  Create dynamic dashboards and perform analytics based on GitLab in Dundas BI.

• Automated Continuous Slack Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Slack replication to Amazon Redshift.

• How to create an RPA flow for ConstantContact Data in UiPath Studio

  Use the ConstantContact ODBC Driver to create workflows that access real-time ConstantContact without any coding.

• Create Informatica Mappings From/To a JDBC Data Source for VWO

  Create VWO data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Access NASA Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NASA from your Oracle system.

• Connect to Testmonitor Data in CloverDX (formerly CloverETL)

  Transfer Testmonitor using the visual workflow in the CloverDX data integration tool.

• Build SAP-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for SAP to explore live SAP Data in GitHub Copilot to assist with building SAP-powered applications.

• Query Todoist Data in DataGrip

  Create a Data Source for Todoist in DataGrip and use SQL to query live Todoist.

• How to Query Quickbase Data in MySQL Workbench

  Execute MySQL queries against live Quickbase from MySQL Workbench.

• How to connect and process WordPress from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live WordPress.

• Analyze Intercom Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Intercom in Microsoft R Open.

• Use Microsoft Copilot Studio to talk to your Certinia Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Certinia for you.

• Build LionDesk-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to LionDesk and build web apps with connectivity to live LionDesk.

• Create Informatica Mappings From/To a JDBC Data Source for Procore

  Create Procore data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Build Xero-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Xero Data and create custom apps in Bubble.

• How to Query SAP HANA XS Advanced Data in MySQL Workbench

  Execute MySQL queries against live SAP HANA XS Advanced from MySQL Workbench.

• Connect to Certinia Data in RapidMiner

  Integrate Certinia with standard components and data source configuration wizards in RapidMiner Studio.

• Query, Visualize, and Share live SurveyMonkey Data in Redash

  Use CData Connect AI to connect to live SurveyMonkey in Redash for querying, visualizing, and sharing.

• How to Visualize Webflow Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Webflow in Python.

• Create Data Visualizations Based On Splunk Data in Mode

  Use CData Connect AI to connect to Splunk Data from Mode and build visualizations using live

• Use Microsoft Copilot Studio to talk to your FTP Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your FTP Servers for you.

• Connect to LaunchDarkly from Asprova with CData Software ODBC Driver for LaunchDarkly

  This article shows how to connect faster to LaunchDarkly data from Asprova.

• View Reports on Real-Time JobNimbus Data in Power BI Report Server

  Use the CData ODBC Driver for JobNimbus to visualize JobNimbus in Power BI Desktop and then publish them to Power BI Report Server.

• Integrate Live Amazon S3 Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Amazon S3 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon S3.

• Visualize Suadeo Data in TIBCO Spotfire through ADO.NET

  Integrate Suadeo into dashboards in TIBCO Spotfire.

• Connect to Vertica Data in ACL Analytics

  Connect to Vertica via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Vertica.

• Connect to LightSpeedRetail from a Connection Pool in WebLogic

  Use the CData JDBC Driver for LightSpeedRetail to connect to LightSpeedRetail from Web applications running on WebLogic.

• Access SAP Ariba Procurement 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 SAP Ariba Procurement.

• Connect to ShipStation from Asprova with CData Software ODBC Driver for ShipStation

  This article shows how to connect faster to ShipStation data from Asprova.

• Integrating Antigravity CLI with Salesforce Pardot via CData CLI

  Connect Salesforce Pardot to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Excel Spreadsheet Automation on SQL Server Data with the QUERY Formula

  Pull data from SQL Server, automate spreadsheets, and more with the QUERY formula.

• Integrate Real-Time Access to CockroachDB in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CockroachDB in real time.

• Visualize SparkPost Data in Sisense

  Create an ElastiCube in Sisense app with access to SparkPost.

• How to Seamlessly Import Miro Data into IBM SPSS Modeler

  Integrate Miro data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy Web

  Connect to Bullhorn CRM in MicroStrategy Web using the CData Software ODBC Driver for Bullhorn CRM.

• Connect to Real-Time SAP SuccessFactors Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SAP SuccessFactors and Dataflow to import and use SAP SuccessFactors in Power Apps.

• Connect to MongoDB Data from a Connection Pool in JBoss

  Integrate MongoDB into Java servlets: Use the Management Console in JBoss to install the MongoDB JDBC Driver.

• How to work with Teamwork Data in Apache Spark using SQL

  Access and process Teamwork Data in Apache Spark using the CData Software JDBC Driver.

• Integrate Drift with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Drift with External Services.

• Edit and Search WooCommerce External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of WooCommerce to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create WooCommerce objects that you can access from apps and the dashboard.

• Access Live Amazon DynamoDB Data in Excel 365 Online (Excel for the web)

  Connect to Amazon DynamoDB from Excel 365 Online (Excel for the web) with CData Connect AI.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Greenplum actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Connect to Microsoft Entra ID Data from a Connection Pool in Jetty

  The Microsoft Entra ID JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Entra ID from Web apps in Jetty.

• Use Agno to Talk to Your Elasticsearch 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 Elasticsearch for you.

• Explore Geographical Relationships in Impala Data with Power Map

  Create data visualizations with Apache Impala in Power Map.

• Integrate Oracle Data in Pentaho Data Integration

  Build ETL pipelines based on Oracle Database in the Pentaho Data Integration tool.

• How to use SQLAlchemy ORM to access LightSpeedRetail Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LightSpeedRetail.

• LINQ to Anaplan 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 Anaplan Data Provider.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshteam

  Provide connectivity to Freshteam through an SAP BusinessObjects universe.

• Analyze LionDesk Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for LionDesk from Power Pivot. You will use the Table Import Wizard to load LionDesk. You can visually build the import query or use any SQL supported by the driver.

• How to Connect to Live Gmail 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 Gmail without replication.

• Getting Started with the CData Excel Add-In for Wrike

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wrike.

• Visualize ZohoSubscriptions Data in TIBCO Spotfire through ADO.NET

  Integrate ZohoSubscriptions into dashboards in TIBCO Spotfire.

• Consume NetSuite OData Feeds in PowerBuilder

  This article demonstrates how to consume NetSuite CRM & ERP as OData feeds from PowerBuilder using the API Server.

• Migrating data from Twitter Ads to Snowflake using CData SSIS Components.

  Easily push Twitter Ads to Snowflake using the CData SSIS Tasks for Twitter Ads and Snowflake.

• Work with Everhour Data in FoxPro

  Load Everhour into a FoxPro database. This article includes full code and a walk-through of the process.

• Getting Started with the CData ODBC Driver for SAP BusinessObjects BI

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP BusinessObjects BI.

• Integrate SAP Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP ERP/NetWeaver from Informatica Cloud.

• Connect Pipeline CRM to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Pipeline CRM using the CData Python MCP Server.

• Create Power BI Reports on Real-Time eBay Analytics Data

  Use the CData ODBC Driver for eBay Analytics to visualize eBay Analytics in Power BI Desktop.

• How to connect SharePoint with FTP Data through external lists

  Provide FTP Servers to SharePoint users as an external list.

• «
• 1006
• 1007
• 1008
• 1009
• 1010
• 1011
• 1012
• 1013
• 1014
• 1015
• »