CData Software - Knowledge Base

Recent Articles

---

• «
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• 376
• 377
• 378
• »

• Build a Simple VCL Application for ZohoPeople Data

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

• Connect to Exact Online Data from PowerBuilder via JDBC

  This article demonstrates how to access Exact Online from PowerBuilder using the Exact Online JDBC Driver.

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

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

• Publish Crystal Reports on SFTP Data

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

• Visualize Live Eventbrite Data in Tableau

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

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

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

• Use the CData SSIS Components to Insert New or Update Existing Cvent Records from SQL Server

  Easily push SQL Server data to Cvent using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cvent or update existing records with data from a SQL Server database.

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

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

• Integrating Cursor CLI with Snapchat Ads 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.

• Use Grok to Talk to Your Outreach.io Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Outreach.io for you.

• Perform Batch Operations with Dynamics CRM Data in Apache NiFi

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

• How to Work with Xero Data in ETL Validator JDBC

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

• How to connect to Zendesk Data in DBVisualizer

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

• How to Query Live Slack Data in Claude Desktop

  Connect to and query live Slack Data in Claude Desktop using CData MCP Server.

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

  Connect to Apache CouchDB from Excel 365 Online (Excel for the web) with CData Connect AI.

• Build Dashboards with PabblySubscriptions Data in Dundas BI

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

• Access Live Box Data in Coginiti Pro

  Connect to and query live Box from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Access QuickBooks Custom Fields in Excel

  Update custom fields in QuickBooks using the CData Excel Add-In for QuickBooks.

• How to Create Power BI Visual Reports with Real-Time Impala Data

  Use CData Power BI Connectors to visualize Apache Impala in Power BI.

• Use the CData Software JDBC Driver for Zuora in MicroStrategy Web

  Connect to Zuora in MicroStrategy Web using the CData Software JDBC Driver for Zuora.

• ETL Perigon in Oracle Data Integrator

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

• How to connect to AgileCRM Data from Spring Boot

  Connect to AgileCRM in a Spring Boot Application using the CData API Driver for JDBC

• How to connect to PabblySubscriptions Data from IntelliJ

  Integrate connectivity to PabblySubscriptions with wizards in IntelliJ.

• Integrating Antigravity CLI with EnterpriseDB via CData CLI

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

• Bidirectional Access to Ontraport Data from FileMaker Pro

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

• Replicate NetSuite Data from PowerShell

  Write a quick PowerShell script to query NetSuite CRM & ERP. Use connectivity to the live data to replicate NetSuite CRM & ERP to SQL Server.

• Integrating OpenCode Terminal with Yelp 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 OnePageCrm Data from a Connection Pool in Jetty

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

• Work with Live Google Ad Manager Data in Power Query

  Use CData Connect AI to connect to Google Ad Manager and work with live Google Ad Manager in Microsoft Power Query.

• How to connect PolyBase to xBase

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live xBase.

• Connect to Power BI XMLA Data in HULFT Integrate

  Connect to Power BI XMLA as a JDBC data source in HULFT Integrate

• Visualize Live RabbitMQ Data of Power BI Report Builder in Power BI Service

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

• Analyze Zoom Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Zoom in Microsoft R Open.

• Use Microsoft Copilot Studio to talk to your SAP SuccessFactors 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 SAP SuccessFactors for you.

• Connect to Contentful Data in DBArtisan

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

• How to connect and process Everhour from Azure Databricks

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

• Access Rebilly Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Rebilly.

• Build Microsoft Teams-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Teams and build web apps with connectivity to live Microsoft Teams.

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

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

• Connect to Zuora Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Zuora and the Script function in FileMaker Pro to connect to Zuora and work with Zuora in your FileMaker application.

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

  Use the ODBC Driver for Demio and the SQL Gateway to access Demio from Google Apps Script.

• Connect to Excel Online Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Microsoft Excel Online.

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

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

• Back Up Apache HDFS to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HDFS. In this article, we will employ an SSIS workflow to populate a database with Apache HDFS data.

• Connect to Clio Data in Ruby

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

• Connect to Superchat Data in the Denodo Platform

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

• Bidirectional Access to Salesforce Marketing Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Marketing Cloud in Filemaker Pro for Mac or Windows.

• Import Real-Time Amazon Athena Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Amazon Athena in ColdFusion.

• Load BenchmarkEmail Data to a Database Using Embulk

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

