CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Smartsheet
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Smartsheet.
-
Automate PagerDuty Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PagerDuty from PowerShell? This article demonstrates how to utilize the PagerDuty Cmdlets for tasks like connecting to PagerDuty, automating operations, downloading data, and more.
-
Establish a Live Connection with Apollo Data using Tableau Bridge
The CData ODBC Driver for Apollo enables you to integrate live Apollo into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Nethunt Data in Talend Cloud Data Management Platform
Connect Nethunt Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Deploy the ADO.NET Provider for SharePoint Excel Services on an SSRS Report Server
Connect to SharePoint Excel Services 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.
-
Build PayPal-Connected Apps in Choreo
Use CData Connect AI to connect to PayPal Data from Choreo and build custom apps using live PayPal.
-
Integrate Goose with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FHIR from within the local AI agent.
-
Build Apps with Live ShipStation in Adalo using CData Connect AI
Use CData Connect AI to integrate live ShipStation into the Adalo platform and build custom mobile and web applications with real-time ShipStation.
-
Connect to Google Calendar Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Calendar and the Script function in FileMaker Pro to connect to Google Calendar and work with Google Calendar in your FileMaker application.
-
Create Informatica Mappings From/To a JDBC Data Source for Phoenix
Create Phoenix data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time Power BI XMLA Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Power BI XMLA in ColdFusion.
-
Build Apps with Live PabblySubscriptions Data Using the Low-Code Development Platform of Mendix
Connect PabblySubscriptions with Mendix to build apps using the CData API Driver for JDBC.
-
How to update Dropbox from Excel
This article explains how to transfer data from Excel to Dropbox using the Excel Add-In for Dropbox.
-
CockroachDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CockroachDB facts in real time.
-
Integrate Reply.io with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Reply.io with External Services.
-
Working with Stack Exchange Data in LINQPad
Execute LINQ queries to Stack Exchange in LINQPad.
-
Automated Continuous Oracle Eloqua Reporting Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Amazon Redshift.
-
Automate ZohoDesk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoDesk from PowerShell? This article demonstrates how to utilize the ZohoDesk Cmdlets for tasks like connecting to ZohoDesk, automating operations, downloading data, and more.
-
LINQ to Drip 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 Drip Data Provider.
-
Automate PostgreSQL Data Replication to Azure Synapse
Use CData Sync to customize and automate PostgreSQL replication to Azure Synapse.
-
Build Apps with Live Oracle SCM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle SCM into the Adalo platform and build custom mobile and web applications with real-time Oracle SCM.
-
Build a Simple VCL Application for AfterShip Data
How to build a simple VCL Application to view AfterShip in RAD Studio using the CData ODBC Driver for AfterShip.
-
How to Work with Gong Data in ETL Validator JDBC
Connect to Gong from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from SuiteCRM to Snowflake using CData SSIS Components.
Easily push SuiteCRM to Snowflake using the CData SSIS Tasks for SuiteCRM and Snowflake.
-
How to create Visio diagrams from MariaDB Data
Automatically update MariaDB with the changes you make to Visio master shapes.
-
Connect to Sage 200 Data in Aqua Data Studio
Access Sage 200 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Quickbase Data in JRuby
Create a simple JRuby app with access to live Quickbase.
-
Model, Search, and Visualize Live Google Spanner Data in ThoughtSpot
Use CData Connect AI to connect to live Google Spanner for modeling, searching, and visualizing.
-
Connect to Google Translate 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 Google Translate and work with Google Translate in your FileMaker application.
-
Connect to EnterpriseDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate DocuSign Data Replication to SAP HANA
Use CData Sync to customize and automate DocuSign replication to SAP HANA.
-
Trigger Teradata IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Teradata with standard wizards in Logic Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Insightly
Create Insightly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MariaDB
Provide connectivity to MariaDB through an SAP BusinessObjects universe.
-
Visualize SAP HANA Data in TIBCO Spotfire through ADO.NET
Integrate SAP HANA into dashboards in TIBCO Spotfire.
-
Integrating Boomi Agentstudio with Instagram Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Instagram, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Teamwork Data from IntelliJ
Integrate connectivity to Teamwork with wizards in IntelliJ.
-
Connect to SingleStore from a Connection Pool in WebLogic
Use the CData JDBC Driver for SingleStore to connect to SingleStore from Web applications running on WebLogic.
-
Use the CData ODBC Driver for Browserless from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Browserless to connect to Browserless from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Browserless in Excel.
-
How to use SQLAlchemy ORM to access Basecamp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Basecamp.
-
Connect to Contentful Data in Jaspersoft Studio
Execute SQL to remote Contentful in Jaspersoft Studio.
-
Use CData Connect AI to Access Microsoft Exchange Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Exchange in the Power Pivot business intelligence tool.
-
Integrating Retently Data in Talend Cloud Data Management Platform
Connect Retently Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Adobe Analytics Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Analytics data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Harvest Data in Talend Cloud Data Management Platform
Connect Harvest Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Greenhouse Replication to SQLite
Use CData Sync for automated, continuous, customizable Greenhouse replication to SQLite.
-
Access Live Instantly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Instantly into the statistical analysis tools available in SAS JMP. This article shows how to use Instantly in the Graph Builder and Query Builder.
-
Replicate Databricks Data in Heroku for Use in Salesforce Connect
Replicate Databricks to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Parquet-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Parquet to explore live Parquet Data in GitHub Copilot to assist with building Parquet-powered applications.
-
Connect to Live Dropbox Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Dropbox in CData Connect AI and connect to your Dropbox from PostgreSQL.
-
Integrate LibreChat with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Stripe from within the chat interface.
-
Getting Started with the CData ODBC Driver for Flowlu
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Flowlu.
-
Design BIRT Reports on Freshsales Data
Provide current Freshsales to your embedded analytics.
-
Add Sugar CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sugar CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Natively Connect to Tanda Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Tanda. Leverage the native support for ODBC in PHP.
-
Choosing the Best Method to Connect Facebook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Facebook from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating JobNimbus Data in Talend Cloud Data Management Platform
Connect JobNimbus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate Authorize.Net Data Replication to SAP HANA
Use CData Sync to customize and automate Authorize.Net replication to SAP HANA.
-
Create Dynamic Jodoo Grids Using the Infragistics XamDataGrid
Learn how you can connect Jodoo to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live Office 365 Data in Perplexity MacOS Desktop
Connect to and query live Office 365 Data in Perplexity Desktop using CData MCP Server.
-
Visualize OneNote Data in TIBCO Spotfire through OData
Integrate Microsoft OneNote into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Shortcut
Create an ODBC connection to Shortcut in Informatica and browse and transfer Shortcut.
-
Query Adobe Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Adobe Analytics from Node.js.
-
How to integrate Avalara AvaTax with Apache Airflow
Access and process Avalara AvaTax in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous HubDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HubDB replication to Apache Kafka.
-
Using the CData Software ODBC Driver for Mode in PyCharm
Connect to Mode as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mode.
-
Access Live MarkLogic Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live MarkLogic data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Amazon DynamoDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon DynamoDB from Node.js.
-
Access SageHR Data from MySQL in PHP
Connect to SageHR through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SingleStore
Provide connectivity to SingleStore through an SAP BusinessObjects universe.
-
Connect to Couchbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Couchbase from Appeon PowerBuilder using the CData ADO.NET Provider for Couchbase.
-
Getting Started with the CData Connect AI Python SDK for Google Campaign Manager 360
Install the CData Connect AI Python SDK to read and write live Google Campaign Manager 360 with standard DB-API 2.0 Python code.
-
Build Agents in Relevance AI with Access to Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Snowflake within intelligent agent workflows.
-
Connect to Reckon Data from a Connection Pool in Jetty
The Reckon JDBC Driver supports connection pooling: This article shows how to connect faster to Reckon from Web apps in Jetty.
-
Connect to Shippo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Shippo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Visualizations of Microsoft Teams Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Teams in Birst.
-
Build HubSpot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HubSpot.
-
Analyze HBase Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache HBase and visualize live Apache HBase in Infragistics Reveal.
-
Automated Continuous Microsoft Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to AlloyDB.
-
How to Access Live Adobe Experience Manager Data in Visual Studio Code via Cline
Run CData MCP Server for Adobe Experience Manager on Windows Subsytem for Linux (WSL) and connect to live Adobe Experience Manager from the Cline extension in Visual Studio Code.
-
Build Visualizations of MySQL Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MySQL in Birst.
-
Integrating LlamaIndex with HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on HubSpot in real time.
-
Replicate Access Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Access to disparate databases with a single configuration.
-
Integrate Wistia Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wistia from Informatica Cloud.
-
Integrate Klaviyo Data into Power Automate Desktop using CData Connect
CData Connect for Klaviyo Data enables you to integrate Klaviyo into workflows built using Microsoft Power Automate Desktop.
-
Integrating ZeroBounce Data in Talend Cloud Data Management Platform
Connect ZeroBounce Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Microsoft Copilot Studio to talk to your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your OData for you.
-
Use the CData ODBC Driver for Outlook from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outlook to connect to Outlook from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outlook in Excel.
-
Analyze SAP SuccessFactors Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP SuccessFactors and visualize SAP SuccessFactors in SAP Analytics Cloud.
-
Build Dashboards with Chargebee Data in Dundas BI
Create dynamic dashboards and perform analytics based on Chargebee in Dundas BI.
-
DataBind Controls to Flowlu Data in Delphi
DataBind to Flowlu in Delphi with standard data access components and controls.
-
Connect to LionDesk Data in Ruby
Connect to LionDesk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate EmailOctopus Data Replication to Azure Synapse
Use CData Sync to customize and automate EmailOctopus replication to Azure Synapse.
-
Build CloudConvert-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CloudConvert and build web apps with connectivity to live CloudConvert.
-
Create SSAS Tabular Models from Jira Data
How to build a SQL Server Analysis Service Tabular Model from Atlassian Jira using CData drivers.
-
Access Live Missive Data in Coginiti Pro
Connect to and query live Missive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Extract, Transform, and Load SuiteCRM Data in Informatica PowerCenter
Create a simple Workflow for SuiteCRM in Informatica PowerCenter.
-
Automate CircleCI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CircleCI from PowerShell? This article demonstrates how to utilize the CircleCI Cmdlets for tasks like connecting to CircleCI, automating operations, downloading data, and more.
-
Access Outlook Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Outlook from your Oracle system.
-
How to Connect to Live Airtable 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 Airtable without replication.