CData Software - Knowledge Base

Recent Articles

---

• «
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• »

• How to Connect to Live Act-On Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Act-On data through natural language.

• Integrating Codex with Paddle 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.

• Build SAP HANA XS Advanced Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live SAP HANA XS Advanced data and build visualizations in Tableau.

• Enable the Bannerbear JDBC Driver in KNIME

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

• DataBind Charts to Customer.io Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Customer.io 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.

• Excel Spreadsheet Automation on Splunk Data with the QUERY Formula

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

• Automated Continuous Pipeline CRM Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Pipeline CRM data replication to OneLake in Microsoft Fabric.

• Use CData Connect AI to Access Sybase IQ Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Sybase IQ data in the Power Pivot business intelligence tool.

• Connect to Phoenix Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Phoenix data in the Denodo Virtual DataPort Administrator.

• Build Tally-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Tally data and build Tally-connected web apps with Axios.

• Integrate Dify with Live ZohoSubscriptions Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ZohoSubscriptions data.

• How to Query SendGrid Data in MySQL Workbench

  Execute MySQL queries against live SendGrid data from MySQL Workbench.

• Access Live SurveyMonkey Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SurveyMonkey data from your Excel spreadsheets.

• Automated Continuous Pipedrive Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Pipedrive replication to Google Cloud SQL.

• Integrating Dataiku with Salesforce CRM Analytics Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce CRM Analytics data.

• Extract, Transform, and Load SendGrid Data in Informatica PowerCenter

  Create a simple Workflow for SendGrid data in Informatica PowerCenter.

• How to connect SharePoint with Highrise Data through external lists

  Provide Highrise data to SharePoint users as an external list.

• Connect to Grafana Data in DBArtisan

  Use wizards in DBArtisan to configure Grafana data as a data source.

• Query Adobe Commerce Data in ColdFusion

  Write standard ColdFusion data access code to connect to Adobe Commerce data.

• Seamlessly Bring Aweber Data into Retool Using CData Connect AI

  Integrate Aweber data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Back Up Reply.io 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 Reply.io data data.

• Query Google Ads Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Google Ads data from Node.js.

• Integrate with live ZohoPeople Data in Jitterbit

  Use CData Connect AI to connect to and integrate live ZohoPeople data in Jitterbit.

• Connect Dynamics CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Dynamics CRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Access Live Microsoft Exchange Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Exchange data from your Excel spreadsheets.

• Design BIRT Reports on Deel Data

  Provide current Deel data to your embedded analytics.

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

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

• Integrating Kiro with JotForm 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.

• Choosing the Best Method to Connect CapsuleCRM to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use CapsuleCRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

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

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

• Getting Started with the CData Tableau Connector for SAP Fieldglass

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Fieldglass.

• How to connect to MailChimp Data in DBVisualizer

  Integrate MailChimp data with visual data analysis tools and data connection wizards in DBVisualizer

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

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

• Getting Started with the CData SSIS Components for Instagram

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

• Connect Salesforce CRM Analytics to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Salesforce CRM Analytics with IBM WebSphere for seamless data integration and connectivity.

• Automated Continuous Beeminder Replication to Oracle

  Use CData Sync for automated, continuous, customizable Beeminder replication to Oracle.

• Use the CData ODBC Driver for LinkedIn Ads from SharePoint Excel Services

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

• Connect to Beeminder Data in Aqua Data Studio

  Access Beeminder data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Publish Redshift-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Redshift data.

• Automated Continuous Keap Replication to Databricks

  Use CData Sync for automated, continuous, customizable Keap replication to Databricks.

• How to connect to Factorial Data with Squirrel SQL client

  Connect to Factorial data and execute queries in the Squirrel SQL Client.

• Write a Simple Go Application to work with Keap Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Keap data.

• Build Semantic Layer Views for Copper Data in APOS Live Data Gateway

  Use the CData Connector for Copper in APOS Live Data Gateway to build Semantic Layer Views for Copper data.

• Design BIRT Reports on CockroachDB Data

  Provide current CockroachDB data to your embedded analytics.

• Query Impala Data in DataGrip

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

• Use the CData ODBC Driver for Oracle SCM from SharePoint Excel Services

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

• Use Claude to Talk to Your Slack 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 Slack data for you.

• Use the CData Software JDBC Driver for Aha! in MicroStrategy

  Connect to Aha! data in MicroStrategy Developer using the CData Software JDBC Driver for Aha!.

• Connect to AgileCRM in SpagoBI

  Create reports featuring live AgileCRM data in SpagoBI Studio. Host AgileCRM reports on SpagoBI Server.

• Access Live LinkedIn Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to LinkedIn data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Query JSON Services as a MySQL Database in Node.js

  Execute MySQL queries against JSON services from Node.js.

• Integrate Cursor with Live xBase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live xBase data from within the editor.

• Integrate OpenCode with Live SAS Data Sets Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAS Data Sets data from within your AI coding agent.

• Create GetResponse-Connected Business Apps in AppSheet

  Connect to GetResponse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to GetResponse data.

• Getting Started with the CData Python Connector for Act-On

  Learn to install and license the CData Python Connector and configure a connection to live Act-On data.

