CData Software - Knowledge Base

Recent Articles

---

• «
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• »

• Build Semantic Layer Views for Act CRM Data in APOS Live Data Gateway

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

• Query Sage 300 Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Sage 300 entities in PHP by modeling them as objects.

• How to connect SharePoint with Pipedrive Data through external lists

  Provide Pipedrive to SharePoint users as an external list.

• Automated Continuous Tickspot Replication to MySQL

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

• Connecting Mastra with Couchbase 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 Couchbase, no replication required.

• Getting Started with the CData JDBC Driver for JSON

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

• Access Sage Intacct Data 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 Sage Intacct.

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

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

• Connect to Workday Data in RazorSQL

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

• Access Live Airtable Data in Excel 365 Online (Excel for the web)

  Connect to Airtable from Excel 365 Online (Excel for the web) with CData Connect AI.

• Query NASA Data through ODBC in Node.js

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

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

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

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

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

• Automated Continuous Dynamics 365 Replication to Amazon S3

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

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

• Integrate Basecamp Data into Automated Tasks with Power Automate

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

• How to publish and share BenchmarkEmail Data dashboards with Tableau Server

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

• Connect to Gmail Data in RapidMiner

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

• How to connect PolyBase to Clari

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clari.

• Access Live Ontraport Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Ontraport into the statistical analysis tools available in SAS JMP. This article shows how to use Ontraport in the Graph Builder and Query Builder.

• Automate Tally Data Replication to Couchbase

  Use CData Sync to Customize and automate Tally ERP replication to Couchbase.

• Operational Reporting on Opsgenie Data from Spotfire Server

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

• Automated Continuous BenchmarkEmail Replication to IBM DB2

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

• Connect ScrapingBee to IBM WebSphere Using the CData JDBC Driver

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

• Consume Databricks OData Feeds in PowerBuilder

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

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

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

• Automated Continuous Azure Synapse Replication to Local Delimited Files

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

• Using the CData Software ODBC Driver for Jodoo in PyCharm

  Connect to Jodoo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jodoo.

• Connect to Zoho Recruit Data in JRuby

  Create a simple JRuby app with access to live Zoho Recruit.

• Query Pinterest Data through ODBC in Node.js

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

• Automate FormSite Integration Tasks from PowerShell

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

• Bidirectional Access to ZohoMarketingHub Data from FileMaker Pro

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

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

  Connect to Pivotal GreenPlum from a connection pool in Tomcat.

• Automate Dynamics NAV Data Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Dynamics NAV replication to Couchbase.

• Create WooCommerce-Connected Nintex Workflows

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

• How to Access JobNimbus Data Using Entity Framework

  This article shows how to access JobNimbus using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Natively Connect to Smartsheet Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Smartsheet. Leverage the native support for ODBC in PHP.

• Connect to QuickBooks Online from Asprova with CData Software ODBC Driver for QuickBooks Online

  This article shows how to connect faster to QuickBooks Online data from Asprova.

• Connect to SAP Business One Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for SAP Business One in Airbyte.

• Create OneNote-Connected Business Apps in AppSheet

  Connect to OneNote Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft OneNote.

• How to Connect to Live Procore Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Procore for you.

• Access Live SAP Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SAP data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Use Dash to Build to Web Apps on Redshift Data

  Create Python applications that use pandas and Dash to build Redshift-connected web apps.

• Connect to Live SAP Netweaver Gateway Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to SAP Netweaver Gateway in CData Connect AI and connect to your SAP Netweaver Gateway from PostgreSQL.

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

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

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

• Create Power BI Reports on Real-Time ScrapingBee Data

  Use the CData ODBC Driver for ScrapingBee to visualize ScrapingBee in Power BI Desktop.

• Connect to BigQuery Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for BigQuery Data and connect to Google BigQuery in Akorbi Digital RunMyProcess.

• How to Connect SAP ByDesign Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP ByDesign data in real time using natural language.

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

  Create a simple Workflow for Clari in Informatica PowerCenter.

• Create a Data Access Object for MarkLogic Data using JDBI

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

• How to Connect Basecamp Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Basecamp data in real time using natural language.

• Automate NetSuite SuiteAnalytics Data Replication to SAP HANA

  Use CData Sync to customize and automate NetSuite SuiteAnalytics replication to SAP HANA.

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

• Load Snowflake Data to a Database Using Embulk

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

• Automate Teradata Data Replication to Azure Data Lake

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

• Publish AdRoll-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live AdRoll.

• Back Up Airtable to SQL Server through SSIS

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

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

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

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

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

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

• Create SAP Ariba Source-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to SAP Ariba Source Data from Klipfolio and build custom visualizations using live SAP Ariba Source.

• Integrate ZohoInvoice Data in Your Informatica Cloud Instance

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

• Build eBay Analytics-Connected ETL Processes in Google Data Fusion

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

• How to load Google Calendar data into Elasticsearch via Logstash

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

• How to connect to Cohere Data with Squirrel SQL client

  Connect to Cohere and execute queries in the Squirrel SQL Client.

• Connect to Bannerbear Data in DBArtisan

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

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

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

• Connect to DB2 Data in JRuby

  Create a simple JRuby app with access to live IBM DB2.

• Connect to Perigon Data in CloverDX (formerly CloverETL)

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

• Connect to Gong Data in RazorSQL

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

• How to Connect to Bugsnag Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Bugsnag. Leverage the pyodbc module for ODBC in Python.

• How to Connect DBeaver to NASA via a JDBC Driver

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

• Getting Started with the CData ADO.NET Provider for Greenhouse

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Greenhouse.

• Integrate with RSS Feeds using Apache Camel2

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

• How to integrate Metabase with Greenplum Data

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

• How to Seamlessly Import Sage 300 Data into IBM SPSS Modeler

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

• Getting Started with the CData ADO.NET Provider for MarkLogic

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MarkLogic.

• Build Semantic Layer Views for Exact Online Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

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

  Provide connectivity to Ontraport through an SAP BusinessObjects universe.

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

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

• Integrate Mailjet with JetBrains RubyMine using CData JDBC Drivers

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

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

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

• Replicate WooCommerce Data to Multiple Databases via the CData Sync CLI

  Replicate WooCommerce to disparate databases with a single configuration.

• Connect to SageHR Data from PowerBuilder via ADO.NET

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

• Analyze Live Procore Data in SAS Viya

  Use CData Connect AI to connect to Procore from SAS Viya and deploy self-service analytics using live Procore.

• How to connect PolyBase to Reply.io

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reply.io.

• Import eBay Data into Microsoft Power Query

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

• Manage MarkLogic Data in DBArtisan as a JDBC Source

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

• How to Connect to Live Snapchat Ads Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Snapchat Ads for you.

• How to use SQLAlchemy ORM to access Azure Table Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Table Storage.

• Visualize Live Apify Data in Tableau

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

• Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy Web

  Connect to SQL Analysis Services in MicroStrategy Web using the CData Software ODBC Driver for SQL Analysis Services.

• Publish Reports with Zoom Data in SAP Crystal Reports

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

• Integrate Missive Data in Your Informatica Cloud Instance

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

• Connect to Strava Data in Google Apps Script via SQL Gateway

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

• Automate Adobe Commerce Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Adobe Commerce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

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

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

• Manage Planio Data in DBArtisan as a JDBC Source

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

• Automated Continuous Perplexity Data Replication to OneLake in Microsoft Fabric

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

• «
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• »