CData Software - Knowledge Base

Recent Articles

• «
• 216
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• 225
• »

• Connect to SQL Server in DBArtisan

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

• How to Connect the Power BI Service to Stripe: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Build an OLAP Cube in SSAS from Zendesk

  Establish a connection to Zendesk data from SQL Server Analysis Services, and use the Zendesk Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Continuous YouTube Analytics Replication to OneLake in Microsoft Fabric

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

• Connect to YouTube Analytics in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build Sybase IQ-Connected ETL Processes in Google Data Fusion

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

• How to connect SharePoint with REST through external lists

  Provide REST to SharePoint users as an external list.

• Create Marketo-Connected Applications in Appsmith

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

• Connect to SingleStore from Crystal Reports

  Use CData Connect AI to connect to and report on live SingleStore from Crystal Reports.

• Manage SAP HANA in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP HANA.

• Explore Geographical Relationships in LDAP Objects with Power Map

  Create data visualizations with LDAP in Power Map.

• Google Analytics Reporting and Star Schemas in OBIEE

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

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

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

• Build Agents in Relevance AI with Access to Live HCL Domino via CData Connect AI

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

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

• Connect to Dynamics 365 Business Central in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Dynamics 365 Business Central in the Denodo Virtual DataPort Administrator.

• Seamlessly Bring Dynamics 365 Business Central into Retool Using CData Connect AI

  Integrate Dynamics 365 Business Central data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Bind Live Paylocity Data in Wijmo FlexGrid with CData API Server

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

• Migrating data from MySQL to Databricks using CData SSIS Components.

  Easily push MySQL to Databricks using the CData SSIS Tasks for MySQL and Databricks.

• Use JayDeBeApi to access Oracle Eloqua in Python

  Use standard Python scripting and the development environment of your choice to access live Oracle Eloqua.

• Integrate with Avro using Apache Camel2

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

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

• Automated Continuous Printify Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Printify replication to Apache Cassandra.

• Analyze Impala in R via JDBC

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

• Operational Reporting on Lakebase from Spotfire Server

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

• Access Live LDAP Objects in AWS Lambda (with IntelliJ IDEA)

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

• Connecting Mastra with Act-On 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 Charts with ConstantContact in Clear Analytics

  Create dynamic charts and perform analytics based on ConstantContact in Clear Analytics.

• Seamlessly Bring Microsoft Teams into Retool Using CData Connect AI

  Integrate Microsoft Teams data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Splunk

  Provide connectivity to Splunk through an SAP BusinessObjects universe.

• Stream EventBrite into Apache Kafka Topics

  Access and stream Eventbrite in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Manage Snapchat Ads in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Snapchat Ads.

• Choosing the Best Method to Connect Excel Online to SQL Server: 5 Options Explained

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

• Automated Continuous SAP Ariba Procurement Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to IBM DB2.

• Use the CData API Server to Access Zoho Inventory in Microsoft PowerPivot

  Use the CData API Server to connect to live Zoho Inventory in the Power Pivot business intelligence tool.

• Analyze Google Campaign Manager 360 in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Google Campaign Manager 360 and visualize Google Campaign Manager 360 in SAP Analytics Cloud.

• Connect to and Query eBay Analytics in QlikView over ODBC

  Create data visualizations with eBay Analytics in QlikView.

• Bidirectional Access to QuickBooks Time from FileMaker Pro

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

• Create Apps from Google Calendar in Qlik Sense Cloud

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

• Connect to Redis in RapidMiner

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

• Rapidly Develop MariaDB-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• CData SAP Driver Deep Dive: Use SAP Gateway Service Builder for SAP S/4HANA and Set Up OData Service

  A guide for using the SAP Gateway Service Builder for SAP S/4 HANA and setting up an SAP OData Service

• Connect to Reckon in Google Apps Script via SQL Gateway

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

• Visualize Oracle Eloqua in Tableau

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

• Query SharePoint from Node.js

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

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

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

• Automated Continuous BigCommerce Replication to Local Delimited Files

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

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

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

• Create Cassandra-Connected Business Apps in AppSheet

  Connect to Cassandra via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Cassandra.

• How to load Amazon DynamoDB data into Elasticsearch via Logstash

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

