CData Software - Knowledge Base

Recent Articles

---

• «
• 514
• 515
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• »

• Create OData-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to OData Services from Klipfolio and build custom visualizations using live OData.

• Connect to Sugar CRM through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Sugar CRM using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Visualize NetSuite from Tableau

  Use the Tableau Desktop business intelligence tool to connect to NetSuite CRM & ERP.

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

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

• Access Epicor Kinetic from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Epicor Kinetic from HeidiSQL.

• Prepare, Blend, and Analyze WordPress in Alteryx Designer (ODBC)

  Build workflows to access live WordPress for self-service data analytics.

• How to Connect to HDFS in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Apache HDFS. Leverage the pyodbc module for ODBC in Python.

• Automated Continuous Sage 300 Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Sage 300 replication to IBM DB2.

• How to Connect to Live Exact Online from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Exact Online for you.

• Easily Integrate Epicor Kinetic in Lazarus Pascal IDE

  Learn how to easily integrate live Epicor Kinetic in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Analyze Stripe in Looker

  Use CData Connect AI to connect to Stripe from Looker and build custom apps using live Stripe.

• Automated Continuous Twitter Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Twitter replication to SQL Server.

• Prepare, Blend, and Analyze OData Services in Alteryx Designer (ODBC)

  Build workflows to access live OData for self-service data analytics.

• Use the CData Software ODBC Driver for ConstantContact in SAS for Real-Time Reporting and Analytics

  Connect to real-time ConstantContact in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConstantContact.

• Use the CData Software ODBC Driver for Okta in MicroStrategy

  Connect to Okta in MicroStrategy Developer using the CData Software ODBC Driver for Okta.

• Connect to Office 365 as an External Source in Dremio

  Use the CData JDBC Driver to connect to Office 365 as an External Source in Dremio.

• Create Dashboards and Visualize Live WooCommerce in Geckoboard

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

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

• Using the CData Software ODBC Driver for eBay in PyCharm

  Connect to eBay as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay.

• Connect to SAP Concur from a Connection Pool in Jetty

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

• Integrating LangChain with WooCommerce via CData Connect AI

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

• Access Unbounce as a Remote Oracle Database

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

• Dynamics NAV Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Dynamics NAV facts in real time.

• Establish a Live Connection with CSV using Tableau Bridge

  The CData ODBC Driver for CSV enables you to integrate live CSV/TSV Files into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to Zuora from HeidiSQL

  Use CData Connect AI to connect to and query live Zuora from HeidiSQL.

• Create Redis-Connected Applications in Appsmith

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

• Connect to Sage 300 in RazorSQL

  Connect to Sage 300 from wizards and query Sage 300 from the GUI in the RazorSQL database management tool.

• Integrate Excel in Pentaho Data Integration

  Build ETL pipelines based on Microsoft Excel in the Pentaho Data Integration tool.

• Elasticsearch Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Elasticsearch facts in real time.

• A PostgreSQL Interface for QuickBooks Online (MySQL Remoting via JDBC)

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

• How to Import Data from AlloyDB into Google Sheets

  Import Google AlloyDB into a Google spreadsheet that is automatically refreshed.

• How to Connect to Live Power BI XMLA in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Power BI XMLA for you.

• Use the CData API Server to Access Avro in Microsoft PowerPivot

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

• Access Live QuickBooks Online Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live QuickBooks Online data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Work with PayPal in FoxPro

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

• Model Jira Service Management Using Azure Analysis Services

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

• Create Azure Analysis Services-Connected Nintex Workflows

  Use CData Connect AI to connect to Azure Analysis Services from Nintex Workflow Cloud and build custom workflows using live Azure Analysis Services.

• Automated Continuous MySQL Replication to Google Cloud SQL

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

• How to Design MailChimp Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Automate Office 365 Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Microsoft Office 365 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Analyze Reckon Accounts Hosted in Slingshot with CData API Server

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

• Visualize Live Kintone of Power BI Report Builder in Power BI Service

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

• Import eBay into Microsoft Power Query

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

• Getting Started with the CData Excel Add-In for Act-On

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

• A PostgreSQL Interface for ServiceNow using the CData ODBC Driver

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Easily Integrate BigCommerce in Lazarus Pascal IDE

  Learn how to easily integrate live BigCommerce in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Explore Geographical Relationships in Azure DevOps with Power Map

  Create data visualizations with Azure DevOps in Power Map.

• Automated Continuous Azure Active Directory Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to IBM DB2.

• How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted through natural language.

• Import Real-Time Wave Financial via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Wave Financial in ColdFusion.

• Automated Continuous LDAP Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable LDAP replication to Google BigQuery.

• How to Visualize Zoho CRM Data in Python with pandas

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

• Extend Google Sheets with SAP Concur

  Make calls to the API Server from Google Apps Script.

• Use the CData Software ODBC Driver for Jira Assets in SAS for Real-Time Reporting and Analytics

  Connect to real-time Jira Assets in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jira Assets.

• Analyze Salesforce Pardot in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Salesforce Pardot with the CData JDBC Driver for Salesforce Pardot.

• Publish Crystal Reports on Azure Active Directory

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Active Directory.

• Create Dynamics NAV Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• How to use SQLAlchemy ORM to access Sage Cloud Accounting in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage Business Cloud Accounting.

• Analyze Impala in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Apache Impala and visualize live Apache Impala in Infragistics Reveal.

• How to Connect Flowise AI Agents to Live SAP ByDesign via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

• ETL DocuSign in Oracle Data Integrator

  This article shows how to transfer DocuSign into a data warehouse using Oracle Data Integrator.

• Integrating Gumloop with DocuSign via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on DocuSign within automated workflows.

• Using the CData Software ODBC Driver for Excel Online in PyCharm

  Connect to Excel Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel Online.

• Access Zoho Books from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Books from HeidiSQL.

• Use JayDeBeApi to access Excel in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft Excel.

• Connect to Cosmos DB from HeidiSQL

  Use CData Connect AI to connect to and query live Azure Cosmos DB from HeidiSQL.

• Connect to MySQL in CloverDX (formerly CloverETL)

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

• Integrate Google Contacts with External Services using SnapLogic

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

• Connect to Adobe Target in DBArtisan

  Use wizards in DBArtisan to configure Adobe Target as a data source.

• Automated Continuous Certinia Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Certinia replication to delimited files (CSV/TSV).

• Building Dynamic Web Pages with Pipedrive Using AngularJS

  Create single-page applications with live connectivity to Pipedrive using the CData API Server.

• Create Apps from Twitter in Qlik Sense Cloud

  Use CData Connect AI to connect to Twitter and build apps from live Twitter in Qlik Sense Cloud.

• Integrate Cline with Live Zoho Creator Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Creator from within your IDE.

• Access Live Dynamics 365 Business Central in TIBCO Data Virtualization

• «
• 514
• 515
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• »