CData Software - Knowledge Base

Recent Articles

---

• «
• 598
• 599
• 600
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• »

• Automated Continuous WooCommerce Replication to Oracle

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

• Replicate Multiple LaunchDarkly Accounts via the CData Sync CLI

  Replicate multiple LaunchDarkly accounts to one or many databases.

• Enable the Billsby JDBC Driver in KNIME

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

• How to connect to Microsoft OneDrive Data from IntelliJ

  Integrate connectivity to Microsoft OneDrive with wizards in IntelliJ.

• Model Box Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Box, enabling the direct import of real-time Box.

• Work with Cloudflare Data in FoxPro

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

• Easily Integrate Vimeo Data in Lazarus Pascal IDE

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

• Using the CData Software ODBC Driver for Gmail in PyCharm

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

• Automated Continuous MailerLite Replication to SQL Server

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

• Replicate Zoho Books Data from PowerShell

  Write a quick PowerShell script to query Zoho Books. Use connectivity to the live data to replicate Zoho Books to SQL Server.

• Back Up ConstantContact 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 ConstantContact data.

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

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

• Create a Data Access Object for MailChimp Data using JDBI

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

• Visualize Live Invoiced Data in Tableau

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

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

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

• Integrate Goose with Live Sage Cloud Accounting Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sage Business Cloud Accounting from within the local AI agent.

• How to create Mixpanel federated tables in MySQL

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

• Import Avro Data into the Power BI Service for Visualizations

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

• Connect to Hacker News Data in Ruby

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

• Connect to Basecamp from Excel & GoogleSheets!

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

• Connect to Delighted Data in CloverDX (formerly CloverETL)

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

• Use Dash to Build to Web Apps on Gumroad Data

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

• Create Informatica Mappings From/To an ODBC Data Source for OnePageCrm

  Create an ODBC connection to OnePageCrm in Informatica and browse and transfer OnePageCrm.

• Explore Geographical Relationships in Dotmailer Data with Power Map

  Create data visualizations with Dotmailer in Power Map.

• Connect to Aircall Data from a Connection Pool in JBoss

  Integrate Aircall into Java servlets: Use the Management Console in JBoss to install the Aircall JDBC Driver.

• Automated Continuous LightSpeedRetail Replication to SQLite

  Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to SQLite.

• Add Timely Data to Informatica Enterprise Data Catalog

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

• How to connect to ChartMogul Data with Squirrel SQL client

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

• Analyze SAP ByDesign Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SAP ByDesign from Power Pivot. You will use the Table Import Wizard to load SAP Business ByDesign. You can visually build the import query or use any SQL supported by the driver.

• Connect to Toggl from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Toggl to connect to Toggl from Web applications running on WebLogic.

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

  Use the Salesforce ODBC Driver to create workflows that access real-time Salesforce & Force.com without any coding.

• Create Reports with Webflow Data in SAP Crystal Reports

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

• Integrate with Perigon Data using Apache Camel2

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

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

  Connect to Productboard from a connection pool in Tomcat.

• Automate XML Integration Tasks from PowerShell

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

• Connect to Pipedrive Data in RunMyProcess through Connect AI

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

• Build Active Directory-Connected Apps in Bubble

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

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

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

• Manage Certinia Data in DBArtisan as a JDBC Source

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

• Build Google Directory-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Google Directory to explore live Google Directory Data in Cursor to assist with building Google Directory-powered applications.

• Analyze Salesforce Marketing Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Salesforce Marketing Cloud and visualize live Salesforce Marketing Cloud in Infragistics Reveal.

• Build Data Flows from LightSpeedRetail to SQL Server using SSIS

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

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

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

• Connect to Shopify Data from Filemaker Pro (Mac)

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

• Replicate Aha! Data to Multiple Databases via the CData Sync CLI

  Replicate Aha! to disparate databases with a single configuration.

• Create Data Visualizations in Cognos BI with SharePoint Excel Services Data

  Access SharePoint Excel Services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Natively Connect to CockroachDB Data in PHP

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

• Automated Continuous MariaDB Replication to AlloyDB

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