• How to import Azure Data Lake Storage into Apache Solr

  Use the CData Software JDBC Driver for Azure Data Lake Storage in Data Import Handler and create an automated import of Azure Data Lake Storage to Apache Solr Enterprise Search platform.

• Natively Connect to eBay Analytics in PHP

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

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

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

• A PostgreSQL Interface for Amazon S3 using the CData ODBC Driver

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

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

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

• Visualize Live Microsoft Planner in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Planner into custom reports in Power BI.

• Access Live Greenplum in AWS Lambda

  Connect to live Pivotal GreenPlum in AWS Lambda using the CData JDBC Driver.

• Automated Continuous CData Connect AI Replication to SQL Server

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

• Import Real-Time Xero via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Xero Accounting in ColdFusion.

• Process & Analyze Elasticsearch in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Elasticsearch .

• Automate Avro Replication to Couchbase

  Use CData Sync to Customize and automate Apache Avro replication to Couchbase.

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

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

• Excel Spreadsheet Automation on Jira with the QUERY Formula

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

• How to Build an ETL App for Klipfolio in Python with CData

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

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

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

• Load REST to a Database Using Embulk

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Bing Ads to Power BI dashboards. Simply drag and drop Bing Ads into data visuals on the Power BI canvas.

• Migrating data from Excel Online to Databricks using CData SSIS Components.

  Easily push Microsoft Excel Online to Databricks using the CData SSIS Tasks for Excel Online and Databricks.

• Connect to YouTube Analytics in Ruby

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

• Getting Started with the CData JDBC Driver for Dynamics NAV

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics NAV.

• How to Create Power BI Visual Reports with Real-Time EnterpriseDB

  Use CData Power BI Connectors to visualize EnterpriseDB in Power BI.

• Create a Data Access Object for eBay using JDBI

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

• Build Data Flows from SQL Server to Acumatica through SSIS

  Easily push SQL Server data to Acumatica using the CData SSIS Tasks for Acumatica.

• Stream GraphQL into Apache Kafka Topics

  Access and stream GraphQL in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Import Real-Time Sybase via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Sybase in ColdFusion.

• Connect and Query Live Stripe Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Stripe into Databricks

• Integrate Invoiced in Your Informatica Cloud Instance

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

• How to publish and share Sage Cloud Accounting dashboards with Tableau Server

  The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Business Cloud Accounting into Tableau dashboards.

• Bidirectional Access to BambooHR from FileMaker Pro

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

• Replicate SAP Business One from PowerShell

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

• Build Clio-Connected ETL Processes in Google Data Fusion

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

• How to Query Live Spark in Claude Desktop

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

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

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

• Getting Started with the CData ODBC Driver for Coinbase

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

• Configure the CData JDBC Driver for SAP Ariba Source in a Connection Pool in Tomcat

  Connect to SAP Ariba Source from a connection pool in Tomcat.

• Build Automated Couchbase-Connected Workflows in Zapier

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

• Automated Continuous Spark Replication to IBM DB2

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

• Integrating Gumloop with Oracle SCM via CData Connect AI

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

• How to update ADP from Excel

  This article explains how to transfer data from Excel to ADP using the Excel Add-In for ADP.

• Automated Continuous SharePoint Replication to Snowflake

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

• Work with Kintone in FoxPro

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

• Consume SQL Analysis Services OData Feeds in PowerBuilder

  This article demonstrates how to consume SQL Analysis Services as OData feeds from PowerBuilder using the API Server.

• Analyze SAP HANA in R via JDBC

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

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

• Back Up LinkedIn Ads to SQL Server through SSIS

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

• Automated Continuous Power BI XMLA Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to IBM DB2.

• How to Create Power BI Visual Reports with Real-Time Dynamics CRM

  Use CData Power BI Connectors to visualize Microsoft Dynamics CRM in Power BI.

• How to Connect to Live Sage 200 from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Sage 200 for you.

• Access Live QuickBooks Online in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to QuickBooks Online from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Viewing Shippo in RAD Studio Data Explorer

  How to view Shippo in RAD Studio Data Explorer using the CData ODBC Driver for Shippo.

• «
• 216
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• 225
• »