CData Software - Knowledge Base

Recent Articles

---

• «
• 1253
• 1254
• 1255
• 1256
• 1257
• 1258
• 1259
• 1260
• 1261
• 1262
• »

• How to Easily Query DB2 Data in OpenOffice Base

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

• Automated Continuous MailChimp Replication to Google BigQuery

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

• How to Connect DBeaver to Apollo via a JDBC Driver

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

• Analyze SAP BusinessObjects BI Data in R via ODBC

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

• Add Jira Data to Informatica Enterprise Data Catalog

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

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

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

• Build Data Flows from Perplexity to SQL Server using SSIS

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

• Getting Started with the CData Python Connector for Cohere

  Learn to install and license the CData Python Connector

• Automated Continuous BambooHR Replication to Google BigQuery

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

• Integrating Cursor CLI with Omnisend 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.

• Build Dashboards with Dynamics 365 Business Central Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in Dundas BI.

• Access SAP Netweaver Gateway Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP Netweaver Gateway from HeidiSQL.

• Getting Started with the CData JDBC Driver for QuickBooks

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

• Connect to and Query OneNote Data in QlikView over ODBC

  Create data visualizations with Microsoft OneNote in QlikView.

• Query Attio Data as a MySQL Database in Node.js

  Execute MySQL queries against Attio from Node.js.

• Create Dynamic Facebook Ads Grids Using the Infragistics XamDataGrid

  Learn how you can connect Facebook Ads to Infragistics XamDataGrid to build dynamic grids.

• Create Authorize.Net Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Authorize.Net from PowerBI.com to create Power BI Dataflows with real-time data.

• Build Oracle Eloqua-Connected ETL Processes in Google Data Fusion

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

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

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

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

• Replicate Multiple Amazon S3 Accounts

  Replicate multiple Amazon S3 accounts to one or many databases.

• Natively Connect to OData Services in PHP via ODBC (Linux)

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

• ETL LDAP in Oracle Data Integrator

  This article shows how to transfer LDAP into a data warehouse using Oracle Data Integrator.

• Build Visualizations of Drip Data in Birst

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

• Build a Singer.io Tap for Act-On With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Act-On data using

• Automated Continuous Wave Financial Replication to Snowflake

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

• CData HubSpot Driver v24 and Above Enhances Functionality with Leads Object

  CData HubSpot Driver (v24 and above) now supports the Leads object, enabling effortless access to lead data without complex API workflows.

• Automated Continuous AlloyDB Replication to SQLite

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

• Automated Insightly Data Replication to Teradata

  Use CData Sync to Customize and automate Insightly replication to Teradata.

• DocuSign Reporting in OBIEE with the DocuSign JDBC Driver

  Deploy the DocuSign JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

  Replicate Paylocity to disparate databases with a single configuration.

• Replicate SAP Data in Heroku for Use in Salesforce Connect

  Replicate SAP ERP/NetWeaver to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

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

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

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

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

• Query MailChimp Data as a MySQL Database in Node.js

  Execute MySQL queries against MailChimp from Node.js.

• Integrate Cursor with Live Lakebase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Lakebase from within the editor.

• Bidirectional Access to Oracle Service Cloud Data from FileMaker Pro

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

• Connect to Clio Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Epicor Kinetic Replication to SQL Server

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

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

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

• Use the CData ODBC Driver for Oracle Financials Cloud from SharePoint Excel Services

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

• Write a Simple Go Application to work with SAP HANA XS Advanced Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA XS Advanced.

• Automated Continuous Trello Replication to Google Cloud SQL

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

• Connect to Stripe Data in Airbyte ELT Pipelines

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

• How to connect to SageHR Data from Spring Boot

  Connect to SageHR in a Spring Boot Application using the CData API Driver for JDBC

• Connect to IBM Cloud Object Storage Data in HULFT Integrate

  Connect to IBM Cloud Object Storage as a JDBC data source in HULFT Integrate

• Automated Continuous Bullhorn CRM Replication to Databricks

  Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Databricks.

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

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

• Add Helpscout Data to Informatica Enterprise Data Catalog

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

• Automated Continuous Jira Data Replication to OneLake in Microsoft Fabric

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

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

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

