CData Software - Knowledge Base

Recent Articles

---

• «
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• »

• ETL DB2 in Oracle Data Integrator

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

• How to Work with SAP Netweaver Gateway Data in ETL Validator JDBC

  Connect to SAP Netweaver Gateway from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Continuous ZohoPeople Replication to MongoDB

  Use CData Sync for automated, continuous, customizable ZohoPeople replication to MongoDB.

• Work with ZohoMarketingHub Data in FoxPro

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

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

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

• Bind Live Trello Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Trello data

• Automated Continuous Instagram Replication to SQLite

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

• Feed Jira Assets Data into FineReport

  How to set Jira Assets as a JDBC data source in FineReport.

• Analyze Clockify Data in Infragistics Reveal

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

• ETL Google Ad Manager in Oracle Data Integrator

  This article shows how to transfer Google Ad Manager into a data warehouse using Oracle Data Integrator.

• Connect to Monday.com Data in Google Apps Script via SQL Gateway

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

• Create Datasets from Aweber in Domo Workbench and Build Visualizations of Aweber Data in Domo

  Use the CData Software ODBC Driver for Aweber to create datasets from Aweber in Domo Workbench and then build visualizations in the Domo service.

• Connect to SAP BusinessObjects BI Data from a Connection Pool in JBoss

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

• Use Claude to Talk to Your Power BI XMLA Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Power BI XMLA for you.

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

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

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

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

• Process & Analyze Paylocity Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Paylocity Data.

• Query Rootly Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Rootly and perform CRUD operations on Rootly from Node.js.

• Automate eBay Analytics Data Replication to Azure Data Lake

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

• Use the CData Software ODBC Driver for QuickBooks in MicroStrategy

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

• Bridge Mistral AI Connectivity with Apache NiFi

  Access and process Mistral AI in Apache NiFi using the CData JDBC Driver.

• Creating Zendesk-Connected Applications in Unqork

  You can use CData Connect AI to feed Zendesk to Unqork and build custom business apps.

• Migrating data from Sybase IQ to Databricks using CData SSIS Components.

  Easily push Sybase IQ to Databricks using the CData SSIS Tasks for Sybase IQ and Databricks.

• Automated Continuous ActiveCampaign Replication to Snowflake

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

• How to connect to Certinia Data from Spring Boot

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

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

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

• Connect to Azure Synapse Data from a Connection Pool in JBoss

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

• Build Gorgias-Powered Applications in Cursor with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Gorgias Data in Cursor to assist with building Gorgias-powered applications.

• DataBind Zoho Recruit Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Zoho Recruit to a chart.

• Query Instagram Data in DataGrip

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

• Connect to Square Data in CloverDX (formerly CloverETL)

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

• How to Connect to LDAP Objects in Using Python: 6 Steps

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

• Query Onfleet Data in DataGrip

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

• Extend Google Sheets with MySQL Data

  Make calls to MySQL from Google Apps Script via the API Server.

• Natively Connect to Exact Online Data in PHP

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

• Connect to Missive Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Sugar CRM Data from a Connection Pool in Jetty

  The Sugar CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Sugar CRM from Web apps in Jetty.

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

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

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

  Execute MySQL queries against Webex from Node.js.

• Connect to Mistral AI Data in Claris FileMaker Pro

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

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

  Use CData API Driver for Power BI and Dataflow to import and use iContact in Power Apps.

• Integrate Elasticsearch Data in Pentaho Data Integration

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

• How to Connect DBeaver to Zoho Books via a JDBC Driver

  Manage Zoho Books with visual tools in DBeaver like the query browser.

• Connect to Quickbase Data in DBArtisan

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

• Visualize IBM Informix Data in TIBCO Spotfire through ADO.NET

  Integrate IBM Informix into dashboards in TIBCO Spotfire.

• Process & Analyze MailerSend Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live MailerSend Data.

• DataBind Chargebee Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Chargebee to a chart.

• Connect to Microsoft Entra ID Data in Jaspersoft Studio

  Execute SQL to remote Microsoft Entra ID in Jaspersoft Studio.

• Integrate Azure DevOps Data in Your Informatica Cloud Instance

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

