CData Software - Knowledge Base

Recent Articles

---

• «
• 784
• 785
• 786
• 787
• 788
• 789
• 790
• 791
• 792
• 793
• »

• Build Epicor Kinetic-Connected Apps in Choreo

  Use CData Connect AI to connect to Epicor Kinetic Data from Choreo and build custom apps using live Epicor Kinetic.

• Edit and Search Certinia External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Certinia to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Certinia objects that you can access from apps and the dashboard.

• Migrating data from Freshteam to Google BigQuery using CData SSIS Components.

  Easily push Freshteam to Google BigQuery using the CData SSIS Tasks for Freshteam and Google BigQuery.

• Connect to Productboard Data in Aqua Data Studio

  Access Productboard from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• How to integrate Metabase with SendGrid Data

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

• How to Query Drip Data in MySQL Workbench

  Execute MySQL queries against live Drip from MySQL Workbench.

• Integrating LangGraph with QuickBooks Online Data via CData Connect AI

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

• How to Use a Microsoft Access Database to Update SAS Data Sets Data in Real Time

  Update SAS Data Sets data by creating a linked table in Microsoft Access with the CData SAS Data Sets ODBC Driver.

• Automated Continuous Cassandra Replication to Local Delimited Files

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

• Migrating data from Oracle Eloqua to Google BigQuery using CData SSIS Components.

  Easily push Oracle Eloqua to Google BigQuery using the CData SSIS Tasks for Oracle Eloqua and Google BigQuery.

• Analyze Instagram Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Instagram and visualize live Instagram in Infragistics Reveal.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho Projects using the Model Context Protocol.

• Analyze Close Data in R via ODBC

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

• How to create an RPA flow for FormSite Data in UiPath Studio

  Use the FormSite ODBC Driver to create workflows that access real-time FormSite without any coding.

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

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

• Build AI Agents with Elasticsearch Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Elasticsearch through CData Connect AI.

• Automated Continuous Confluence Replication to SQL Server

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

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

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

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

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

• Visualize TaxJar 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 TaxJar into TIBCO Spotfire.

• Replicate Act-On Data from PowerShell

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

• Connect to Auth0 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 Auth0 and work with Auth0 in your FileMaker application.

• Connect to Exact Online in SpagoBI

  Create reports featuring live Exact Online in SpagoBI Studio. Host Exact Online reports on SpagoBI Server.

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

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

• Connect to Azure Analysis Services Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Azure Analysis Services from Crystal Reports.

• Build Automated Workday-Connected Workflows in Zapier

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

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

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

• Connect to Azure DevOps Data in RapidMiner

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

• Connect to Google Analytics Data in Aqua Data Studio

  Access Google Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Work with Reply.io Data in FoxPro

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

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

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

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

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

• Connect to SparkPost Data from Blazor Apps

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

• Bridge Clio Connectivity with Apache NiFi

  Access and process Clio in Apache NiFi using the CData JDBC Driver.

• Automated Continuous Wave Financial Replication to SQL Server

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

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

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

• Automated Continuous Exa Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Exa replication to PostgreSQL.

• Use the CData Software JDBC Driver for Sybase in MicroStrategy Desktop

  Connect to Sybase in MicroStrategy Desktop using the CData Software JDBC Driver for Sybase.

• Import Parquet Data into Microsoft Power Query

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

• Consume CSV OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on CSV feeds that reflect any changes in SAP Lumira.

• Process & Analyze Salesforce CRM Analytics Data in Databricks (AWS)

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

• How to integrate ZarMoney with Apache Airflow

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

• Automated Continuous Mode Replication to SingleStore

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

• Use the CData Software JDBC Driver for Google Analytics in MicroStrategy Desktop

  Connect to Google Analytics in MicroStrategy Desktop using the CData Software JDBC Driver for Google Analytics.

• Build Apps with Live Redis Data Using the Low-Code Development Platform of Mendix

  Connect Redis with Mendix to build apps using the CData JDBC Driver for Redis.

• Integrate with Webex Data using Apache Camel2

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

• Automated Continuous Mode Replication to Databricks

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

• Query SAP SuccessFactors Data as a MySQL Database in Node.js

  Execute MySQL queries against SAP SuccessFactors from Node.js.

