CData Software - Knowledge Base

Recent Articles

---

• «
• 811
• 812
• 813
• 814
• 815
• 816
• 817
• 818
• 819
• 820
• »

• Integrate with Gumroad Data using Apache Camel2

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

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

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

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

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

• Connecting Mastra with Highrise Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Highrise CRM, no replication required.

• LINQ to Figshare Data

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Figshare Data Provider.

• Connect to Optimizely Data in CloverDX (formerly CloverETL)

  Transfer Optimizely using the visual workflow in the CloverDX data integration tool.

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

  Execute MySQL queries against Procore from Node.js.

• Build TigerGraph-Connected ETL Processes in Google Data Fusion

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

• Publish Reports with Zoho Recruit Data in SAP Crystal Reports

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

• DataBind Controls to Aircall Data in C++Builder

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

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

  Connect to Apache Spark SQL in MicroStrategy Web using the CData Software ODBC Driver for Spark.

• Choosing the Best Method to Connect IBM Informix to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use IBM Informix from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Build Data Flows from ShipEngine to SQL Server using SSIS

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

• Rapidly Develop Teamwork-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 Teamwork.

• Object-Relational Mapping (ORM) with Billsby Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Billsby into a Java-based ORM framework, Hibernate.

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

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

• Analyze ElevenLabs Data in R via ODBC

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

• Build Dashboards with AlloyDB Data in Dundas BI

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

• DataBind Charts to Mailjet Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mailjet 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 OpenCode Terminal with MariaDB 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.

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

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

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

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

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

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CSV/TSV Files in real time.

• Build Clari-Connected ETL Processes in Google Data Fusion

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

• Easily Integrate Microsoft Teams Data in Lazarus Pascal IDE

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

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

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

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

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

• Build Semantic Layer Views for Office 365 Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Office 365.

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

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

• Build AI/ML Models with Live Sendwithus Data using Dataiku

  Connect Sendwithus Data with Dataiku using the CData API Driver for JDBC.

• Use Microsoft Copilot Studio to talk to your Vault CRM 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 Veeva Vault & Vault CRM for you.

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

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

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

  Execute MySQL queries against Mode from Node.js.

• DataBind Controls to SpaceX Data in C++Builder

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

• Create a Data Access Object for AdRoll Data using JDBI

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

• Import Bitbucket Data into Microsoft Power Query

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

• How to connect to Azure Synapse Data from IntelliJ

  Integrate connectivity to Azure Synapse with wizards in IntelliJ.

• How to Access Live Redis Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Redis enables you to integrate Redis into workflows built using Microsoft Power Automate Desktop.

• Getting Started with the CData Excel Add-In for Google Sheets

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

• Build MYOB AccountRight-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to MYOB AccountRight Data from Zoho Analytics and import live MYOB AccountRight.

• Creating Oracle Eloqua-Connected Applications in Unqork

  You can use CData Connect AI to feed Oracle Eloqua to Unqork and build custom business apps.

• Visualize Live EnterpriseDB Data in Tableau

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

• LINQ to Azure Data Lake Storage Data

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Azure Data Lake Storage Data Provider.

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

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

• Build BigQuery-Connected Apps in Bubble

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

• Use Biml to Build SSIS Tasks to Replicate Google Campaign Manager 360 Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Campaign Manager 360 to SQL Server.

• Access Everhour Data as a Remote Oracle Database

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

• Use Claude to Talk to Your Blackbaud FE NXT Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Blackbaud FE NXT for you.

• Automated Continuous Reckon Accounts Hosted Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to PostgreSQL.

• Establish a Live Connection with Aircall Data using Tableau Bridge

  The CData ODBC Driver for Aircall enables you to integrate live Aircall into Tableau Cloud dashboards using the Tableau Bridge.

• Automate Cvent Data Replication to SAP HANA

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

• Integrate SpaceX Data in Your Informatica Cloud Instance

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

• ETL Oracle in Oracle Data Integrator

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

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

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

• Provide OData Services of Hugging Face Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Hugging Face by developing a WCF Service Application.

• How to Seamlessly Import Excel Data into IBM SPSS Modeler

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

• Automated Continuous MongoDB Replication to Databricks

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

• Replicate Multiple Epicor Kinetic Accounts via the CData Sync CLI

  Replicate multiple Epicor Kinetic accounts to one or many databases.

• Publish Reports with Sendwithus Data in SAP Crystal Reports

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

• Easily Integrate Freshteam Data in Lazarus Pascal IDE

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

• Connect to Live Facebook Data in MicroStrategy through CData Connect AI

  Create a live connection to Facebook Data in CData Connect AI and connect to your Facebook from MicroStrategy.

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

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

• Visualize Sugar CRM Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Sugar CRM.

• Integrating LlamaIndex with Epicor Kinetic Data via CData Connect AI

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

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

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

• Access ClickUp Data from MySQL in PHP

  Connect to ClickUp through the standard MySQL libraries in PHP.

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

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

• Import Google Contacts Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Google Contacts Data and provide access to live Google Contacts for custom reports in the Power BI Service.

• Connect to Adobe Analytics Data from Filemaker Pro (Mac)

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

• Create OnePageCrm Reports on JasperReports Server

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

• Bridge Paymo Connectivity with Apache NiFi

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

• Integrate Live MYOB AccountRight Data into Amazon SageMaker Canvas with RDS

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

• How to Connect to & Open HDFS Data in Microsoft Excel

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

• Connect to SQL Server Data in DBArtisan

  Use wizards in DBArtisan to configure Microsoft SQL Server as a data source.

• Access PolarTeamPro Data as a Remote Oracle Database

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

• Integrate Google

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

• Connect to Tanda Data as an External Source in Dremio

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

• Build Airtable-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Airtable.

• Automate Salesforce Marketing Data Replication to Couchbase

  Use CData Sync to Customize and automate Salesforce Marketing Cloud replication to Couchbase.

• Connect to Mailgun from Asprova with CData Software ODBC Driver for Mailgun

  This article shows how to connect faster to Mailgun data from Asprova.

• Easily Integrate Tavily Data in Lazarus Pascal IDE

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

• Build Dashboards with ZohoPeople Data in Dundas BI

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

• How to Query Live Google Sheets Data in Claude Desktop

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

• DataBind Controls to LinkedIn Data in Delphi

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

• Integrate Splunk Data into Automated Tasks with Power Automate

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

• Use JayDeBeApi to access Tally Data in Python

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

• Excel Spreadsheet Automation on Zoho CRM Data with the QUERY Formula

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

• Integrate Live SingleStore Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Access Live eBay Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live eBay from your Google Sheets.

• Automated Continuous SAS xpt Replication to AlloyDB

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

• Automated Continuous Square Replication to Snowflake

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

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

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

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

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

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

• How to Easily Query Greenplum Data in OpenOffice Base

  Connect to Greenplum data in OpenOffice Base using the CData ODBC Driver for Greenplum and generate reports with live data insights.

• Connect to AfterShip Data in RazorSQL

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

• Integrate Bullhorn CRM Data into Automated Tasks with Power Automate

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

• Integrate EmailOctopus Data in Your Informatica Cloud Instance

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

• Automated Continuous ConvertKit Replication to AlloyDB

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

• Build SAP SuccessFactors-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for SAP SuccessFactors to explore live SAP SuccessFactors Data in GitHub Copilot to assist with building SAP SuccessFactors-powered applications.

• «
• 811
• 812
• 813
• 814
• 815
• 816
• 817
• 818
• 819
• 820
• »