CData Software - Knowledge Base
Recent Articles
-
Connect to SAP Hybris C4C Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C and execute queries in PowerBuilder.
-
Connect to and Query MariaDB Data in QlikView over ODBC
Create data visualizations with MariaDB in QlikView.
-
Use the CData Software ODBC Driver for Monday.com in MicroStrategy Desktop
Connect to Monday.com in MicroStrategy Desktop using the CData Software ODBC Driver for Monday.com.
-
Connect to Gmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gmail Data and connect to Gmail in Akorbi Digital RunMyProcess.
-
Build a PostgreSQL Interface for Pipedrive Data using the CData JDBC Driver
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use CData Connect AI to Access JSON Services in Microsoft Power Pivot
Use CData Connect AI to connect to live JSON in the Power Pivot business intelligence tool.
-
How to Connect to Live MYOB AccountRight Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your MYOB AccountRight through natural language.
-
Connect to Coda Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Coda as an External Source in Dremio.
-
Automated Continuous Vault CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vault CRM replication to delimited files (CSV/TSV).
-
Integrating Gumloop with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Marketing Cloud within automated workflows.
-
Create Data Visualizations in Cognos BI with Datadog Data
Access Datadog as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Controls to Xero Data in C++Builder
DataBind to Xero Accounting in C++Builder with standard components and controls.
-
Analyze QuickBooks Time Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Time with the CData JDBC Driver for QuickBooks Time.
-
Getting Started with the CData SSIS Components for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Blackbaud FE NXT.
-
Query Live ADP Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ADP directly from the development environment.
-
Connect to Instantly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instantly to connect to Instantly and execute queries in PowerBuilder.
-
How to Connect to Oracle Eloqua Reporting Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Eloqua Reporting. Leverage the pyodbc module for ODBC in Python.
-
DataBind Controls to Marketo Data in Delphi
DataBind to Marketo in Delphi with standard data access components and controls.
-
How to connect PolyBase to Google Tasks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Tasks.
-
Analyze Notion Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Notion and visualize live Notion in Infragistics Reveal.
-
Create Informatica Mappings From/To an ODBC Data Source for SFTP
Create an ODBC connection to SFTP in Informatica and browse and transfer SFTP.
-
Integrating Wrike Data in Talend Cloud Data Management Platform
Connect Wrike Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Google Ad Manager Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SingleStore.
-
Connect to and Visualize Live Google Ad Manager Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ad Manager.
-
Connect to Foursquare Data from a Connection Pool in Jetty
The Foursquare JDBC Driver supports connection pooling: This article shows how to connect faster to Foursquare from Web apps in Jetty.
-
How to Import Data from Workday into Google Sheets
Import Workday into a Google spreadsheet that is automatically refreshed.
-
How to Connect DBeaver to Paylocity via a JDBC Driver
Manage Paylocity with visual tools in DBeaver like the query browser.
-
Import Zuora Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zuora. In this article, you will use the OData format to import Zuora into Microsoft Power Query.
-
Connect to LinkedIn Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for LinkedIn Ads Data and connect to LinkedIn Ads in Akorbi Digital RunMyProcess.
-
Connect to Shopify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shopify using standard SQL.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Business Cloud Accounting in MicroStrategy Developer using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Integrate Real-Time Access to Smartsheet in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Smartsheet in real time.
-
Getting Started with the CData Excel Add-In for Asana
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Asana.
-
How to publish and share PayPal Data dashboards with Tableau Server
The CData ODBC driver for PayPal enables you integrate PayPal into Tableau dashboards.
-
Query Pinterest Data as a MySQL Database in Node.js
Execute MySQL queries against Pinterest from Node.js.
-
Integrate Stack Exchange Data in the Pentaho Report Designer
Publish reports based on Stack Exchange in the Pentaho BI tool.
-
Build Data Flows from HubDB to SQL Server using SSIS
Easily back up HubDB to SQL Server using the SSIS components for HubDB.
-
Connect to Act-On Data from a Connection Pool in Jetty
The Act-On JDBC Driver supports connection pooling: This article shows how to connect faster to Act-On from Web apps in Jetty.
-
Use JayDeBeApi to access Google Forms Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Forms.
-
Getting Started with the CData Power BI Connector for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Confluence Data from a Connection Pool in JBoss
Integrate Atlassian Confluence into Java servlets: Use the Management Console in JBoss to install the Confluence JDBC Driver.
-
Build Automated Workflows with Live Microsoft Ads Data in Workato
Use CData Connect AI to connect to live Microsoft Ads and build automated workflows in Workato.
-
Build MVC Applications with Connectivity to Odoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Odoo from an ASP.NET MVC application.
-
Access Hive Data from MySQL in Amazon QuickSight
Connect to Hive and build visualizations of Apache Hive using a MySQL Connection in Amazon QuickSight.
-
Easily Integrate Greenplum Data in Lazarus Pascal IDE
Learn how to easily integrate live Pivotal GreenPlum in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Choosing the Best Method to Connect ZohoExpense to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoExpense from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Mailjet Data Replication to Teradata
Use CData Sync to Customize and automate Mailjet replication to Teradata.
-
Migrating data from Square to Snowflake using CData SSIS Components.
Easily push Square to Snowflake using the CData SSIS Tasks for Square and Snowflake.
-
How to Connect Flowise AI Agents to Live Amazon DynamoDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Amazon DynamoDB without replication.
-
How to Connect to Live SAS Data Sets Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAS Data Sets through natural language.
-
Extend Google Sheets with Google Translate Data
Make calls to Google Translate from Google Apps Script via the API Server.
-
Integrate Wrike with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wrike with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wrike.
-
Feed Excel Data into FineReport
How to set Microsoft Excel as a JDBC data source in FineReport.
-
Build a PostgreSQL Interface for Sage Cloud Accounting Data using the CData JDBC Driver
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish ShipEngine-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ShipEngine.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cloudant
Provide connectivity to IBM Cloudant through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with Helpscout Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Helpscout.
-
Analyze SAP Concur Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Concur with the CData JDBC Driver for SAP Concur.
-
Trigger WooCommerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for WooCommerce with standard wizards in Logic Apps.
-
Seamlessly Bring SAP Ariba Source Data into Retool Using CData Connect AI
Integrate SAP Ariba Source data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Model, Search, and Visualize Live Act CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Act CRM for modeling, searching, and visualizing.
-
Automated Continuous HCL Domino Replication to SQL Server
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQL Server.
-
Analyze Opsgenie Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Opsgenie with the CData JDBC Driver for Opsgenie.
-
Create CapsuleCRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CapsuleCRM data access from reports, embedded analytics, and more.
-
How to create Visio diagrams from Databricks Data
Automatically update Databricks with the changes you make to Visio master shapes.
-
Access Recurly Data from MySQL in Amazon QuickSight
Connect to Recurly and build visualizations of Recurly using a MySQL Connection in Amazon QuickSight.
-
Visualize Figshare Data in Tableau
The CData ODBC driver for Figshare enables you integrate Figshare into Tableau dashboards.
-
How to Connect to Typeform Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Typeform. Leverage the pyodbc module for ODBC in Python.
-
Seamlessly Bring Microsoft Entra ID Data into Retool Using CData Connect AI
Integrate Microsoft Entra ID data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Query Live Email Data in Perplexity MacOS Desktop
Connect to and query live Email Data in Perplexity Desktop using CData MCP Server.
-
Automate Teamwork Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamwork from PowerShell? This article demonstrates how to utilize the Teamwork Cmdlets for tasks like connecting to Teamwork, automating operations, downloading data, and more.
-
Analyze FormSite Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of FormSite and visualize live FormSite in Infragistics Reveal.
-
Automate IBM Informix Data Replication to SAP HANA
Use CData Sync to customize and automate IBM Informix replication to SAP HANA.
-
Query Pipeliner CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipeliner CRM.
-
Access Shortcut Data from MySQL in Amazon QuickSight
Connect to Shortcut and build visualizations of Shortcut using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy
Connect to Apache Hive in MicroStrategy Developer using the CData Software JDBC Driver for Hive.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Teamwork to Power BI dashboards. Simply drag and drop Teamwork into data visuals on the Power BI canvas.
-
Replicate LinkedIn Data in Heroku for Use in Salesforce Connect
Replicate LinkedIn to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build an OLAP Cube in SSAS from Campaigner Data
Establish a connection to Campaigner data from SQL Server Analysis Services, and use the Campaigner Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Oracle Financials Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Financials Cloud.
-
Prepare, Blend, and Analyze Oracle Sales Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Sales for self-service data analytics.
-
Create Datasets from RabbitMQ in Domo Workbench and Build Visualizations of RabbitMQ Data in Domo
Use the CData Software ODBC Driver for RabbitMQ to create datasets from RabbitMQ in Domo Workbench and then build visualizations in the Domo service.
-
Natively Connect to Google Sheets Data in PHP
The CData ODBC driver for Google Sheets enables you to create PHP applications with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.
-
Migrating data from AfterShip to Databricks using CData SSIS Components.
Easily push AfterShip to Databricks using the CData SSIS Tasks for AfterShip and Databricks.
-
Use the CData ODBC Driver for SAP Ariba Procurement from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Ariba Procurement in Excel.
-
Automated Continuous Kafka Replication to Vertica
Use CData Sync for automated, continuous, customizable Kafka replication to Vertica.
-
Publish Crystal Reports on SAS Data Sets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAS Data Sets.
-
Extend Google Sheets with Workable Data
Make calls to Workable from Google Apps Script via the API Server.
-
Build Splunk-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Splunk to explore live Splunk Data in GitHub Copilot to assist with building Splunk-powered applications.
-
Publish HubSpot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HubSpot.
-
Automated Continuous Reckon Accounts Hosted Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.
-
How to connect to Exact Online Data with Squirrel SQL client
Connect to Exact Online and execute queries in the Squirrel SQL Client.
-
Build AI/ML Models with Live ConvertKit Data using Dataiku
Connect ConvertKit Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Sage 300 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage 300 replication to SQL Server.
-
Access Recurly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Recurly from your Oracle system.
-
Access Discord 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 Discord.
-
Integrate Microsoft Planner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Planner from Informatica Cloud.
-
Build Data Flows from Xero to SQL Server using SSIS
Easily back up Xero Accounting to SQL Server using the SSIS components for Xero.
-
Publish Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari.
-
Moving Data from Monday.com to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Monday.com data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.