• How to Connect to Live Greenplum Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Pivotal GreenPlum through natural language.

• Access JSON Services from MySQL in HeidiSQL

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

• Easily Integrate Certinia Data in Lazarus Pascal IDE

  Learn how to easily integrate live Certinia in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• How to Seamlessly Import Teamwork Data into IBM SPSS Modeler

  Integrate Teamwork data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Connect to ChartMogul Data from PowerBuilder via ADO.NET

  This article demonstrates how to access ChartMogul from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Connect Microsoft Entra ID to AI Assistants With the CData Python MCP Server

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

• Getting Started with the CData Excel Add-In for Dynamics NAV

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

• Oracle SCM Reporting and Star Schemas in OBIEE

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

• Visualize Live SAP BusinessObjects BI Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live SAP BusinessObjects BI.

• Analyze SharePoint Data in R via ODBC

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

• Back Up LDAP to SQL Server through SSIS

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

• Visualize Zendesk Data from Tableau

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

• Analyze SAP HANA Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of SAP HANA and visualize live SAP HANA in Infragistics Reveal.

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

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

• Automated Continuous Freshdesk Replication to MongoDB

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

• Use Biml to Build SSIS Tasks to Replicate Reply.io Data to SQL Server

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

• Connect to Chargebee Data in DBArtisan

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

• Analyze PivotalTracker Data with Power Pivot

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

• SendInBlue Reporting in OBIEE with the SendInBlue JDBC Driver

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

• Integrating Codex CLI with Microsoft Dynamics CRM 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.

• Replicate Toggl Data to Multiple Databases

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

• Easily Integrate PayPal Data in Lazarus Pascal IDE

  Learn how to easily integrate live PayPal in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Build Lakebase-Powered Applications in Cursor with CData MCP Server

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

• Integrate Microsoft Ads Data in the Pentaho Report Designer

  Publish reports based on Microsoft Ads in the Pentaho BI tool.

• Create Google Directory-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Google Directory Data from Klipfolio and build custom visualizations using live Google Directory.

• Connect to Redshift Data in CloverDX (formerly CloverETL)

  Transfer Amazon Redshift using the visual workflow in the CloverDX data integration tool.

• Natively Connect to ConvertKit Data in PHP

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

• Create Reports with Demio Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Demio.

• Connect to Klipfolio Data in RazorSQL

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

• Access Raisers Edge NXT Data from MySQL in PHP

  Connect to Raisers Edge NXT through the standard MySQL libraries in PHP.

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

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

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

  Provide connectivity to Workable through an SAP BusinessObjects universe.

• Model Amazon S3 Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon S3, enabling the direct import of real-time Amazon S3.

• Analyze DocuSign Data with Power Pivot

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

• Connect to Zoho Books Data as an External Source in Dremio

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

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

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

• Bidirectional Access to Redshift Data from FileMaker Pro

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

• Getting Started with the CData Tableau Connector for Microsoft Entra ID

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Entra ID.

• ETL Scrapfly in Oracle Data Integrator

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

• Bidirectional Access to Quaderno Data from FileMaker Pro

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

• Connect to Hubstaff Data from a Connection Pool in Jetty

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

• Create BigCommerce Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for BigCommerce from PowerBI.com to create Power BI Dataflows with real-time data.

• Connect to Chargebee 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 Chargebee and work with Chargebee in your FileMaker application.

• Automated Continuous LinkedIn Ads Replication to Snowflake

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

• Query ServiceNow Data through ODBC in Node.js

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

• Access Scrapfly Data from MySQL in PHP

  Connect to Scrapfly through the standard MySQL libraries in PHP.

• Analyze FreeAgent Data with Power Pivot

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

• Connect to Azure Synapse Data from Blazor Apps

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

• Connect to Slack Data from Filemaker Pro (Mac)

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

• Automated Continuous Adobe Target Replication to MySQL

  Use CData Sync for automated, continuous, customizable Adobe Target replication to MySQL.

• Automated Continuous Calendly Data Replication to OneLake in Microsoft Fabric

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

• Build Dashboards with Campaigner Data in DBxtra

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

• «
• 784
• 785
• 786
• 787
• 788
• 789
• 790
• 791
• 792
• 793
• »