CData Software - Knowledge Base

Recent Articles

• «
• 800
• 801
• 802
• 803
• 804
• 805
• 806
• 807
• 808
• 809
• »

• How to connect SharePoint with EnterpriseDB through external lists

  Provide EnterpriseDB to SharePoint users as an external list.

• Access Live MYOB AccountRight in AWS Lambda (with IntelliJ IDEA)

  Connect to live MYOB AccountRight in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

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

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

• Access Microsoft Project from MySQL in PHP

  Connect to Microsoft Project through the standard MySQL libraries in PHP.

• Visualize Live Amazon Athena of Power BI Report Builder in Power BI Service

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

• Use Azure AI Foundry to Talk to Your Snowflake via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Snowflake for you.

• Object-Relational Mapping (ORM) with REST Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to REST into a Java-based ORM framework, Hibernate.

• A PostgreSQL Interface for Square using the CData ODBC Driver

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

• Access Live Todoist in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Todoist into the statistical analysis tools available in SAS JMP. This article shows how to use Todoist in the Graph Builder and Query Builder.

• Build Agents in Relevance AI with Access to Live Quickbase via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Quickbase within intelligent agent workflows.

• Bidirectional Access to Google Ad Manager from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Google Ad Manager in Filemaker Pro for Mac or Windows.

• Provide OData Services of IBM Informix from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for IBM Informix by developing a WCF Service Application.

• Object-Relational Mapping (ORM) with Redshift Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon Redshift into a Java-based ORM framework, Hibernate.

• Connect to Snapchat Ads in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Snapchat Ads and connect to Snapchat Ads in Akorbi Digital RunMyProcess.

• Natively Connect to Dropbox in PHP

  The CData ODBC driver for Dropbox enables you to create PHP applications with connectivity to Dropbox. Leverage the native support for ODBC in PHP.

• Integrate SendGrid in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SendGrid from Informatica Cloud.

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

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Use CData Connect AI to Access Bullhorn CRM in Microsoft Power Pivot

  Use CData Connect AI to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.

• DataBind Zoho Books to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Zoho Books with the DevExpress Windows Forms and Web controls to provide Zoho Books to a chart.

• Model, Search, and Visualize Live Azure Synapse in ThoughtSpot

  Use CData Connect AI to connect to live Azure Synapse for modeling, searching, and visualizing.

• Use the CData Software JDBC Driver for Active Directory in MicroStrategy

  Connect to Active Directory in MicroStrategy Developer using the CData Software JDBC Driver for Active Directory.

• Configure the CData JDBC Driver for Parquet in a Connection Pool in Tomcat

  Connect to Apache Parquet from a connection pool in Tomcat.

• SQL Gateway Overview

  A detailed overview of the SQL Gateway, its function, and its features.

• Build Paylocity-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Paylocity.

• Validate Tableau CRM Analytics with QuerySurge

  Access and validate Tableau CRM Analytics in QuerySurge using the CData JDBC Driver.

• Create Datasets from HDFS in Domo Workbench and Build Visualizations of HDFS in Domo

  Use the CData Software ODBC Driver for HDFS to create datasets from Apache HDFS in Domo Workbench and then build visualizations in the Domo service.

• Build Dashboards with HarperDB in Dundas BI

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

• DataBind Controls to Harvest in C++Builder

  DataBind to Harvest in C++Builder with standard components and controls.

• Build AI Agents with Salesforce Pardot Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can

• Explore Geographical Relationships in QuickBooks Time with Power Map

  Create data visualizations with QuickBooks Time in Power Map.

• Use Azure AI Foundry to Talk to Your BigCommerce via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your BigCommerce for you.

• Connect to Jira from a Connection Pool in WebLogic

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

• Build a Simple VCL Application for Drift

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

• Import ServiceNow Using Azure Data Factory

  Use CData Connect AI to connect to ServiceNow from Azure Data Factory and import live ServiceNow.

• Connecting Mastra with Oracle Eloqua via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.

• Integrate Cursor with Live Excel Online Data via CData Connect AI

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

• Query, Visualize, and Share live SAP HANA in Redash

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

• Query Square as a MySQL Database in Node.js

  Execute MySQL queries against Square from Node.js.

