CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Teams
Create an ODBC connection to Microsoft Teams in Informatica and browse and transfer Microsoft Teams.
-
Automated Continuous Toggl Replication to SQL Server
Use CData Sync for automated, continuous, customizable Toggl replication to SQL Server.
-
Automated Continuous Billsby Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Billsby replication to PostgreSQL.
-
Connect to Zoho CRM Data in RazorSQL
Connect to Zoho CRM from wizards and query Zoho CRM from the GUI in the RazorSQL database management tool.
-
Operational Reporting on Databricks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Databricks.
-
Query SAP Business Warehouse Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Business Warehouse from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for HCL Domino
Create HCL Domino data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to Helpscout Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Helpscout. Leverage the native support for ODBC in PHP.
-
Replicate SAP Business One Data to Multiple Databases
Replicate SAP Business One to disparate databases with a point-and-click configuration.
-
Automated Continuous Mailgun Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mailgun replication to IBM DB2.
-
Bidirectional Access to Shortcut Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Shortcut in Filemaker Pro for Mac or Windows.
-
Integrate with FreshBooks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FreshBooks to a JSON file on disk.
-
How to Access Salesforce CRM Analytics Data Using Entity Framework
This article shows how to access Salesforce CRM Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Dynamics 365 Business Central Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Dynamics 365 Business Central.
-
Extend Google Sheets with Reckon Data
Make calls to Reckon from Google Apps Script via the API Server.
-
Connect to SAS Data Sets Data in DBeaver
Use the CData ODBC Driver to connect to SAS Data Sets in DBeaver.
-
Create Zuora-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zuora Data from OutSystems and build custom enterprise apps using live Zuora.
-
Connect to SAP Ariba Source Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Ariba Source from Crystal Reports.
-
Natively Connect to Planio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Planio. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Jira Assets Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Jira Assets securely in real time.
-
How to integrate ServiceDesk Plus with Apache Airflow
Access and process ServiceDesk Plus in Apache Airflow using the CData JDBC Driver.
-
Visualize Epicor Kinetic Data in TIBCO Spotfire through OData
Integrate Epicor Kinetic into dashboards in TIBCO Spotfire.
-
How to load DocuSign data into Elasticsearch via Logstash
Introducing a simple method to load DocuSign data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Cursor with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live NetSuite SuiteAnalytics from within the editor.
-
Automate Spark Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Spark SQL from PowerShell? This article demonstrates how to utilize the Spark Cmdlets for tasks like connecting to Apache Spark SQL, automating operations, downloading data, and more.
-
Integrating SQL Server Data in Talend Cloud Data Management Platform
Connect SQL Server Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SQL Server.
-
Use Grok to Talk to Your Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Oracle Sales for you.
-
Connect to Sybase IQ Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sybase IQ in Google Apps Script.
-
Access Instagram Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Instagram from HeidiSQL.
-
Use CData Connect AI to Access Gmail Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Gmail in the Power Pivot business intelligence tool.
-
Connect to GraphQL Data in Aqua Data Studio
Access GraphQL from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Live Gmail Data in SAS Viya
Use CData Connect AI to connect to Gmail from SAS Viya and deploy self-service analytics using live Gmail.
-
Connect to HubSpot Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HubSpot from Filemaker Pro on Mac.
-
Integrate SAP Ariba Source Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Source from Informatica Cloud.
-
How to connect to Miro Data with Squirrel SQL client
Connect to Miro and execute queries in the Squirrel SQL Client.
-
Connect to Azure Analysis Services Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Analysis Services in Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Egnyte
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build an OLAP Cube in SSAS from Discourse Data
Establish a connection to Discourse data from SQL Server Analysis Services, and use the Discourse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Agentforce with Microsoft Dataverse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Dataverse (CDS) for you.
-
Automated Continuous Jodoo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Jodoo replication to PostgreSQL.
-
How to connect to ZohoMarketingHub Data from Spring Boot
Connect to ZohoMarketingHub in a Spring Boot Application using the CData API Driver for JDBC
-
How to create an RPA flow for Stripe Data in UiPath Studio
Use the Stripe ODBC Driver to create workflows that access real-time Stripe without any coding.
-
Edit and Search IBM Cloud Object Storage External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of IBM Cloud Object Storage to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create IBM Cloud Object Storage objects that you can access from apps and the dashboard.
-
Getting Started with the CData Tableau Connector for PingOne
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for PingOne.
-
Connect to Sybase Data in ACL Analytics
Connect to Sybase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sybase.
-
Build MVC Applications with Connectivity to Sentry Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sentry from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Attio in MicroStrategy
Connect to Attio in MicroStrategy Developer using the CData Software ODBC Driver for Attio.
-
Query ZendeskSell Data in DataGrip
Create a Data Source for ZendeskSell in DataGrip and use SQL to query live ZendeskSell.
-
Working with SuiteCRM Data in LINQPad
Execute LINQ queries to SuiteCRM in LINQPad.
-
How to Access Paddle Data Using Entity Framework
This article shows how to access Paddle using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate FHIR Data in Pentaho Data Integration
Build ETL pipelines based on FHIR in the Pentaho Data Integration tool.
-
How to Work with Grafana Data in ETL Validator JDBC
Connect to Grafana from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Xero Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Xero Accounting from Node.js.
-
Getting Started with the CData ADO.NET Provider for Parallel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Replicate Google Campaign Manager 360 Data from PowerShell
Write a quick PowerShell script to query Google Campaign Manager 360. Use connectivity to the live data to replicate Google Campaign Manager 360 to SQL Server.
-
Automated ConstantContact Data Replication to Teradata
Use CData Sync to Customize and automate ConstantContact replication to Teradata.
-
Use the CData Software ODBC Driver for REST in MicroStrategy Web
Connect to REST in MicroStrategy Web using the CData Software ODBC Driver for REST.
-
ETL Intercom in Oracle Data Integrator
This article shows how to transfer Intercom into a data warehouse using Oracle Data Integrator.
-
How to Access Live Microsoft Planner Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Planner enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.
-
Explore Geographical Relationships in Amazon DynamoDB Data with Power Map
Create data visualizations with Amazon DynamoDB in Power Map.
-
Connect to Instantly Data in Ruby
Connect to Instantly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Work with Dynamics NAV Data in FoxPro
Load Microsoft Dynamics NAV into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live SAP Hybris C4C Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Hybris C4C through MCP integration.
-
Access Live Perigon Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Perigon in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Reports from Adobe Commerce Data in Looker Studio
Use CData Connect AI to gain access to live Adobe Commerce and create custom reports in Looker Studio.
-
Use CData Connect AI to Access SAP Ariba Source Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Ariba Source in the Power Pivot business intelligence tool.
-
Connect to Wave Financial Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Wave Financial.
-
Consume Vault CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Vault CRM feeds that reflect any changes in SAP Lumira.
-
Integrate Pipeline CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pipeline CRM with External Services.
-
Create Power BI Reports on Real-Time Excel Data
Use the CData ODBC Driver for Excel to visualize Microsoft Excel in Power BI Desktop.
-
DataBind Twitter Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Twitter Ads with the DevExpress Windows Forms and Web controls to provide Twitter Ads to a chart.
-
Connect to Oracle Eloqua Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Eloqua Data and connect to Oracle Eloqua in Akorbi Digital RunMyProcess.
-
Integrating Antigravity CLI with Adobe Target via CData CLI
Connect Adobe Target to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect SharePoint with HubDB Data through external lists
Provide HubDB to SharePoint users as an external list.
-
Connect to Zoho Inventory Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zoho Inventory.
-
Integrate Access Data in the Pentaho Report Designer
Publish reports based on Microsoft Access in the Pentaho BI tool.
-
Connect to Marketo Data in HULFT Integrate
Connect to Marketo as a JDBC data source in HULFT Integrate
-
Integrate Instantly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Instantly with External Services.
-
Integrating OpenCode Terminal with AfterShip 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.
-
Bind Live Google Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Ads data
-
Build Dashboards with Shortcut Data in DBxtra
Create dynamic dashboards and perform analytics based on Shortcut in DBxtra.
-
Viewing Oracle Eloqua Reporting Data in RAD Studio Data Explorer
How to view Oracle Eloqua Reporting in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Eloqua Reporting.
-
Connect to Freshsales Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshsales.
-
Connect to Amazon DynamoDB Data from a Connection Pool in Jetty
The Amazon DynamoDB JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon DynamoDB from Web apps in Jetty.
-
Automate Microsoft Planner Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Planner replication to Couchbase.
-
Connect to OneNote Data in Aqua Data Studio
Access Microsoft OneNote from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Excel Spreadsheet Automation on Exact Online Data with the QUERY Formula
Pull data from Exact Online, automate spreadsheets, and more with the QUERY formula.
-
Access Live FreshBooks Data in AWS Lambda
Connect to live FreshBooks in AWS Lambda using the CData JDBC Driver.
-
Integrating Codex CLI with Guru 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.
-
Integrating Salesforce Pardot Data in Talend Cloud Data Management Platform
Connect Salesforce Pardot Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce Pardot.
-
How to Query ClickUp Data in MySQL Workbench
Execute MySQL queries against live ClickUp from MySQL Workbench.
-
Build Data Flows from SQL Server to Salesloft through SSIS
Easily push SQL Server data to Salesloft using the CData SSIS Tasks for Salesloft.
-
Integrating Dataiku with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Ariba Source.
-
How to connect to AdRoll Data from Spring Boot
Connect to AdRoll in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Live Adobe Analytics Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Analytics in CData Connect AI and connect to your Adobe Analytics from PostgreSQL.
-
Automate Pipeline CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pipeline CRM from PowerShell? This article demonstrates how to utilize the Pipeline CRM Cmdlets for tasks like connecting to Pipeline CRM, automating operations, downloading data, and more.
-
Automated Continuous Google Spanner Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Spanner replication to Oracle.
-
How to Connect DBeaver to Access via a JDBC Driver
Manage Microsoft Access with visual tools in DBeaver like the query browser.
-
Back Up Vimeo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Vimeo data.
-
Connect to eBay from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay to connect to eBay from Web applications running on WebLogic.