• Connect Active Directory to IBM WebSphere Using the CData JDBC Driver

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

• Query Salesforce Marketing Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Salesforce Marketing Cloud from Node.js.

• Build Dashboards with Lakebase Data in DBxtra

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

• Access Perplexity Data as a Remote Oracle Database

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

• Query CampaignMonitor Data in ColdFusion

  Write standard ColdFusion data access code to connect to CampaignMonitor.

• Automated Continuous Tickspot Replication to MongoDB

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

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

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

• DataBind Controls to ShipEngine Data in C++Builder

  DataBind to ShipEngine in C++Builder with standard components and controls.

• Access Live Codat Data in Tableau with CData API Server

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

• Connect to Avro Data from Filemaker Pro (Mac)

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

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

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

• Connect to Airtable Data from Filemaker Pro (Mac)

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

• Create Power BI Reports on Real-Time Autopilot Data

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

• Integrating LangChain with Exact Online Data via CData Connect AI

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

• Integrate Real-Time Access to Mailgun in SAPUI5 MVC Apps

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

• How to Query Bitly Data in MySQL Workbench

  Execute MySQL queries against live Bitly from MySQL Workbench.

• Add Microsoft Planner Data to Informatica Enterprise Data Catalog

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

• How to Access Live PDFMonkey Data in Visual Studio Code via Cline

  Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live PDFMonkey from the Cline extension in Visual Studio Code.

• Create Zendesk-Connected Enterprise Applications in OutSystems

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

• Automate Epicor Kinetic Data Replication to Azure Data Lake

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

• Getting Started with the CData SSIS Components for Adobe Analytics

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

• Connect to Bannerbear Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Bannerbear.

• Excel Spreadsheet Automation on Wrike Data with the QUERY Formula

  Pull data from Wrike, automate spreadsheets, and more with the QUERY formula.

• Create Zoho Projects-Connected Nintex Workflows

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

• How to use SQLAlchemy ORM to access Oracle SCM Data in Python

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

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

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

• Connect to Gong Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Gong from Crystal Reports.

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

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

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

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

• Access Live Workday Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Workday from your Google Sheets.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Creator

  Provide connectivity to Zoho Creator through an SAP BusinessObjects universe.

• DataBind HBase Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for HBase with the DevExpress Windows Forms and Web controls to provide Apache HBase to a chart.

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

  Execute MySQL queries against PivotalTracker from Node.js.

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

  Use CData API Driver for Power BI and Dataflow to import and use AfterShip in Power Apps.

• Query Codat Data through ODBC in Node.js

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

• How to publish and share Adobe Analytics Data dashboards with Tableau Server

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

• Integrate Real-Time Access to Rebilly in SAPUI5 MVC Apps

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

• Analyze Zoho CRM Data in R via ODBC

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

• Build Data Flows from SQL Server to Elasticsearch through SSIS

  Easily push SQL Server data to Elasticsearch using the CData SSIS Tasks for Elasticsearch.

• Automate Google Directory Data Replication to Couchbase

  Use CData Sync to Customize and automate Google Directory replication to Couchbase.

• Use the CData ODBC Driver for SQL Analysis Services from SharePoint Excel Services

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

• Automated Continuous AfterShip Replication to Databricks

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

• Enable the HubSpot JDBC Driver in KNIME

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

• Connect to Coda Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access eBay Analytics Data from MySQL in PHP

  Connect to eBay Analytics through the standard MySQL libraries in PHP.

• Visualize Act-On 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 Act-On into TIBCO Spotfire.

• Connect to Amazon Marketplace in SpagoBI

  Create reports featuring live Amazon Marketplace in SpagoBI Studio. Host Amazon Marketplace reports on SpagoBI Server.

• Connect to Greenplum Data in DBeaver

  Use the CData ODBC Driver to connect to Pivotal GreenPlum in DBeaver.

• Build Automated Oracle Eloqua-Connected Workflows in Zapier

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

• Query Autopilot Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Autopilot and perform CRUD operations on Autopilot from Node.js.

• Build Visualizations of Klaviyo Data in Birst

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

• «
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• »