CData Software - Knowledge Base

Recent Articles

---

• «
• 450
• 451
• 452
• 453
• 454
• 455
• 456
• 457
• 458
• 459
• »

• Access Live Google Drive Data in Excel 365 Online (Excel for the web)

  Connect to Google Drive from Excel 365 Online (Excel for the web) with CData Connect AI.

• How to update Avalara AvaTax from Excel

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

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

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

• Automated Continuous Box Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Box replication to AlloyDB.

• Create Informatica Mappings From/To a JDBC Data Source for Yelp

  Create Yelp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Analyze Mistral AI Data in R via JDBC

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

• Integrating Instagram Data in Talend Cloud Data Management Platform

  Connect Instagram Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Instagram.

• Automated Continuous Pinterest Replication to Amazon S3

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

• ETL WooCommerce in Oracle Data Integrator

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

• Query ConvertKit Data through ODBC in Node.js

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

• Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Azure Data Lake Storage.

• Build Automated Workflows with Live Google Ads Data in Workato

  Use CData Connect AI to connect to live Google Ads and build automated workflows in Workato.

• Create JSON-Connected Dashboards in Grafana

  Connect to JSON Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to JSON.

• Automated Continuous Act-On Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Act-On replication to AlloyDB.

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

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

• How to Connect Flowise AI Agents to Live Xero Data via CData Connect AI

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

• Getting Started with the CData ODBC Driver for Printful

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printful.

• Publish Microsoft Planner-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Planner.

• Natively Connect to Act CRM Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Act CRM. Leverage the native support for ODBC in PHP.

• DataBind Clari Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Clari to a chart.

• Access RabbitMQ Data from MySQL in PHP

  Connect to RabbitMQ through the standard MySQL libraries in PHP.

• Extract, Transform, and Load Oracle Service Cloud Data in Informatica PowerCenter

  Create a simple Workflow for Oracle Service Cloud in Informatica PowerCenter.

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

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

• Explore Geographical Relationships in AfterShip Data with Power Map

  Create data visualizations with AfterShip in Power Map.

• Access Planio Data from MySQL in PHP

  Connect to Planio through the standard MySQL libraries in PHP.

• Build JSON-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JSON.

• Explore Geographical Relationships in Jira Assets Data with Power Map

  Create data visualizations with Jira Assets in Power Map.

• How to connect and process Instagram from Azure Databricks

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

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

  Execute MySQL queries against Basecamp from Node.js.

• Getting Started with the CData ADO.NET Provider for Vault CRM

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Vault CRM.

• Replicate Snapchat Ads Data to Multiple Databases

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

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

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

• Replicate Multiple SAP SuccessFactors Accounts

  Replicate multiple SAP SuccessFactors accounts to one or many databases.

• Integrating OpenCode Terminal with Excel Online 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.

• Load Close Data to a Database Using Embulk

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

• Connect to AgileCRM Data in DBArtisan

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

• Integrate VWO with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate VWO with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to VWO.

• Integrate LibreChat with Live HCL Domino Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live HCL Domino from within the chat interface.

• Integrate with EmailOctopus Data using Apache Camel2

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

• Connect to Smartsheet Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to HBase Data from AWS Glue

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

• Automated Shippo Data Replication to Teradata

  Use CData Sync to Customize and automate Shippo replication to Teradata.

• Create Datasets from Tally in Domo Workbench and Build Visualizations of Tally Data in Domo

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

• Replicate Google Contacts Data from PowerShell

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

• Replicate Reckon Accounts Hosted Data to Multiple Databases via the CData Sync CLI

  Replicate Reckon Accounts Hosted to disparate databases with a single configuration.

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

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Atlassian Confluence.

• Automated Continuous Facebook Ads Replication to Oracle

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

• Use JayDeBeApi to access Retently Data in Python

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

• Access Live Google Ads Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Ads through MCP integration.

• Automated Bullhorn CRM Data Replication to Teradata

  Use CData Sync to Customize and automate Bullhorn CRM replication to Teradata.