• Automated Continuous Oracle Service Cloud Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to OneLake in Microsoft Fabric.

• Integrate Live FormSite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live FormSite to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

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

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

• Create Data Visualizations in Cognos BI with Zoho Creator Data

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

• Build BambooHR-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to BambooHR and build web apps with connectivity to live BambooHR.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Microsoft Entra ID actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Replicate HelloSign Data in Heroku for Use in Salesforce Connect

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

• Connect to QuickBooks Time Data in DBArtisan

  Use wizards in DBArtisan to configure QuickBooks Time as a data source.

• Connect to Aweber Data in Jaspersoft Studio

  Execute SQL to remote Aweber in Jaspersoft Studio.

• Integrating Cursor CLI with Zoho Recruit 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.

• Integrating LangGraph with BigCommerce Data via CData Connect AI

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

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

  Provide connectivity to Templated through an SAP BusinessObjects universe.

• Connect to RabbitMQ Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time RabbitMQ using standard SQL.

• Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy Desktop

  Connect to SAP Ariba Procurement in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Procurement.

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

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

• How to Connect to Live Active Directory Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Active Directory for you.

• Integrating LlamaIndex with SAP Netweaver Gateway Data via CData Connect AI

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

• Replicate SendInBlue Data from PowerShell

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

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

• Edit and Search External Oracle Financials Cloud Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Oracle Financials Cloud to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Financials Cloud Data objects that you can access from apps and the dashboard.

• How to connect Amazon QuickSight to Snowflake Data

  Create a connection to Snowflake in CData Connect AI and insert Snowflake into Amazon QuickSight SPICE to build interactive dashboards.

• Connect and Visualize Live PayPal Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live PayPal into the Databricks platform and create visualization dashboards with real-time PayPal.

• Getting Started with the CData ODBC Driver for HCL Domino

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

• Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid

  Learn how you can connect Sage Cloud Accounting to Infragistics XamDataGrid to build dynamic grids.

• How to Connect to Live SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.

• Create Power BI Reports on Real-Time Office 365 Data

  Use the CData ODBC Driver for Office 365 to visualize Microsoft Office 365 in Power BI Desktop.

• Connect to and Visualize Live Greenplum Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pivotal GreenPlum.

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

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

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

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

• Automated Continuous Sage 300 Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon Redshift.

• Getting Started with the CData ODBC Driver for Pipedrive

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

• Connect to Greenplum Data in CloverDX (formerly CloverETL)

  Transfer Pivotal GreenPlum using the visual workflow in the CloverDX data integration tool.

• Create Basecamp-Connected Dashboards in Grafana

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

• Automated Continuous Freshservice Replication to AlloyDB

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

• Import and Visualize SAP Netweaver Gateway Data in Power View

  Create data visualizations based on SAP Netweaver Gateway in Excel.

• Use Microsoft Copilot Studio to talk to your SAP Fieldglass 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 SAP Fieldglass for you.

• Working with SAP ByDesign Data in LINQPad

  Execute LINQ queries to SAP Business ByDesign in LINQPad.

• Connect to Float Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Float and work with Float in your FileMaker application.

• Analyze Sentry Data with Power Pivot

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

• Automate Apify Data Replication to Azure Synapse

  Use CData Sync to customize and automate Apify replication to Azure Synapse.

• Visualize Live AgileCRM Data of Power BI Report Builder in Power BI Service

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

• Getting Started with the CData Python Connector for Gorgias

  Learn to install and license the CData Python Connector

• Automated Continuous Google Campaign Manager 360 Replication to Oracle

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Oracle.

• How to import Qualaroo Data into Apache Solr

  Use the CData Software JDBC Driver for Qualaroo in Data Import Handler and create an automated import of Qualaroo to Apache Solr Enterprise Search platform.

• Access Live Qualaroo Data in AWS Lambda (with IntelliJ IDEA)

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

• How to integrate Metabase with Okta Data

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

• Use Manus AI to Talk to Your EnterpriseDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on EnterpriseDB.

• Connect to and Visualize Live ZeroBounce Data in Tableau Prep

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

• Work with Oracle SCM Data in FoxPro

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

• Model, Search, and Visualize Live Marketo Data in ThoughtSpot

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

• Access Live SendGrid 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 SendGrid through MCP integration.

• «
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• 376
• 377
• 378
• »