• Replicate Excel Data in Heroku for Use in Salesforce Connect

  Replicate Microsoft Excel to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Integrating Antigravity CLI with Insightly via CData CLI

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

• Use Grok to Talk to Your Bullhorn CRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Bullhorn CRM for you.

• How to load Jodoo data into Elasticsearch via Logstash

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

• Model Shopify Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Shopify, enabling the direct import of real-time Shopify.

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

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

• How to Query Live SharePoint Excel Services Data in Perplexity MacOS Desktop

  Connect to and query live SharePoint Excel Services Data in Perplexity Desktop using CData MCP Server.

• Moving Data from NetSuite to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live NetSuite data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Build QuickBooks Online-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for QuickBooks Online Data and create custom apps in Mendix.

• Automate ZohoSubscriptions Data Replication to Couchbase

  Use CData Sync to Customize and automate ZohoSubscriptions replication to Couchbase.

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

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

• Access Live LinkedIn Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live LinkedIn from your Excel spreadsheets.

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

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

• Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway

  Use the CData Connector for Azure Analysis Services in APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services.

• Connect to Microsoft Ads Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Microsoft Ads in the Denodo Virtual DataPort Administrator.

• Design BIRT Reports on ZohoPeople Data

  Provide current ZohoPeople to your embedded analytics.

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

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

• Connect to MarkLogic from a Connection Pool in WebLogic

  Use the CData JDBC Driver for MarkLogic to connect to MarkLogic from Web applications running on WebLogic.

• How to Connect to Live Acumatica Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Acumatica ERP for you.

• Easily Integrate Adobe Experience Manager Data in Lazarus Pascal IDE

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

• DataBind Charts to Gong Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gong 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 Bitbucket Data in Lazarus Pascal IDE

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

• Enable the Zendesk JDBC Driver in KNIME

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

• Connect to Real-Time Bullhorn CRM Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Bullhorn CRM and Dataflow to import and use Bullhorn CRM in Power Apps.

• Build IBM Cloud Object Storage-Powered Applications in Claude Code with CData MCP Server

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

• Natively Connect to SAP HANA Data in PHP

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

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

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

• Build Dashboards with Stripe Data in DBxtra

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

• Query AfterShip Data through ODBC in Node.js

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

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

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

• How to Easily Query Dropbox Data in OpenOffice Base

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

• Create Data Visualizations in Cognos BI with Quickbase Data

  Access Quickbase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Query Live Stripe Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Stripe directly from the development environment.

• Connect to Avaza Data as an External Source in Dremio

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

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

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

• LINQ to Jumpseller 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 Jumpseller Data Provider.

• Automated Continuous LaunchDarkly Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Google BigQuery.

• Create Apps from Quickbase Data in Qlik Sense Cloud

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

• Analyze Placid Data in R via JDBC

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

• Getting Started with the CData ODBC Driver for Salesforce

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

• How to connect to Microsoft Entra ID Data from Spring Boot

  Connect to Microsoft Entra ID in a Spring Boot Application using the CData JDBC Driver for Microsoft Entra ID

• Use Dash to Build to Web Apps on Teradata Data

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

• Build Visualizations of Spark Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Spark SQL in Birst.

• Work with Adobe Commerce Data in FoxPro

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

• Connect to Zoho Inventory Data in Airbyte ELT Pipelines

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

• View Reports on Real-Time AlloyDB Data in Power BI Report Server

  Use the CData ODBC Driver for AlloyDB to visualize Google AlloyDB in Power BI Desktop and then publish them to Power BI Report Server.

• Automate ZohoPeople Data Replication to SAP HANA

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

• Connect to SAS xpt from Asprova with CData Software ODBC Driver for SAS xpt

  This article shows how to connect faster to SAS xpt data from Asprova.

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

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

• Integrate Supabase Data in the Pentaho Report Designer

  Publish reports based on Supabase in the Pentaho BI tool.

• Build Semantic Layer Views for Clockify Data in APOS Live Data Gateway

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

• Connect to FHIR Data in Ruby

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

• «
• 598
• 599
• 600
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• »