CData Software - Knowledge Base

Recent Articles

---

• «
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• 833
• 834
• »

• How to connect to ZohoMarketingHub Data with Squirrel SQL client

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

• Visualize LionDesk Data in Sisense

  Create an ElastiCube in Sisense app with access to LionDesk.

• How to Easily Query PayPal Data in OpenOffice Base

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

• Build Automated Google Cloud Storage-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Google Cloud Storage and build automated workflows in Zapier.

• Python Connector Getting Started Guide

  A basic guide to connecting applications to data from anywhere using the CData Python Connector

• Automated Continuous QuickBooks Replication to Oracle

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

• Use the CData Software ODBC Driver for Postmark in MicroStrategy Desktop

  Connect to Postmark in MicroStrategy Desktop using the CData Software ODBC Driver for Postmark.

• Getting Started with the CData Excel Add-In for Facebook Ads

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

• Use Databricks Agent Bricks to Talk to Your Apollo Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apollo for you.

• Build Apps with Live ElevenLabs Data Using the Low-Code Development Platform of Mendix

  Connect ElevenLabs with Mendix to build apps using the CData API Driver for JDBC.

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

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

• Create SSAS Tabular Models from Postmark Data

  How to build a SQL Server Analysis Service Tabular Model from Postmark using CData drivers.

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

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

• Access Live Oracle Financials Cloud Data in AWS Lambda

  Connect to live Oracle Financials Cloud in AWS Lambda using the CData JDBC Driver.

• How to Access Live Zoho Books Data in Visual Studio Code via Cline

  Run CData MCP Server for Zoho Books on Windows Subsytem for Linux (WSL) and connect to live Zoho Books from the Cline extension in Visual Studio Code.

• Connect to SAP Ariba Procurement Data in Google Apps Script via Connect AI

  Use CData Connect AI to access SAP Ariba Procurement in Google Apps Script.

• Visualize SFTP Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SFTP into TIBCO Spotfire.

• How to connect to Tavily Data in DBVisualizer

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

• How to Access Live SAP Hybris C4C Data in Visual Studio Code via Cline

  Run CData MCP Server for SAP Hybris C4C on Windows Subsytem for Linux (WSL) and connect to live SAP Hybris C4C from the Cline extension in Visual Studio Code.

• Integrating OpenCode Terminal with ServiceNow 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 Google Sheets Data in ACL Analytics

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

• Query, Visualize, and Share live SAP Business One Data in Redash

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

• How to Build an ETL App for Superchat Data in Python with CData

  Create ETL applications and real-time data pipelines for Superchat in Python with petl.

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

• How to Access PostgreSQL Data Using Entity Framework

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

• Bind Live OneNote Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live OneNote data

• Migrating data from IBM Informix to Google BigQuery using CData SSIS Components.

  Easily push IBM Informix to Google BigQuery using the CData SSIS Tasks for IBM Informix and Google BigQuery.

• Query Recurly Data in ColdFusion

  Write standard ColdFusion data access code to connect to Recurly.

• Import Real-Time Hacker News Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Hacker News in ColdFusion.

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

  Use CData Power BI Connector for Redshift and Dataflow to import and use Amazon Redshift in Power Apps.

• Use Biml to Build SSIS Tasks to Replicate RabbitMQ Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate RabbitMQ to SQL Server.

• How to Connect to & Open Square Data in Microsoft Excel

  This article uses the CData ODBC driver for Square to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Replicate Zuora Data in Heroku for Use in Salesforce Connect

  Replicate Zuora to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Integrating Dataiku with IBM Cloud Object Storage Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live IBM Cloud Object Storage.

• How to Visualize SAS Data Sets Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAS Data Sets in Python.

• HTTP 403 Forbidden Error When Querying to ServiceNow

  This entry details the typical causes of the error as well as the ServiceNow permissions needed to resolve them.

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

• Integrating Antigravity CLI with RSS Feeds via CData CLI

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

• Connect to MarkLogic Data from AWS Glue

  Use CData Connect AI to gain access to live MarkLogic from your AWS Glue jobs.

• How to create WordPress federated tables in MySQL

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

• Create ADP-Connected Applications in Appsmith

  Connect to ADP Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ADP.

• Build Data Flows from SQL Server to Cvent through SSIS

  Easily push SQL Server data to Cvent using the CData SSIS Tasks for Cvent.