• Integrate Live Outreach.io Data into Amazon SageMaker Canvas with RDS

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

• Design BIRT Reports on Azure Table Data

  Provide current Azure Table data to your embedded analytics.

• Build Semantic Layer Views for Apify Data in APOS Live Data Gateway

  Use the CData Connector for Apify in APOS Live Data Gateway to build Semantic Layer Views for Apify data.

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

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

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

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

• How to import Productboard Data into Apache Solr

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

• Integrate Power BI XMLA with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Power BI XMLA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Power BI XMLA data.

• Connect to Klipfolio Data in RapidMiner

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

• Connect to LeadDesk Data in Aqua Data Studio

  Access LeadDesk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Analyze Sage 200 Data in Cognos Analytics

  Use CData Connect AI to connect to Sage 200 Data from Cognos Analytics and analyze live Sage 200 data.

• Integrate with Live Amazon DynamoDB Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Amazon DynamoDB from the MuleSoft Anypoint Platform to integrate live Amazon DynamoDB data into custom reports and dashboards.

• Integrate Act-On with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Act-On with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Act-On data.

• Visualize Azure Data Catalog Data in Tableau

  The CData ODBC driver for Azure Data Catalog enables you integrate Azure Data Catalog data into Tableau dashboards.

• Integrating LangChain with Paylocity Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Paylocity data within automated workflows.

• Access DB2 Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live DB2 data from HeidiSQL.

• Visualize Live Google Ad Manager Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Google Ad Manager data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Visualize Active Directory Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Active Directory data in Python.

• Build a PostgreSQL Interface for Unbounce Data using the CData JDBC Driver

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

• Use the CData ODBC Driver for ActiveCampaign in Microsoft Power Query

  You can use the CData ActiveCampaign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ActiveCampaign data into Microsoft Power Query.

• Explore Geographical Relationships in Salesforce Pardot Data with Power Map

  Create data visualizations with Salesforce Pardot data in Power Map.

• How to Work with Certinia Data in ETL Validator JDBC

  Connect to Certinia from ETL Validator jobs using the CData Software JDBC Driver.

• Replicate Multiple Retently Accounts via the CData Sync CLI

  Replicate multiple Retently accounts to one or many databases.

• Build a Simple VCL Application for Zoho CRM Data

  How to build a simple VCL Application to view Zoho CRM data in RAD Studio using the CData ODBC Driver for Zoho CRM.

• How to Access Live SAP HANA XS Advanced Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for SAP HANA XS Advanced enables you to integrate SAP HANA XS Advanced data into workflows built using Microsoft Power Automate Desktop.

• Connect to Spark Data in Aqua Data Studio

  Access Spark data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Automate Oracle SCM Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Oracle SCM data from PowerShell? This article demonstrates how to utilize the Oracle SCM Cmdlets for tasks like connecting to Oracle SCM data, automating operations, downloading data, and more.

• A PostgreSQL Interface for SAP Ariba Procurement Data (MySQL Remoting via JDBC)

  Use the Remoting features of the SAP Ariba Procurement JDBC Driver to create a PostgreSQL entry-point for data access.

• Visualize Highrise Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Highrise data.

• Build Data Flows from PayPal to SQL Server using SSIS

  Easily back up PayPal data to SQL Server using the SSIS components for PayPal.

• How to Visualize Campaigner Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Campaigner data in Python.

• Build a Singer.io Tap for CouchDB With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live CouchDB data using the CData Python Connector.

• How to Access PagerDuty Data Using Entity Framework

  This article shows how to access PagerDuty data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Create Reports from ADP Data in Looker Studio

  Use CData Connect AI to gain access to live ADP data and create custom reports in Looker Studio.

• Automated Continuous QuickBooks Replication to MySQL

  Use CData Sync for automated, continuous, customizable QuickBooks replication to MySQL.

• Build a PostgreSQL Interface for GetResponse Data using the CData JDBC Driver

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

• Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy

  Connect to SAP SuccessFactors data in MicroStrategy Developer using the CData Software ODBC Driver for SAP SuccessFactors.

• Create Dashboards and Visualize Live ZohoPeople Data in Geckoboard

  Use CData Connect AI to connect to live ZohoPeople data and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate Acumatica Data in Pentaho Data Integration

  Build ETL pipelines based on Acumatica data in the Pentaho Data Integration tool.

• Build MVC Applications with Connectivity to Facebook Ads Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Facebook Ads from an ASP.NET MVC application.

• How to load Flowlu data into Elasticsearch via Logstash

  Introducing a simple method to load Flowlu data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to Google Ads from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Ads data, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Model, Search, and Visualize Live Sybase IQ Data in ThoughtSpot

  Use CData Connect AI to connect to live Sybase IQ data for modeling, searching, and visualizing.

• How to Easily Query Keap Data in OpenOffice Base

  Connect to Keap data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• How to integrate Metabase with ZohoDesk Data

  Use CData Connect AI to connect to live ZohoDesk data and create an interactive dashboard in Metabase from ZohoDesk data.

• Integrating LangChain with GitHub Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitHub data within automated workflows.

• «
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• »