CData Software - Knowledge Base

Recent Articles

---

• «
• 1012
• 1013
• 1014
• 1015
• 1016
• 1017
• 1018
• 1019
• 1020
• 1021
• »

• How to create PayPal federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for PayPal in MySQL .

• Query Apify Data in DataGrip

  Create a Data Source for Apify in DataGrip and use SQL to query live Apify.

• Automated Continuous Quickbase Replication to Vertica

  Use CData Sync for automated, continuous, customizable Quickbase replication to Vertica.

• How to connect SharePoint with Google Spanner Data through external lists

  Provide Google Spanner to SharePoint users as an external list.

• Access Live Front Data in Coginiti Pro

  Connect to and query live Front from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Visualize Grafana Data from Tableau

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

• How to import Perplexity Data into Apache Solr

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

• Integrate with NetSuite Data using Apache Camel2

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

• Connect to Aha! Data in HULFT Integrate

  Connect to Aha! as a JDBC data source in HULFT Integrate

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

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

• Connect to SAP Business Warehouse Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to SAP Business Warehouse as an External Source in Dremio.

• Back Up Jodoo to SQL Server through SSIS

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

• Extract, Transform, and Load Act CRM Data in Informatica PowerCenter

  Create a simple Workflow for Act CRM in Informatica PowerCenter.

• Automated Continuous Amazon S3 Replication to SQL Server

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

• Automated Continuous Parquet Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Parquet replication to Amazon Redshift.

• Connect to Google Contacts from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Contacts, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Visualize Live Outreach.io Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Outreach.io.

• Validate Paymo Data with QuerySurge

  Access and validate Paymo in QuerySurge using the CData JDBC Driver.

• Analyze FreeAgent Data in R via ODBC

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

• Access Live ConvertAPI Data in SAS JMP via ODBC

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

• Operational Reporting on Monday.com Data from Spotfire Server

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

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

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

• Configure the CData JDBC Driver for Reckon Accounts Hosted in a Connection Pool in Tomcat

  Connect to Reckon Accounts Hosted from a connection pool in Tomcat.

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

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

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

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

• Bidirectional Access to JSON Services from FileMaker Pro

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

• Build Google Sheets-Connected Apps in Choreo

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

• Automated Dynamics NAV Data Replication to Teradata

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

• Analyze Harvest Data in R via ODBC

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

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

• Access Live SuiteCRM Data in SAS JMP via ODBC

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

• Automated Continuous Active Directory Replication to IBM DB2

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

• Natively Connect to SAP ByDesign Data in PHP

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

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

  Connect to the CData Software Power BI Connector for Bitbucket from PowerBI.com to provide real-time Bitbucket across the organization.

• Build a Simple VCL Application for Tavily Data

  How to build a simple VCL Application to view Tavily in RAD Studio using the CData ODBC Driver for Tavily.

• How to integrate Google Forms with Apache Airflow

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

• Integrate Theia IDE with Live DB2 Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Integrating Gumloop with Google Campaign Manager 360 Data via CData Connect AI

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

• Build Dashboards with Pingdom Data in Dundas BI

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

• Integrating Claude Code with SQL Analysis Services Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on SQL Analysis Services within assisted coding and automated development workflows.

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

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

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

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

• Import FTP Data into Microsoft Power Query

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

• Enable the Bugsnag JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Bugsnag.

• Automated Continuous Airtable Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Airtable replication to Google Cloud SQL.

• Write a Simple Go Application to work with Azure Table Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Table Storage.

• Building Dynamic Web Pages with Salesforce Data Using AngularJS

  Create single-page applications with live connectivity to Salesforce using the CData API Server.

• Integrating OpenCode Terminal with PolarTeamPro 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.

• Automated Continuous Active Directory Replication to Apache Cassandra

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

• Connect to Google Spanner Data in RapidMiner

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

• Discovering SaaS, Big Data, and NoSQL Metadata with JDBC

  Use the CData JDBC Drivers to see the metadata for all of your SaaS, Big Data, RDBMS, and NoSQL data sources.

• Getting Started with the CData SSIS Components for WooCommerce

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for WooCommerce.

