CData Software - Knowledge Base

Recent Articles

---

• «
• 924
• 925
• 926
• 927
• 928
• 929
• 930
• 931
• 932
• 933
• »

• Visualize SAS xpt Data in Sisense

  Create an ElastiCube in Sisense app with access to SAS XPORT.

• Connect to ADP Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for ADP in Airbyte.

• Build Dashboards with Tickspot Data in Dundas BI

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

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

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

• Connect to SAP Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for SAP and the SQL Gateway to access SAP ERP/NetWeaver from Google Apps Script.

• Automated Continuous MailChimp Replication to Google Cloud SQL

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

• Automated Continuous Salesforce Marketing Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Amazon S3.

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

  Connect to CampaignMonitor 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.

• Connect to Microsoft Planner Data in DBeaver

  Use the CData ODBC Driver to connect to Microsoft Planner in DBeaver.

• Integrate Open WebUI with Live Avalara AvaTax Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Avalara AvaTax from within the chat interface.

• Query OneNote Data in DataGrip

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

• How to Connect to ServiceDesk Plus Data in Using Python: 6 Steps

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

• Integrating Gumloop with FTP Data via CData Connect AI

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

• Connect to Blackbaud FE NXT Data in NetBeans

  Connect to Blackbaud FE NXT in NetBeans with the data source configuration wizard.

• Replicate Rebilly Data to Multiple Databases

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

• Replicate Perplexity Data from PowerShell

  Write a quick PowerShell script to query Perplexity. Use connectivity to the live data to replicate Perplexity to SQL Server.

• Access Live Amazon Marketplace Data in TIBCO Data Virtualization

  Use the Amazon Marketplace Tibco DV Adapter to create a Amazon Marketplace data source in TIBCO Data Virtualization Studio and gain access to live Amazon Marketplace from your TDV Server.

• Visualize FreshBooks Data in Tableau

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

• Import and Visualize Hubstaff Data in Power View

  Create data visualizations based on Hubstaff in Excel.

• Connect to NetSuite Data in ACL Analytics

  Connect to NetSuite CRM & ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to NetSuite CRM & ERP.

• How to Connect to Live GitLab Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your GitLab for you.

• Enable the BigCommerce JDBC Driver in KNIME

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

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

  Connect to Ontraport 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.

• Access Google Analytics Data as a Remote Oracle Database

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

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

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

• Automated Continuous Dynamics 365 Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Dynamics 365 replication to MongoDB.

• Analyze Procore Data in R via JDBC

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

• Replicate Mailgun Data to Multiple Databases via the CData Sync CLI

  Replicate Mailgun to disparate databases with a single configuration.

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

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

• Getting Started with the CData SSIS Components for Apify

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

• Connect to MYOB AccountRight Data from PowerBuilder via JDBC

  This article demonstrates how to access MYOB AccountRight from PowerBuilder using the MYOB AccountRight JDBC Driver.

• How to load ActiveCampaign data into Elasticsearch via Logstash

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

• Automated Continuous Smartsheet Data Replication to OneLake in Microsoft Fabric

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

• Analyze Trello Data in Slingshot with CData API Server

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

• Connect to Tavily Data in Jaspersoft Studio

  Execute SQL to remote Tavily in Jaspersoft Studio.

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

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

• Integrating Dataiku with Microsoft Dataverse Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Dataverse (CDS).

• Connect to SAP Concur Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Concur.

• How to Connect DBeaver to Greenplum via a JDBC Driver

  Manage Pivotal GreenPlum with visual tools in DBeaver like the query browser.

• How to connect to ZohoExpense Data with Squirrel SQL client

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

• Moving Data from SAP BusinessObjects BI to SQL Server Using Toad Data Point and CData ODBC Driver

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

• Visualize Live Postmark Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Postmark.

• Use Microsoft Copilot Studio to talk to your Cloudant Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your IBM Cloudant for you.

• Automated Continuous ShipEngine Replication to IBM DB2

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

• ETL Reply.io in Oracle Data Integrator

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

• Create Data Visualizations in Cognos BI with QuickBooks Time Data

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

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

  Create a simple Workflow for BenchmarkEmail in Informatica PowerCenter.

