CData Software - Knowledge Base

Recent Articles

• «
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• »

• Operational Reporting on Klaviyo from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Klaviyo.

• Replicate Oracle Sales to Multiple Databases via the CData Sync CLI

  Replicate Oracle Sales to disparate databases with a single configuration.

• Explore Geographical Relationships in Monday.com with Power Map

  Create data visualizations with Monday.com in Power Map.

• Integrate Google

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

• Build Blackbaud FE NXT-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Blackbaud FE NXT and build web apps with connectivity to live Blackbaud FE NXT.

• Automated Continuous Paylocity Replication to MySQL

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

• Access Live Act-On in AWS Lambda (with IntelliJ IDEA)

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

• Analyze Workday in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Workday and visualize live Workday in Infragistics Reveal.

• How to Connect to Live SAP Business One 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 SAP Business One through natural language.

• Feed Sage Cloud Accounting into FineReport

  How to set Sage Business Cloud Accounting as a JDBC data source in FineReport.

• How to Design Smartsheet Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Create Apps from Oracle Sales in Qlik Sense Cloud

  Use CData Connect AI to connect to Oracle Sales and build apps from live Oracle Sales in Qlik Sense Cloud.

• A PostgreSQL Interface for Vault CRM (MySQL Remoting via JDBC)

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

• Analyze Azure Analysis Services in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Azure Analysis Services with the CData JDBC Driver for Azure Analysis Services.

• Use Biml to Build SSIS Tasks to Replicate Quickbase to SQL Server

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

• How to Connect to Live MailChimp 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 MailChimp through natural language.

• A PostgreSQL Interface for SAP SuccessFactors (MySQL Remoting via JDBC)

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

• Start with CData Sync Part 3: Creating a Transformation Job

  Use CData Sync to create a transformation job to manipulate your data.

• Publish Reports with Twitter Ads in SAP Crystal Reports

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

• Integrate Google

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

• Object-Relational Mapping (ORM) with IBM Cloud Object Storage 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 IBM Cloud Object Storage into a Java-based ORM framework, Hibernate.

• Visualize Dynamics 365 Business Central in Tableau

  The CData ODBC driver for Dynamics 365 Business Central enables you integrate Dynamics 365 Business Central into Tableau dashboards.

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

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

• DataBind Charts to Teradata

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

• Add Blackbaud FE NXT to Informatica Enterprise Data Catalog

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

• Connect to BigCommerce in Airbyte ELT Pipelines

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

• How to Import Data from JSON into Google Sheets

  Import JSON into a Google spreadsheet that is automatically refreshed.

• Create SSAS Tabular Models from Avalara AvaTax

  How to build a SQL Server Analysis Service Tabular Model from Avalara AvaTax using CData drivers.

• Create Oracle Service Cloud-Connected Nintex Workflows

  Use CData Connect AI to connect to Oracle Service Cloud from Nintex Workflow Cloud and build custom workflows using live Oracle Service Cloud.

• Create Spark-Connected Applications in Appsmith

  Connect to Spark via CData Connect AI in Appsmith and create custom business applications with real-time access to Apache Spark SQL.

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

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

• Automate SurveyMonkey Replication to SAP HANA

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

• Access DB2 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 IBM DB2.

• Edit and Search External Outreach.io Objects in Salesforce Connect

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

• Connecting GenSpark with Redis via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.

• Connecting Mastra with Bullhorn CRM 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 data across 300+ enterprise sources no replication required.

• Build MongoDB-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live MongoDB and build MongoDB-connected web apps with Axios.

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

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

• Getting Started with the CData ODBC Driver for Salesforce Pardot

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

• How to Seamlessly Import Zuora Data into IBM SPSS Modeler

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

• Build Paylocity Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Paylocity and build visualizations in Tableau Cloud.

• Natively Connect to Cvent in PHP

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

• Automated Continuous SharePoint Excel Services Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to OneLake in Microsoft Fabric.

• Integrating LangGraph with Microsoft Planner via CData Connect AI

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

• Integrate with Act CRM using Apache Camel2

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

• Back Up Google Search to SQL Server through SSIS

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

• Integrate Access with External Services using SnapLogic

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

• Create Greenhouse Reports on JasperReports Server

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

• Build Agents in Relevance AI with Access to Live SAP Ariba Source via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Ariba Source within intelligent agent workflows.

• Use the CData Software ODBC Driver for IBM Cloud Object Storage in SAS for Real-Time Reporting and Analytics

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