• Integrate Microsoft Planner Data into Power Automate Desktop using CData Connect

  CData Connect for Microsoft Planner Data enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Supabase Replication to SQL Server

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

• Use Azure AI Foundry to Talk to Your Zoho Creator Data 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 Zoho Creator for you.

• How to integrate Anaplan with Apache Airflow

  Access and process Anaplan in Apache Airflow using the CData JDBC Driver.

• Creating Spark-Connected Applications in Unqork

  You can use CData Connect AI to feed Apache Spark SQL to Unqork and build custom business apps.

• Connect to Epicor Kinetic Data in DBArtisan

  Use wizards in DBArtisan to configure Epicor Kinetic as a data source.

• How to connect to Notion Data from IntelliJ

  Integrate connectivity to Notion with wizards in IntelliJ.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed GitHub to Power BI dashboards. Simply drag and drop GitHub into data visuals on the Power BI canvas.

• Automate IBM Informix Data Replication to Azure Data Lake

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

• Connect to LaunchDarkly Data in RapidMiner

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

• Connect to Demio Data as an External Source in Dremio

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

• Automated Continuous Testmonitor Replication to SQLite

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

• Use the CData Software JDBC Driver for Cvent in MicroStrategy

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

• DataBind ZohoPeople Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoPeople to a chart.

• A PostgreSQL Interface for Figshare Data (MySQL Remoting via JDBC)

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

• Automated Continuous Notion Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Notion replication to SingleStore.

• Create SSAS Tabular Models from Planio Data

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

• Analyze GraphQL Data in Looker

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

• Build Excel Online-Connected Apps in Mendix

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

• Getting Started with the CData Power BI Connector for Google Spanner

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

• Creating SAP ByDesign-Connected Applications in Unqork

  You can use CData Connect AI to feed SAP Business ByDesign to Unqork and build custom business apps.

• Integrating Dataiku with YouTube 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 YouTube Analytics.

• How to create Visio diagrams from Workday Data

  Automatically update Workday with the changes you make to Visio master shapes.

• Integrating Gumloop with Databricks Data via CData Connect AI

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

• Integrate EnterpriseDB Data into Automated Tasks with Power Automate

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

• How to Visualize CSV Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live CSV/TSV Files in Python.

• Integrate BigCommerce Data in the Pentaho Report Designer

  Publish reports based on BigCommerce in the Pentaho BI tool.

• Build Voice Agents in ElevenLabs with access to Live Dynamics CRM Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Dynamics CRM.

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

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

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

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

• How to Query Live Microsoft Planner Data in Perplexity MacOS Desktop

  Connect to and query live Microsoft Planner Data in Perplexity Desktop using CData MCP Server.

• Access BenchmarkEmail Data from MySQL in PHP

  Connect to BenchmarkEmail through the standard MySQL libraries in PHP.

• Connect to SFTP Data from a Connection Pool in Jetty

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

• Use ChatGPT to Talk to Your Phoenix Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache Phoenix for you.

• Analyze GitHub Data in Slingshot with CData API Server

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

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

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

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

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

• Automate Jira Assets Tasks in Power Automate Using CData API Server

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

• Import Zoho Books Data into Microsoft Power Query

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

• Integrate Active Directory Data in Your Informatica Cloud Instance

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

• How to Connect to Live Microsoft Teams Data 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 Microsoft Teams for you.

• How to use SQLAlchemy ORM to access Factorial Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Factorial.

• Perform Batch Operations with Zendesk Data in Apache NiFi

  Connect to Zendesk and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create ServiceNow-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to ServiceNow Data from OutSystems and build custom enterprise apps using live ServiceNow.

• Connect to Vault CRM Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Veeva Vault & Vault CRM from Crystal Reports.

• Connecting Agentforce with JSON Services 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 JSON for you.

• Getting Started with the CData SSIS Components for Bullhorn CRM

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

• Query Live Excel Online Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft Excel Online directly from the development environment.

• Query Greenplum Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.

• Write a Simple Go Application to work with VWO Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to VWO.

• «
• 450
• 451
• 452
• 453
• 454
• 455
• 456
• 457
• 458
• 459
• »