CData Software - Knowledge Base

Recent Articles

---

• «
• 779
• 780
• 781
• 782
• 783
• 784
• 785
• 786
• 787
• 788
• »

• Add Delighted Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Delighted with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to Oracle Eloqua Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua to connect to Oracle Eloqua and execute queries in PowerBuilder.

• Create Supabase Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Supabase data access from reports, embedded analytics, and more.

• Rapidly Develop Google Sheets-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Google Sheets.

• Query Smartsheet Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Smartsheet and perform CRUD operations on Smartsheet from Node.js.

• Import and Visualize Pipeline CRM Data in Power View

  Create data visualizations based on Pipeline CRM in Excel.

• Integrate SuiteCRM Data in Pentaho Data Integration

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

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

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

• Build Automated Acumatica-Connected Workflows in Zapier

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

• Connect Adobe Target to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Adobe Target with IBM WebSphere for seamless data integration and connectivity.

• Okta Reporting and Star Schemas in OBIEE

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

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

• How to Connect to & Open Epicor Kinetic Data in Microsoft Excel

  This article uses the CData ODBC driver for Epicor Kinetic to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Analyze Brex Data in R via ODBC

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

• Migrating data from Pingdom to Snowflake using CData SSIS Components.

  Easily push Pingdom to Snowflake using the CData SSIS Tasks for Pingdom and Snowflake.

• Integrate Live Salesforce Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Salesforce & Force.com and integrate live Salesforce & Force.com into apps built in Microsoft Power Apps.

• View Reports on Real-Time Bitbucket Data in Power BI Report Server

  Use the CData ODBC Driver for Bitbucket to visualize Bitbucket in Power BI Desktop and then publish them to Power BI Report Server.

• Use the CData Software ODBC Driver for Pushbullet in MicroStrategy Web

  Connect to Pushbullet in MicroStrategy Web using the CData Software ODBC Driver for Pushbullet.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Confluence

  Provide connectivity to Atlassian Confluence through an SAP BusinessObjects universe.

• Access Live Act CRM Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Act CRM through MCP integration.

• Process & Analyze Sugar CRM Data in Databricks (AWS)

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

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

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

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

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

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

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

• Connect to SpaceX Data in RapidMiner

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

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

• Automate SparkPost Data Replication to SAP HANA

  Use CData Sync to customize and automate SparkPost replication to SAP HANA.

• Natively Connect to Redis Data in PHP

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

• Getting Started with the CData Power BI Connector for SAP Concur

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

• Analyze Klipfolio Data in R via ODBC

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

• Automate Freshservice Data Replication to Azure Data Lake

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

• Visualize Sybase IQ Data in TIBCO Spotfire through ADO.NET

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• Build Facebook Ads-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Facebook Ads to explore live Facebook Ads Data in Cursor to assist with building Facebook Ads-powered applications.

• Automated Continuous ChargeOver Replication to Vertica

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

• Use the CData Software JDBC Driver for Tickspot in MicroStrategy

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

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

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

• Connect to Perplexity Data in RapidMiner

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

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

  Execute MySQL queries against Simplesat from Node.js.

• View Reports on Real-Time Moosend Data in Power BI Report Server

  Use the CData ODBC Driver for Moosend to visualize Moosend in Power BI Desktop and then publish them to Power BI Report Server.

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

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

• DataBind Controls to Zoho Inventory Data in C++Builder

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

• Access Live SAP Ariba Source Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Ariba Source through MCP integration.

• Replicate Paylocity Data from PowerShell

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

• Integrate Live QuickBooks Online Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to QuickBooks Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live QuickBooks Online.

• How to create Kintone federated tables in MySQL

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

• Access Google Campaign Manager 360 Data from MySQL in PHP

  Connect to Google Campaign Manager 360 through the standard MySQL libraries in PHP.

• How to Work with JotForm Data in ETL Validator JDBC

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

• Create Data Visualizations in Cognos BI with Instantly Data

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

• Excel Spreadsheet Automation on Amazon Marketplace Data with the QUERY Formula

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

• Analyze Databricks Data with Power Pivot

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

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

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

• Natively Connect to Workday Data in PHP

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

• How to Build an ETL App for Amazon Athena Data in Python with CData

  Create ETL applications and real-time data pipelines for Amazon Athena in Python with petl.