• How to connect to Cosmos DB Data in DBVisualizer

  Integrate Azure Cosmos DB with visual data analysis tools and data connection wizards in DBVisualizer

• Access Live Redshift Data in Coginiti Pro

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

• Parquet Reporting and Star Schemas in OBIEE

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

• How to Connect to Live Blackbaud FE NXT 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 Blackbaud FE NXT for you.

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

  Gain real-time, database-like connectivity to LinkedIn from mobile and tablet Power Apps.

• How to use SQLAlchemy ORM to access Oracle Service Cloud Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Service Cloud.

• Integrating Antigravity CLI with Short.io via CData CLI

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

• Integrating Cursor CLI with Clio 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.

• Use the CData Software ODBC Driver for Jira Assets in MicroStrategy

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

• Use the CData Software JDBC Driver for MongoDB in MicroStrategy Web

  Connect to MongoDB in MicroStrategy Web using the CData Software JDBC Driver for MongoDB.

• Facebook Reporting and Star Schemas in OBIEE

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

• Integrating LlamaIndex with Workday Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Workday in real time.

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

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

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

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

• Connect to FHIR Data in the Denodo Platform

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

• Explore Geographical Relationships in SurveyMonkey Data with Power Map

  Create data visualizations with SurveyMonkey in Power Map.

• Migrating data from SAP HANA XS Advanced to Snowflake using CData SSIS Components.

  Easily push SAP HANA XS Advanced to Snowflake using the CData SSIS Tasks for SAP HANA XS Advanced and Snowflake.

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

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

• Enable the Greenplum JDBC Driver in KNIME

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

• Back Up Google Directory to SQL Server through SSIS

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

• Replicate Multiple Splunk Accounts via the CData Sync CLI

  Replicate multiple Splunk accounts to one or many databases.

• Integrate Real-Time Access to Google Contacts in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Contacts in real time.

• Integrating Boomi Agentstudio with Act-On Data via CData Connect AI

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

• Integrate Real-Time Access to SAP HANA in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP HANA in real time.

• Stream Azure DevOps Data into Apache Kafka Topics

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

• Connect to Redshift Data in Aqua Data Studio

  Access Amazon Redshift from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Automated Continuous Wistia Replication to Local Delimited Files

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

• Automate Google Calendar Tasks in Power Automate Using CData API Server

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

• Natively Connect to Notion Data in PHP

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

• Automate SAP Business Warehouse Integration Tasks from PowerShell

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

• How to connect to Dropbox Data in DBVisualizer

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

• Load Contentful Data to a Database Using Embulk

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

• Create SSAS Tabular Models from Facebook Data

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

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

  Create a simple Workflow for IBM Cloudant in Informatica PowerCenter.

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

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

• Establish a Live Connection with MySQL Data using Tableau Bridge

  The CData ODBC Driver for MySQL enables you to integrate live MySQL into Tableau Cloud dashboards using the Tableau Bridge.

• Access Live Google Search Results in Coginiti Pro

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

• Integrating LangChain with MarkLogic Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MarkLogic within automated workflows.

• Create a Data Access Object for Zoho Recruit Data using JDBI

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

• Build Data Flows from Demio to SQL Server using SSIS

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

• Visualize Azure Data Lake Storage Data in Tableau

  The CData ODBC driver for Azure Data Lake Storage enables you integrate Azure Data Lake Storage into Tableau dashboards.

• How to Import Data from SAP BusinessObjects BI into Google Sheets

  Import SAP BusinessObjects BI into a Google spreadsheet that is automatically refreshed.

• Automated Continuous AdRoll Replication to MySQL

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

• How to Connect to Amazon Marketplace Data in Using Python: 6 Steps

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

• Connect to and Visualize Live Autopilot Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Autopilot.

• Automated Continuous FreeAgent Replication to Local Delimited Files

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

• Import SQL Analysis Services Data into Microsoft Power Query

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

• Create Google Analytics-Connected Business Apps in AppSheet

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

• Visualize Live Office 365 Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Office 365.

• «
• 1253
• 1254
• 1255
• 1256
• 1257
• 1258
• 1259
• 1260
• 1261
• 1262
• »