CData Software - Knowledge Base

Recent Articles

---

• «
• 592
• 593
• 594
• 595
• 596
• 597
• 598
• 599
• 600
• 601
• »

• Connect to IBM Cloud Object Storage Data from a Connection Pool in Jetty

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

• Use Grok to Talk to Your Klaviyo 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 Klaviyo for you.

• Use the CData Software JDBC Driver for MongoDB in MicroStrategy

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

• Getting Started with the CData Tableau Connector for Kintone

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Kintone.

• Excel Spreadsheet Automation on SuiteCRM Data with the QUERY Formula

  Pull data from SuiteCRM, automate spreadsheets, and more with the QUERY formula.

• How to Query Live Stripe Data in Claude Desktop

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

• Build MVC Applications with Connectivity to Wrike Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Wrike from an ASP.NET MVC application.

• DataBind Excel Online Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Excel Online with the DevExpress Windows Forms and Web controls to provide Microsoft Excel Online to a chart.

• Query Confluence Data through ODBC in Node.js

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

• Work with Live Microsoft Planner Data in Power Query

  Use CData Connect AI to connect to Microsoft Planner and work with live Microsoft Planner in Microsoft Power Query.

• How to Connect to Live Gong Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Gong securely in real time.

• Integrate Goose with Live Salesforce CRM Analytics Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce CRM Analytics from within the local AI agent.

• Connect to Pipedrive Data in Ruby

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

• Connect to Act-On Data in RapidMiner

  Integrate Act-On with standard components and data source configuration wizards in RapidMiner Studio.

• DataBind Deel Data to the DevExpress Data Grid

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

• Build Dashboards with Reckon Data in DBxtra

  Create dynamic dashboards and perform analytics based on Reckon in DBxtra.

• Access Spotify Data as a Remote Oracle Database

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

• Build Data Flows from Flowlu to SQL Server using SSIS

  Easily back up Flowlu to SQL Server using the SSIS components for Flowlu.

• Use CData Connect AI to Access HubSpot Data in Microsoft Power Pivot

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

• Integrate Live Adobe Experience Manager Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Adobe Experience Manager to Blue Prism using the CData ODBC Driver for Adobe Experience Manager to create automated workflows for repetitive business tasks.

• Create Reports from FreshBooks Data in Looker Studio

  Use CData Connect AI to gain access to live FreshBooks and create custom reports in Looker Studio.

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

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

• Visualize Amplitude Data in Tableau

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

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

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

• Replicate Multiple Zendesk Accounts

  Replicate multiple Zendesk accounts to one or many databases.

• Analyze Highrise Data with Power Pivot

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

• Build HBase-Connected ETL Processes in Google Data Fusion

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate SAP Ariba Source actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Replicate Zuora Data to Multiple Databases

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

• Integrate Amazon Athena Data in Pentaho Data Integration

  Build ETL pipelines based on Amazon Athena in the Pentaho Data Integration tool.

• Connect to Monday.com Data from PowerBuilder via JDBC

  This article demonstrates how to access Monday.com from PowerBuilder using the Monday.com JDBC Driver.

• Use Manus AI to Talk to Your MariaDB 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 MariaDB.

• Integrate Real-Time Access to Confluence in SAPUI5 MVC Apps

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

• Build Dashboards with CloudConvert Data in DBxtra

  Create dynamic dashboards and perform analytics based on CloudConvert in DBxtra.

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

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

• Automated Continuous Smartsheet Replication to Vertica

  Use CData Sync for automated, continuous, customizable Smartsheet replication to Vertica.

• DataBind Charts to PDFMonkey Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to PDFMonkey from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• How to Query EmailOctopus Data in MySQL Workbench

  Execute MySQL queries against live EmailOctopus from MySQL Workbench.

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

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

• Build Dashboards with Testmonitor Data in Dundas BI

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

• Use CData Connect AI to Access SQL Analysis Services Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live SQL Analysis Services in the Power Pivot business intelligence tool.

• How to Connect Flowise AI Agents to Live Marketo 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 Marketo without replication.

• Visualize SendInBlue Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SendInBlue into TIBCO Spotfire.

• How to Query Typeform Data in MySQL Workbench

  Execute MySQL queries against live Typeform from MySQL Workbench.

• Integrate Google Translate with External Services using SnapLogic

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

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

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

• Design BIRT Reports on Lakebase Data

  Provide current Lakebase to your embedded analytics.