• Design BIRT Reports on Paymo Data

  Provide current Paymo to your embedded analytics.

• Integrating LangGraph with SurveyMonkey Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on SurveyMonkey within automated workflows.

• Connect to SAP BusinessObjects BI Data in Google Apps Script via Connect AI

  Use CData Connect AI to access SAP BusinessObjects BI in Google Apps Script.

• Analyze Email Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Email and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• How to connect to Salesforce Data with Squirrel SQL client

  Connect to Salesforce & Force.com and execute queries in the Squirrel SQL Client.

• Moving Data from Sage 200 to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Sage 200 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Automate Oracle SCM Data Replication to SAP HANA

  Use CData Sync to customize and automate Oracle SCM replication to SAP HANA.

• Build a Simple VCL Application for Foursquare Data

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

• Establish a Live Connection with ScrapingBee Data using Tableau Bridge

  The CData ODBC Driver for ScrapingBee enables you to integrate live ScrapingBee into Tableau Cloud dashboards using the Tableau Bridge.

• Migrating data from Salesloft to Databricks using CData SSIS Components.

  Easily push Salesloft to Databricks using the CData SSIS Tasks for Salesloft and Databricks.

• Getting Started with the CData SSIS Components for FormSite

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

• Use Biml to Build SSIS Tasks to Replicate Smartsheet Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Smartsheet to SQL Server.

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

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

• Bridge Salesforce Data 360 Connectivity with Apache NiFi

  Access and process Salesforce Data 360 in Apache NiFi using the CData JDBC Driver.

• Automated Continuous SQL Server Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft SQL Server replication to OneLake in Microsoft Fabric.

• Query DocuSign Data as a MySQL Database in Node.js

  Execute MySQL queries against DocuSign from Node.js.

• Bridge ConvertAPI Connectivity with Apache NiFi

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

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

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

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

• Integrate Authorize.Net Data in Pentaho Data Integration

  Build ETL pipelines based on Authorize.Net in the Pentaho Data Integration tool.

• Create Oracle SCM-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Oracle SCM Data from Klipfolio and build custom visualizations using live Oracle SCM.

• Build Charts with LDAP Objects in Clear Analytics

  Create dynamic charts and perform analytics based on LDAP in Clear Analytics.

• Connect to Avro from a Connection Pool in WebLogic

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

• Replicate Moosend Data to Multiple Databases

  Replicate Moosend to disparate databases with a point-and-click configuration.

• How to Connect Cosmos DB 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 Cosmos DB data in real time using natural language.

• Access Live Splunk Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Splunk through MCP integration.

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

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

• Integrating Codex CLI with HubSpot 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 Shippo Data in CloverDX (formerly CloverETL)

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

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

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

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

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

• Integrate Live Microsoft Ads Data into Amazon SageMaker Canvas with RDS

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

• Integrating GitHub Copilot CLI with IBM Cloud Object Storage 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 Paylocity Data in RapidMiner

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

• Build Automated Zoho Inventory-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Zoho Inventory and build automated workflows in Zapier.

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

  Connect to Active Directory from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

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

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

• Getting Started with the CData Tableau Connector for Supabase

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

• Connect to Cloudant Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloudant.

• Integrate with Azure Synapse Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Synapse to a JSON file on disk.

• Create Data Visualizations in Cognos BI with Simplesat Data

  Access Simplesat as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

• Bridge Marketo Connectivity with Apache NiFi

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

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

• Replicate Supabase Data in Heroku for Use in Salesforce Connect

  Replicate Supabase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

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

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

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

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

• Visualize Pingdom Data in Tableau

  The CData ODBC driver for Pingdom enables you integrate Pingdom into Tableau dashboards.

• Import and Visualize BambooHR Data in Power View

  Create data visualizations based on BambooHR in Excel.

• Publish EnterpriseDB-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live EnterpriseDB.

• Query Factorial Data through ODBC in Node.js

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

• How to Visualize Paddle Data in Python with pandas

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

• Connect to and Visualize Live Freshteam Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshteam.

• Connecting Moonlit Workflow with Email 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 Email in real time.

• Access Live Zoho Books Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Zoho Books from your Excel spreadsheets.

• Analyze Instantly Data with Power Pivot

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

• Analyze Redis Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Redis and visualize Redis in SAP Analytics Cloud.

• Automated Continuous Microsoft Teams Replication to Databricks

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

• «
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• 833
• 834
• »