• How to publish and share NetSuite Data dashboards with Tableau Server

  The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.

• Operational Reporting on Auth0 Data from Spotfire Server

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

• Build Voice Agents in ElevenLabs with access to Live Google Directory Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Directory.

• Connect to Drift Data from a Connection Pool in JBoss

  Integrate Drift into Java servlets: Use the Management Console in JBoss to install the Drift JDBC Driver.

• How to connect and process LeadDesk from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live LeadDesk.

• Visualize ZeroBounce Data in Tableau

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

• Connect to Hive Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Apache Hive from Filemaker Pro on Mac.

• Migrating data from Pipeline CRM to Databricks using CData SSIS Components.

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

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

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

• Connect to Live Lakebase Data in MicroStrategy through CData Connect AI

  Create a live connection to Lakebase Data in CData Connect AI and connect to your Lakebase from MicroStrategy.

• Connect to FreshBooks Data in RazorSQL

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

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

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

• Access Live Microsoft Dataverse Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Microsoft Dataverse (CDS) from your Excel spreadsheets.

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

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

• How to Query Live Outlook Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Outlook data in natural language using Python.

• Integrating LlamaIndex with MariaDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MariaDB in real time.

• Connect to Brex Data in Ruby

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

• Connecting Mastra with Vertica Data 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 Vertica, no replication required.

• Connect to Aircall Data from a Connection Pool in Jetty

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

• Automated Continuous SharePoint Replication to Databricks

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

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

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

• Query Phoenix Data through ODBC in Node.js

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

• Create Informatica Mappings From/To an ODBC Data Source for ConvertKit

  Create an ODBC connection to ConvertKit in Informatica and browse and transfer ConvertKit.

• Automated Continuous OnePageCrm Replication to Apache Kafka

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

• Analyze Facebook Ads Data in R via JDBC

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

• Connecting Agentforce with Asana Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Asana for you.

• Integrate QuickBooks Online Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to QuickBooks Online and integrate live QuickBooks Online into your Power Automate tasks.

• A PostgreSQL Interface for Google Drive Data using the CData ODBC Driver

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

• Establish a Live Connection with HubSpot Data using Tableau Bridge

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

• How to Design Cosmos DB Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to Cosmos DB from mobile and tablet Power Apps.

• Validate Sugar CRM Data with QuerySurge

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

• Box Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Box through CData Connect AI using different applications and tools.

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

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

• Process & Analyze Klipfolio Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Klipfolio Data.

• Access Drift Data from MySQL in PHP

  Connect to Drift through the standard MySQL libraries in PHP.

• How to update Cassandra from Excel

  This article explains how to transfer data from Excel to Cassandra using the Excel Add-In for Cassandra.

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

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

• Publish Pinterest-Connected Dashboards in Tableau Server

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

• Getting Started with the CData Power BI Connector for Workday

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Workday.

• Build Impala-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Impala Data and create custom apps in Mendix.

• Analyze Printify Data with Power Pivot

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

• Automated Continuous Moosend Replication to Oracle

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

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

  Connect to your QuickBooks Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to Power BI XMLA Data in RazorSQL

  Connect to Power BI XMLA from wizards and query Power BI XMLA from the GUI in the RazorSQL database management tool.

• Validate Snowflake Data with QuerySurge

  Access and validate Snowflake in QuerySurge using the CData JDBC Driver.

• How to connect to Pipeline CRM Data with Squirrel SQL client

  Connect to Pipeline CRM and execute queries in the Squirrel SQL Client.

• Connect to Planio Data in DBArtisan

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

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

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

• Automated Continuous Adobe Analytics Replication to Local Delimited Files

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

• Query NetSuite Data as a SQL Server Database in Node.js

  Execute SQL Server queries against NetSuite CRM & ERP from Node.js.

• Connect to JSON Services in the Denodo Platform

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

• Operational Reporting on Webflow Data from Spotfire Server

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

• Visualize Active Directory Data in Tableau

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

• «
• 924
• 925
• 926
• 927
• 928
• 929
• 930
• 931
• 932
• 933
• »