• Automated Continuous SAP ByDesign Replication to Databricks

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

• Getting Started with the CData Tableau Connector for HubSpot

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HubSpot.

• Build Dashboards with Zoom Data in DBxtra

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

• Integrate Live Active Directory Data into Amazon SageMaker Canvas with RDS

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

• Connect to Contentful Data in Ruby

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

• Connect to Certinia Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Certinia in Google Apps Script.

• Work with Mistral AI Data in FoxPro

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

• Integrating OpenCode Terminal with Gumroad 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.

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

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

• Access ClickTime Data as a Remote Oracle Database

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

• How to connect to MailerLite Data in DBVisualizer

  Integrate MailerLite with visual data analysis tools and data connection wizards in DBVisualizer

• Automate Salesforce CRM Analytics Tasks in Power Automate Using CData API Server

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

• Analyze Azure Analysis Services Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Azure Analysis Services and visualize Azure Analysis Services in SAP Analytics Cloud.

• Integrating Antigravity CLI with Coinbase via CData CLI

  Connect Coinbase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Connect to Act-On Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Act-On.

• Integrating GitHub Copilot CLI with Beeminder 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.

• Build Dashboards with Zoho Recruit Data in Dundas BI

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

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

  Connect live Veeva Vault & Vault CRM to Blue Prism using the CData ODBC Driver for Vault CRM to create automated workflows for repetitive business tasks.

• Connect to Sage 300 Data in CloverDX (formerly CloverETL)

  Transfer Sage 300 using the visual workflow in the CloverDX data integration tool.

• How to Connect to Zoho Creator Data in Using Python: 6 Steps

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

• How to Work with Azure Data Lake Storage Data in ETL Validator JDBC

  Connect to Azure Data Lake Storage from ETL Validator jobs using the CData Software JDBC Driver.

• Use Databricks Agent Bricks to Talk to Your Instagram Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Instagram for you.

• Build Teradata-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Teradata to explore live Teradata Data in Claude Code to assist with building Teradata-powered applications.

• Build a Singer.io Tap for Perplexity With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Perplexity data using

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

• Build a Simple VCL Application for SQL Server Data

  How to build a simple VCL Application to view Microsoft SQL Server in RAD Studio using the CData ODBC Driver for SQL Server.

• Use the CData Software JDBC Driver for Quickbase in MicroStrategy

  Connect to Quickbase in MicroStrategy Developer using the CData Software JDBC Driver for Quickbase.

• Explore Geographical Relationships in Slack Data with Power Map

  Create data visualizations with Slack in Power Map.

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

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

• Connect to Elasticsearch Data as an External Source in Dremio

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

• Getting Started with the CData Power BI Connector for SAS Data Sets

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAS Data Sets.

• Connect to Oracle Sales Data in Jaspersoft Studio

  Execute SQL to remote Oracle Sales in Jaspersoft Studio.

• Automated Continuous LinkedIn Ads Replication to Databricks

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

• Connect Blackbaud FE NXT to IBM WebSphere Using the CData JDBC Driver

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

• Use the CData Software ODBC Driver for Pinterest in MicroStrategy

  Connect to Pinterest in MicroStrategy Developer using the CData Software ODBC Driver for Pinterest.

• Manage Oracle SCM Data in DBArtisan as a JDBC Source

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

• Integrate Nuclia Data in Pentaho Data Integration

  Build ETL pipelines based on Nuclia in the Pentaho Data Integration tool.

• Replicate Multiple Humanity Accounts via the CData Sync CLI

  Replicate multiple Humanity accounts to one or many databases.

• Use the CData API Server in Microsoft Power BI

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

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

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

• Access Live Elorus Data in Coginiti Pro

  Connect to and query live Elorus from the GUI in the Coginiti Pro: SQL Analytics Tool.

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

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

• DataBind Controls to iContact Data in Delphi

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

• Getting Started with the CData Python Connector for Templated

  Learn to install and license the CData Python Connector

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

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

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

• Create Shopify-Connected Business Apps in AppSheet

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

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

• «
• 1012
• 1013
• 1014
• 1015
• 1016
• 1017
• 1018
• 1019
• 1020
• 1021
• »