• Enable the Presto JDBC Driver in KNIME

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

• How to connect PolyBase to Jira

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

• How to Connect to Live Workday Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Workday without replication.

• Design BIRT Reports on Zoom Data

  Provide current Zoom to your embedded analytics.

• Automated Continuous Sage Cloud Accounting Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SQL Server.

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

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

• Query Avalara AvaTax Data in ColdFusion

  Write standard ColdFusion data access code to connect to Avalara AvaTax.

• Load Mistral AI Data to a Database Using Embulk

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

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

  Use CData Connect AI to gain access to live Apache HBase from your Excel spreadsheets.

• Unbounce Reporting in OBIEE with the Unbounce JDBC Driver

  Deploy the Unbounce JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

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

• Connect to Instagram Data in Ruby

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

• Analyze SAS xpt Data in Looker

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

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

  Execute MySQL queries against Stripe from Node.js.

• Integrate Bitly Data in Pentaho Data Integration

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

• Build SAP SuccessFactors LMS-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for SAP SuccessFactors LMS Data and create custom apps in Bubble.

• Connect to Greenplum in SpagoBI

  Create reports featuring live Pivotal GreenPlum in SpagoBI Studio. Host Greenplum reports on SpagoBI Server.

• How to connect to Sybase IQ Data from Spring Boot

  Connect to Sybase IQ in a Spring Boot Application using the CData JDBC Driver for Sybase IQ

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

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

• Automated Continuous XML Replication to Amazon Redshift

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

• How to connect and process Apollo from Azure Databricks

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

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

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

• How to create SAP SuccessFactors LMS federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP SuccessFactors LMS in MySQL .

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

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

• Access OData Services from MySQL in HeidiSQL

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

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

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

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

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

• Integrate Zoho Creator Data in Pentaho Data Integration

  Build ETL pipelines based on Zoho Creator in the Pentaho Data Integration tool.

• Integrate Live Epicor Kinetic Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Epicor Kinetic and integrate live Epicor Kinetic into apps built in Microsoft Power Apps.

• Integrate with Dotmailer Data in JReport Designer

  Create charts and reports based on Dotmailer in JReport Designer.

• How to Access Live Access Data in Visual Studio Code via Cline

  Run CData MCP Server for Access on Windows Subsytem for Linux (WSL) and connect to live Microsoft Access from the Cline extension in Visual Studio Code.

• Automated Continuous Parquet Replication to AlloyDB

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

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

  Use CData Power BI Connectors to visualize Adobe Analytics in Power BI.

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

  Connect to ActiveCampaign from a connection pool in Tomcat.

• Build Visualizations of Hacker News Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Hacker News in Birst.

• Connect to Live Greenplum Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Greenplum in CData Connect AI and connect to your Pivotal GreenPlum from PostgreSQL.

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

• How to Connect DBeaver to Vercel via a JDBC Driver

  Manage Vercel with visual tools in DBeaver like the query browser.

• Automated Continuous DB2 for i Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable DB2 for i replication to Amazon Redshift.

• Connect to TigerGraph in SpagoBI

  Create reports featuring live TigerGraph in SpagoBI Studio. Host TigerGraph reports on SpagoBI Server.

• Connect to and Visualize Live ZohoPeople Data in Tableau Prep

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

• Integrating Claude Code CLI with BigCommerce 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.

• How to Connect to Freshservice Data in Using Python: 6 Steps

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

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

  Execute SQL Server queries against Klaviyo from Node.js.

• Automated Continuous Grafana Replication to Vertica

  Use CData Sync for automated, continuous, customizable Grafana replication to Vertica.

• Integrating Claude Code with Avro Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Apache Avro within assisted coding and automated development workflows.

• Integrate SAP Ariba Source with JetBrains RubyMine using CData JDBC Drivers

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

• Validate Xero Data with QuerySurge

  Access and validate Xero Accounting in QuerySurge using the CData JDBC Driver.

• Replicate Multiple YouTube Analytics Accounts via the CData Sync CLI

  Replicate multiple YouTube Analytics accounts to one or many databases.

• Automated Continuous Klipfolio Replication to IBM DB2

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

• Create Smartsheet-Connected Dashboards in Grafana

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

• Build Klaviyo-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Klaviyo to explore live Klaviyo Data in Claude Code to assist with building Klaviyo-powered applications.

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

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

• «
• 592
• 593
• 594
• 595
• 596
• 597
• 598
• 599
• 600
• 601
• »