CData Software - Knowledge Base

Recent Articles

---

• «
• 198
• 199
• 200
• 201
• 202
• 203
• 204
• 205
• 206
• 207
• »

• Access Live Dynamics 365 Business Central Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Dynamics 365 Business Central through MCP integration.

• 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.

• Integrate LibreChat with Live Cloudant Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live IBM Cloudant from within the chat interface.

• Connect to Vimeo Data in Jaspersoft Studio

  Execute SQL to remote Vimeo in Jaspersoft Studio.

• Work with Factorial Data in FoxPro

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

• Connect to Mixpanel Data in Jaspersoft Studio

  Execute SQL to remote Mixpanel in Jaspersoft Studio.

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

  Replicate Paylocity to disparate databases with a single configuration.

• How to Query SFTP Data in MySQL Workbench

  Execute MySQL queries against live SFTP from MySQL Workbench.

• Connect to LightSpeedRetail Data in CloverDX (formerly CloverETL)

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

• 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.

• Replicate Multiple TaxJar Accounts

  Replicate multiple TaxJar accounts to one or many databases.

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

  Execute MySQL queries against MailChimp from Node.js.

• 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

• Connect to Figshare Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Figshare and work with Figshare in your FileMaker application.

• Connect to Dynamics CRM Data in the Denodo Platform

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

• How to Import Data from Jodoo into Google Sheets

  Import Jodoo into a Google spreadsheet that is automatically refreshed.

• 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 Elorus from SharePoint Excel Services

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

• Build LeadDesk-Powered Applications in GitHub Copilot with CData MCP Server

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

• Connect to Shortcut Data as an External Source in Dremio

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

• 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.

• DataBind Charts to Workable Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workable 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.

• Connect to Stripe Data in Airbyte ELT Pipelines

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

• Integrate Cline with Live WordPress Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live WordPress from within your IDE.

• 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.

• Build Semantic Layer Views for Amazon Marketplace Data in APOS Live Data Gateway

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

• Access Live Redshift Data in Coginiti Pro

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

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

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

• Parquet Reporting and Star Schemas in OBIEE

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

• Build Microsoft Entra ID-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Entra ID.

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

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

• 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.

• Build a Simple VCL Application for ChartMogul Data

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

• 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.

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

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

• Facebook Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Facebook facts 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.

• 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.

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

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

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

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

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

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

• Enable the Greenplum JDBC Driver in KNIME

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

• Access Access Data from MySQL in PHP

  Connect to Access through the standard MySQL libraries in PHP.

• Connect to Rootly Data in HULFT Integrate

  Connect to Rootly as a JDBC data source in HULFT Integrate

• 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.

• Deploy the ADO.NET Provider for Microsoft Teams on an SSRS Report Server

  Connect to Microsoft Teams from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• 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 Quaderno in SAPUI5 MVC Apps

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

• 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.

• Access Paylocity Data from MySQL in Amazon QuickSight

  Connect to Paylocity and build visualizations of Paylocity using a MySQL Connection in Amazon QuickSight.

• Bidirectional Access to Onfleet Data from FileMaker Pro

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

• Create SSAS Tabular Models from ServiceNow Data

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

• How to Create Power BI Visual Reports with Real-Time Oracle Eloqua Reporting Data

  Use CData Power BI Connectors to visualize Oracle Eloqua Reporting in Power BI.

• 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).

• Analyze Cohere Data in Slingshot with CData API Server

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

• Use Manus AI to Talk to Your CouchDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Apache CouchDB.

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

• Getting Started with the CData Python Connector for Jira

  Learn to install and license the CData Python Connector

• 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.

• Integrate Open WebUI with Live Cosmos DB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Cosmos DB from within the chat interface.

• 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.

• Build Apps with Live Act-On Data Using the Low-Code Development Platform of Mendix

  Connect Act-On with Mendix to build apps using the CData JDBC Driver for Act-On.

• Analyze Mailjet Data in Slingshot with CData API Server

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

• 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.

• 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.

• Connect to and Query Paddle Data in QlikView over ODBC

  Create data visualizations with Paddle in QlikView.

• 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.

• Integrate Supabase with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Supabase with External Services.

• 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.

• Use the CData ODBC Driver for Zoho Projects from SharePoint Excel Services

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

• 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.

• Build Outreach.io-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Outreach.io to explore live Outreach.io Data in GitHub Copilot to assist with building Outreach.io-powered applications.

• Connect to Authorize.Net Data in Claris FileMaker Pro

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

• Integrate with Productboard Data using Apache Camel2

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

• Getting Started with the CData SSIS Components for Dynamics 365

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

• 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).

• Load Landbot Data to a Database Using Embulk

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

• 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.

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

  Create a simple Workflow for Samanage in Informatica PowerCenter.

• Visualize Live Office 365 Data in Tableau

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

• Connect to Adobe Experience Manager Data in DBArtisan

  Use wizards in DBArtisan to configure Adobe Experience Manager as a data source.

• Visualize Productboard Data in TIBCO Spotfire through OData

  Integrate Productboard into dashboards in TIBCO Spotfire.

• Connect to Tally Data from HeidiSQL

  Use CData Connect AI to connect to and query live Tally ERP from HeidiSQL.

• Use the CData SSIS Components to Insert New or Update Existing Amazon DynamoDB Records from SQL Server

  Easily push SQL Server data to Amazon DynamoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon DynamoDB or update existing records with data from a SQL Server database.

• Import Google Cloud Storage Data into Microsoft Power Query

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

• Access Live SAP Business One Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live SAP Business One from your Excel spreadsheets.

• Build a Singer.io Tap for IBM Cloud Object Storage With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live IBM Cloud Object Storage data using

• Build GitLab Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live GitLab and build visualizations in Tableau Cloud.

• How to Query Reckon Data in MySQL Workbench

  Execute MySQL queries against live Reckon from MySQL Workbench.

• «
• 198
• 199
• 200
• 201
• 202
• 203
• 204
• 205
• 206
• 207
• »