• Connect to LinkedIn Data in Airbyte ELT Pipelines

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

• Analyze Zoho CRM Data in Looker

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

• DataBind Charts to QuickBooks Time Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Time 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.

• Integrating Kiro CLI with Shopify 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.

• Connecting Moonlit Workflow with Epicor Kinetic Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Epicor Kinetic in real time.

• Analyze Printify Data in R via ODBC

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

• How to Work with PayPal Data in AWS Glue Jobs Using JDBC

  Connect to PayPal from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to work with SAP ByDesign Data in Apache Spark using SQL

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

• Create Reports from Sugar CRM Data in Looker Studio

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

• Extend Google Sheets with Splunk Data

  Make calls to Splunk from Google Apps Script via the API Server.

• Connect to Salesforce Pardot Data in Ruby

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

• Import and Visualize EnterpriseDB Data in Power View

  Create data visualizations based on EnterpriseDB in Excel.

• Publish Crystal Reports on Salesforce Pardot Data

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

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

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

• Automated Continuous Adobe Analytics Replication to Apache Kafka

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

• Access Live Amazon Athena Data in Coginiti Pro

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

• Use the CData Software JDBC Driver for Opsgenie in MicroStrategy

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

• Connect to ZohoInvoice Data in Jaspersoft Studio

  Execute SQL to remote ZohoInvoice in Jaspersoft Studio.

• Visualize Attio Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Attio.

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

  Create a simple Workflow for QuickBooks Desktop in Informatica PowerCenter.

• Connect to Smartsheet Data in Jaspersoft Studio

  Execute SQL to remote Smartsheet in Jaspersoft Studio.

• Automated Continuous Google Contacts Replication to SingleStore

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

• Visualize ADP Data in TIBCO Spotfire through OData

  Integrate ADP into dashboards in TIBCO Spotfire.

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

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

• Use the CData Software ODBC Driver for MessageBird in MicroStrategy

  Connect to MessageBird in MicroStrategy Developer using the CData Software ODBC Driver for MessageBird.

• How to Visualize Onfleet Data in Python with pandas

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

• Integrate Oracle Eloqua Data into Automated Tasks with Power Automate

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

• Connect to MySQL from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MySQL, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Publish Oracle Eloqua-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Oracle Eloqua.

• Access Live Act-On Data in Excel 365 Online (Excel for the web)

  Connect to Act-On from Excel 365 Online (Excel for the web) with CData Connect AI.

• Automated Continuous Yelp Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Yelp replication to Snowflake.

• Work with Miro Data in FoxPro

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

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

  Connect to Webflow from a connection pool in Tomcat.

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

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

• Integrating Codex CLI with BenchmarkEmail 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.

• DataBind Controls to Mouseflow Data in Delphi

  DataBind to Mouseflow in Delphi with standard data access components and controls.

• Connecting Pipedream with Cosmos DB Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Cosmos DB data in real time.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Databricks

  Provide connectivity to Databricks through an SAP BusinessObjects universe.

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

• Enable the Zoho Projects JDBC Driver in KNIME

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

• Analyze Salesforce Data in Cognos Analytics

  Use CData Connect AI to connect to Salesforce Data from Cognos Analytics and analyze live Salesforce & Force.com.

• Bind Live Oracle SCM Data in Wijmo FlexGrid with CData API Server

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

• Create a Data Access Object for Wave Financial Data using JDBI

  A brief overview of creating a SQL Object API for Wave Financial in JDBI.

• How to Connect to & Open SAS xpt Data in Microsoft Excel

  This article uses the CData ODBC driver for SAS xpt to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Building Dynamic Web Pages with Anaplan Data Using AngularJS

  Create single-page applications with live connectivity to Anaplan using the CData API Server.

• Migrating data from Amazon Athena to Snowflake using CData SSIS Components.

  Easily push Amazon Athena to Snowflake using the CData SSIS Tasks for Amazon Athena and Snowflake.

• Visualize Avro Data in TIBCO Spotfire through OData

  Integrate Apache Avro into dashboards in TIBCO Spotfire.

• «
• 779
• 780
• 781
• 782
• 783
• 784
• 785
• 786
• 787
• 788
• »