• Create Reports from Elasticsearch in Looker Studio

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

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

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

• Bridge Drift Connectivity with Apache NiFi

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

• Connect to ClickUp in Google Apps Script via SQL Gateway

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

• DataBind Charts to Dynamics 365

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

• Easily Integrate Microsoft Project in Lazarus Pascal IDE

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

• Replicate QuickBooks Online in Heroku for Use in Salesforce Connect

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

• Automated Continuous MongoDB Replication to Amazon S3

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

• How to Access Live Sugar CRM in Power Automate Desktop via ODBC

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

• Connect to Google Analytics from PowerBuilder via ODBC

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

• Integrate with Live Instagram in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Instagram from the MuleSoft Anypoint Platform to integrate live Instagram into custom reports and dashboards.

• How to Query Live Oracle Eloqua in Claude Desktop

  Connect to and query live Oracle Eloqua in Claude Desktop using the CData MCP Server.

• Integrating Boomi Agentstudio with OData Services via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to OData, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• How to connect to SQL Analysis Services from Spring Boot

  Connect to SQL Analysis Services in a Spring Boot Application using CData JDBC SQL Analysis Services Driver

• How to use SQLAlchemy ORM to access SAP BusinessObjects BI in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP BusinessObjects BI.

• Feed eBay Analytics into FineReport

  How to set eBay Analytics as a JDBC data source in FineReport.

• How to create an RPA flow for GitHub in UiPath Studio

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

• How to load Act-On data into Elasticsearch via Logstash

  Introducing a simple method to load Act-On data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to Connect DBeaver to Smartsheet via a JDBC Driver

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

• Automated Continuous Twilio Replication to Snowflake

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

• Analyze TaxJar in R via JDBC

  Use standard R functions and the development environment of your choice to analyze TaxJar with the CData JDBC Driver for TaxJar.

• Work with Live Oracle Eloqua in Power Query

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

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

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

• Automated Continuous Azure Active Directory Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Microsoft Access.

• Build QuickBooks Online-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live QuickBooks Online and build QuickBooks Online-connected web apps with Axios.

• Integrate with Act-On in JReport Designer

  Create charts and reports based on Act-On in JReport Designer.

• Automate FHIR Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access FHIR from PowerShell? This article demonstrates how to utilize the FHIR Cmdlets for tasks like connecting to FHIR, automating operations, downloading data, and more.

• Integrate Google Analytics with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Google Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Analytics.

• How to Connect DBeaver to DocuSign via a JDBC Driver

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

• Bridge Cvent Connectivity with Apache NiFi

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

• Connect to Shopify from a Connection Pool in Jetty

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

• Create Adobe Commerce-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Adobe Commerce from Klipfolio and build custom visualizations using live Adobe Commerce.

• Connect to Kintone in Ruby

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

• Create Datasets from Impala in Domo Workbench and Build Visualizations of Impala in Domo

  Use the CData Software ODBC Driver for Impala to create datasets from Apache Impala in Domo Workbench and then build visualizations in the Domo service.

• Connect to Act-On from AWS Glue

  Use CData Connect AI to gain access to live Act-On from your AWS Glue jobs.

• Automated Continuous Xero Replication to Oracle

  Use CData Sync for automated, continuous, customizable Xero replication to Oracle.

• Consume Google Ads OData Feeds in SAP Lumira

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

• Publish Crystal Reports on Access

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

• Explore Geographical Relationships in SAP Hybris C4C with Power Map

  Create data visualizations with SAP Hybris C4C in Power Map.

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

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

• Working with Square in LINQPad

  Execute LINQ queries to Square in LINQPad.

• Automated Continuous GraphQL Replication to MySQL

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

• Connect to XML in RapidMiner

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

• Integrating Gumloop with Elasticsearch via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Elasticsearch within automated workflows.

• Automated Continuous Wave Financial Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Wave Financial replication to Amazon S3.

• Access Amazon S3 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 Amazon S3.

• Build a PostgreSQL Interface for Workday using the CData JDBC Driver

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

• Working with ActiveCampaign in LINQPad

  Execute LINQ queries to ActiveCampaign in LINQPad.

• Access Azure DevOps from MySQL in PHP

  Connect to Azure DevOps through the standard MySQL libraries in PHP.

• Create a Data Access Object for SAP Netweaver Gateway using JDBI

  A brief overview of creating a SQL Object API for SAP Netweaver Gateway in JDBI.

• «
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• »