CData Software - Knowledge Base

Recent Articles

---

• «
• 407
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• 415
• 416
• »

• Analyze Redshift Data in R via JDBC

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

• Getting Started with the CData Tableau Connector for HCL Domino

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

• Build AI Agents with Couchbase Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Couchbase through CData Connect AI.

• Connect to Zoho Projects Data in RazorSQL

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

• Automated Continuous Teamgate Replication to SQLite

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

• Connect to Telegram from a Connection Pool in WebLogic

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

• Integrate with Live Microsoft OneDrive Data in MuleSoft (via CData Connect AI)

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

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

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

• Publish Crystal Reports on Insightly Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Insightly.

• Manage Pinecone Data in DBArtisan as a JDBC Source

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

• Load Wrike Data to a Database Using Embulk

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

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

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

• Connect to Xero Data in DBArtisan

  Use wizards in DBArtisan to configure Xero Accounting as a data source.

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

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

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

  Create a simple Workflow for Typeform in Informatica PowerCenter.

• Easily Integrate Phoenix Data in Lazarus Pascal IDE

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

• Connect to ZohoSubscriptions Data from PowerBuilder via JDBC

  This article demonstrates how to access ZohoSubscriptions from PowerBuilder using the ZohoSubscriptions JDBC Driver.

• Connect to Attio Data in Aqua Data Studio

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

• Create ConstantContact Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConstantContact data access from reports, embedded analytics, and more.

• Create Data Visualizations in Cognos BI with Excel Data

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

• Access Cosmos DB Data from MySQL in PHP

  Connect to Cosmos DB through the standard MySQL libraries in PHP.

• Manage Mode Data in DBArtisan as a JDBC Source

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

• Access Live Confluence Data in SAS JMP via ODBC

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

• Integrating GitHub Copilot CLI with Acumatica ERP 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 Query Act CRM Data in MySQL Workbench

  Execute MySQL queries against live Act CRM from MySQL Workbench.

• Integrate with Certinia Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Certinia in SnapLogic.

• Replicate Lakebase Data from PowerShell

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

• How to Connect to Live Amazon Athena Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon Athena without replication.

• Getting Started with the CData ODBC Driver for Outreach.io

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

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

• Connect to Splunk Data in DBArtisan

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

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

• Integrate PhantomBuster Data in Your Informatica Cloud Instance

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

• How to import HubDB Data into Apache Solr

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

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

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

• Automate OnePageCrm Data Replication to SAP HANA

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

• Build Automated Gong-Connected Workflows in Zapier

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

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

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

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

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

• Getting Started with the CData Power BI Connector for Jodoo

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• Publish Retently-Connected Dashboards in Tableau Server

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

• Integrate BigCommerce Data in Pentaho Data Integration

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

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

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

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

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

• How to connect to Hacker News Data from Spring Boot

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

• Connect to Delighted Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Delighted and work with Delighted in your FileMaker applications.

• Automate Microsoft OneDrive Integration Tasks from PowerShell

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

• Automated Continuous JSON Replication to SingleStore

  Use CData Sync for automated, continuous, customizable JSON replication to SingleStore.

• Automated Continuous Zoho Creator Replication to IBM DB2

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

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

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

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

  Connect to Apache Spark SQL in MicroStrategy Web using the CData Software JDBC Driver for Spark.

• How to Work with Zendesk Data in ETL Validator JDBC

  Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.

• Use the CData Software JDBC Driver for Aircall in MicroStrategy Desktop

  Connect to Aircall in MicroStrategy Desktop using the CData Software JDBC Driver for Aircall.

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

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

• Prepare, Blend, and Analyze Greenplum Data in Alteryx Designer (Connect AI)

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

• Getting Started with the CData JDBC Driver for Missive

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

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

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

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

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

• Create a Data Access Object for CapsuleCRM Data using JDBI

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

• Getting Started with the CData Power BI Connector for CircleCI

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• Getting Started with the CData ODBC Driver for Pingdom

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

• Analyze Splunk Data with Power Pivot

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

• How to connect to PagerDuty Data from Spring Boot

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

• Query Elasticsearch Data using the OData SDK for PHP

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

• Automated Continuous SAP HANA Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable SAP HANA replication to PostgreSQL.

• Connect to Quickbase Data in Airbyte ELT Pipelines

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

• Getting Started with the CData Power BI Connector for ZarMoney

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

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

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

• Create MongoDB-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to MongoDB Data from OutSystems and build custom enterprise apps using live MongoDB.

• Build Charts with WooCommerce Data in Clear Analytics

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

• Automated Continuous SharePoint Data Replication to OneLake in Microsoft Fabric

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

• Connect to Flowlu from Asprova with CData Software ODBC Driver for Flowlu

  This article shows how to connect faster to Flowlu data from Asprova.

• How to Work with SharePoint Data in AWS Glue Jobs Using JDBC

  Connect to SharePoint from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Publish Reports with Apollo Data in SAP Crystal Reports

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

• Use the CData Software ODBC Driver for Workday in MicroStrategy

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

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

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

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

• Query Unbounce Data in DataGrip

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

• Use the CData Software JDBC Driver for Zoom in MicroStrategy

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

• Connect and Query Live Jira Assets Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Jira Assets into Databricks

• Connecting Pipedream with AlloyDB Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on AlloyDB data in real time.

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

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

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

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

• Access Live PostgreSQL Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live PostgreSQL from your Excel spreadsheets.

• How to Connect to & Open Sage Cloud Accounting Data in Microsoft Excel

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

• Build Microsoft Ads-Connected Apps in Choreo

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

• How to work with SAS xpt Data in Apache Spark using SQL

  Access and process SAS xpt Data in Apache Spark using the CData Software JDBC Driver.

• Getting Started with the CData Tableau Connector for Elorus

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• Getting Started with the CData Power BI Connector for Marketo

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

• Automated Continuous PostgreSQL Replication to Snowflake

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

• Build Microsoft Teams-Connected Apps in Choreo

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

• Getting Started with the CData JDBC Driver for ConvertAPI

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

• Use the CData API Server in Microsoft Power BI

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

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

  Use CData Power BI Connectors to visualize SAP HANA in Power BI.

• How to Access Microsoft Ads Data Using Entity Framework

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

• Analyze Pipeliner CRM Data with Power Pivot

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

• Analyze SAP Hybris C4C Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of SAP Hybris C4C and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Connect to RSS Feeds in RapidMiner

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

• Build Automated SharePoint-Connected Workflows in Zapier

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

• Visualize Live Microsoft Entra ID Data in the Power BI Service

  Use CData Connect AI to connect to live Microsoft Entra ID and create custom reports in the Power BI Service through the On-Premises Gateway.

• «
• 407
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• 415
• 416
• »