• Integrate Real-Time Access to Azure DevOps in SAPUI5 MVC Apps

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

• How to Query Live Google Contacts in Perplexity MacOS Desktop

  Connect to and query live Google Contacts in Perplexity Desktop using the CData MCP Server.

• How to Connect to Bullhorn CRM in Using Python: 6 Steps

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

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

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sugar CRM using the Model Context Protocol.

• Connect to Greenhouse in Ruby

  Connect to Greenhouse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Deploy the ADO.NET Provider for Salesloft on an SSRS Report Server

  Connect to Salesloft from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Explore Geographical Relationships in Zoho CRM with Power Map

  Create data visualizations with Zoho CRM in Power Map.

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

  Learn how to easily build a Singer.io Tap for live Zoho Creator data using

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

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for RSS

  Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.

• Design BIRT Reports on Blackbaud FE NXT

  Provide current Blackbaud FE NXT to your embedded analytics.

• Load xBase to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load xBase to a database.

• Automated Continuous SendGrid Replication to Apache Kafka

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

• Integrating LangChain with Marketo via CData Connect AI

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

• Analyze Paylocity with Power Pivot

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

• Automated Continuous MarkLogic Replication to SQLite

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

• Zoho Books Reporting and Star Schemas in OBIEE

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

• Automate BigCommerce Replication to Azure Data Lake

  Use CData Sync to customize and automate BigCommerce replication to Azure Data Lake.

• How to Visualize Klaviyo Data in Python with pandas

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

• How to Connect to Live Sage Intacct 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 Sage Intacct for you.

• ServiceNow Reporting and Star Schemas in OBIEE

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

• How to integrate Metabase with SQL Server

  Use CData Connect AI to connect to live Microsoft SQL Server and create an interactive dashboard in Metabase from Microsoft SQL Server.

• Automated Continuous Authorize.Net Replication to Amazon Redshift

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

• Access Live Excel Online in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Excel Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Prepare, Blend, and Analyze Authorize.Net in Alteryx Designer (ODBC)

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

• PowerShell Scripting to Replicate Salesforce to MySQL

  Write a simple PowerShell script to replicate Salesforce & Force.com to a MySQL database.

• How to Connect to Live SAP BusinessObjects BI from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP BusinessObjects BI for you.

• Use the CData API Server to Access Authorize.Net in Microsoft PowerPivot

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

• Operational Reporting on Tally from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Tally ERP.

• Access Live OneNote in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft OneNote from your Google Sheets.

• Query SuiteCRM in DataGrip

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

• Analyze SAP Netweaver Gateway in Slingshot with CData API Server

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

• Access Authorize.Net from MySQL in PHP

  Connect to Authorize.Net through the standard MySQL libraries in PHP.

• Automated Continuous Amazon DynamoDB Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to IBM DB2.

• Use Dash to Build to Web Apps on SuiteCRM

  Create Python applications that use pandas and Dash to build SuiteCRM-connected web apps.

• How to load IBM Cloud Object Storage data into Elasticsearch via Logstash

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

• How to Connect DBeaver to SAP SuccessFactors via a JDBC Driver

  Manage SAP SuccessFactors with visual tools in DBeaver like the query browser.

• Access HarperDB from MySQL in HeidiSQL

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

• Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query

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

• Build Automated Quickbase-Connected Workflows in Zapier

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

• Integrate with Cosmos DB in SnapLogic

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

• Visualize Live MongoDB in the Power BI Service

  Use CData Connect AI to connect to live MongoDB and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to connect to Oracle Financials Cloud in DBVisualizer

  Integrate Oracle Financials Cloud with visual data analysis tools and data connection wizards in DBVisualizer

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

• Use the CData ODBC Driver for Sage 200 in Microsoft Power Query

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

• How to Work with SAP Concur in ETL Validator JDBC

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

• Create Act-On-Connected Business Apps in AppSheet

  Connect to Act-On via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act-On.

• Establish a Live Connection with GitHub using Tableau Bridge

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

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

  Learn how to easily build a Singer.io Tap for live ShipStation data using

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

• «
• 800
• 801
• 802
• 803
• 804
• 805
• 806
• 807
• 808
• 809
• »