CData Software - Knowledge Base

Recent Articles

---

• «
• 480
• 481
• 482
• 483
• 484
• 485
• 486
• 487
• 488
• 489
• »

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

  Use Connect Spreadsheets by CData to gain access to live SurveyMonkey 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.

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

  Create a simple Workflow for SendGrid in Informatica PowerCenter.

• How to connect SharePoint with Highrise Data through external lists

  Provide Highrise CRM to SharePoint users as an external list.

• Connect to Grafana Data in DBArtisan

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

• Query Adobe Commerce Data in ColdFusion

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

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

• Query Google Ads Data through ODBC in Node.js

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

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

  Connect to your Microsoft Dynamics CRM 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 from your Excel spreadsheets.

• Design BIRT Reports on Deel Data

  Provide current Deel 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 CLI 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 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 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 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 Microsoft OneNote 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.

• 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn Ads in Excel.

• Connect to Beeminder Data in Aqua Data Studio

  Access Beeminder 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 Amazon Redshift.

• Automated Continuous Keap Replication to Databricks

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

• Import NetSuite Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access NetSuite CRM & ERP. In this article, you will use the OData format to import NetSuite CRM & ERP into Microsoft Power Query.

• How to connect to Factorial Data with Squirrel SQL client

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

• Automate Tasks in Power Automate Using the CData API Server

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

• 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.

• Use the CData API Server to Access MariaDB Data in Microsoft PowerPivot

  Use the CData API Server to connect to live MariaDB in the Power Pivot business intelligence tool.

• 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.

• Design BIRT Reports on CockroachDB Data

  Provide current CockroachDB to your embedded analytics.

• Query Impala Data in DataGrip

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

• 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle SCM 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 for you.

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

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

• Connect to AgileCRM in SpagoBI

  Create reports featuring live AgileCRM 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 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 from Node.js.

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

  Learn to install and license the CData Python Connector

• 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.

• Design BIRT Reports on Azure Table Data

  Provide current Azure Table Storage 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.

• 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 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 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.

• Connect to Klipfolio Data in RapidMiner

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

• Connect to LeadDesk Data in Aqua Data Studio

  Access LeadDesk 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.

• 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 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.

• Visualize Azure Data Catalog Data in Tableau

  The CData ODBC driver for Azure Data Catalog enables you integrate Azure Data Catalog 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 within automated workflows.

• Access DB2 Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live IBM DB2 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 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 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 into Microsoft Power Query.

• Explore Geographical Relationships in Salesforce Pardot Data with Power Map

  Create data visualizations with Salesforce Pardot 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 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 into workflows built using Microsoft Power Automate Desktop.

• Connect to Spark Data in Aqua Data Studio

  Access Apache Spark SQL 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 from PowerShell? This article demonstrates how to utilize the Oracle SCM Cmdlets for tasks like connecting to Oracle SCM, 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 CRM.

• Build SAP Fieldglass-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for SAP Fieldglass to explore live SAP Fieldglass Data in Claude Code to assist with building SAP Fieldglass-powered applications.

• Build Data Flows from PayPal to SQL Server using SSIS

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

• 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

• How to Access PagerDuty Data Using Entity Framework

  This article shows how to access PagerDuty 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 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 in MicroStrategy Developer using the CData Software ODBC Driver for SAP SuccessFactors.

• Integrate Acumatica Data in Pentaho Data Integration

  Build ETL pipelines based on Acumatica ERP 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, 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 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.

• 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 within automated workflows.

• How to connect to ServiceDesk Plus Data in DBVisualizer

  Integrate ServiceDesk Plus with visual data analysis tools and data connection wizards in DBVisualizer

• Sync Google Contacts with QuickBooks

  The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.

• Visualize Live DB2 Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live IBM DB2 into custom reports in Power BI.

• A PostgreSQL Interface for Excel Data using the CData ODBC Driver

  Use the SQL Gateway and Excel ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Blackbaud FE NXT Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT and execute queries in PowerBuilder.

• Connect to Salesforce Marketing Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Marketing Cloud.

• Bridge Clockify Connectivity with Apache NiFi

  Access and process Clockify in Apache NiFi using the CData JDBC Driver.

• Use the CData Software JDBC Driver for Azure Table in MicroStrategy

  Connect to Azure Table Storage in MicroStrategy Developer using the CData Software JDBC Driver for Azure Table.

• How to Create Power BI Visual Reports with Real-Time Azure Table Data

  Use CData Power BI Connectors to visualize Azure Table Storage in Power BI.

• Integrate with Azure DevOps Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Azure DevOps in SnapLogic.

• Connect to Zoho Creator Data in DBArtisan

  Use wizards in DBArtisan to configure Zoho Creator as a data source.

• Integrating GitHub Copilot CLI with Email 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.

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

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

• Use Dash to Build Web Apps on Sage Cloud Accounting Data via CData Connect AI

  Build interactive Dash web apps on live Sage Business Cloud Accounting using pandas and the CData Connect AI Python SDK.

• Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy

  Connect to Azure Synapse in MicroStrategy Developer using the CData Software JDBC Driver for Azure Synapse.

• Import Greenhouse Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Greenhouse. In this article, you will use the OData format to import Greenhouse into Microsoft Power Query.

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

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

• «
• 480
• 481
• 482
• 483
• 484
• 485
• 486
• 487
• 488
• 489
• »