CData Software - Knowledge Base
Recent Articles
-
Publish Reports with HelloSign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HelloSign.
-
Create Informatica Mappings From/To a JDBC Data Source for Sybase
Create Sybase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Omnisend in Microsoft Power Query
You can use the CData Omnisend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Omnisend into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time SendGrid Data
Use CData Power BI Connectors to visualize SendGrid in Power BI.
-
Operational Reporting on PolarTeamPro Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PolarTeamPro.
-
View Reports on Real-Time ZohoInvoice Data in Power BI Report Server
Use the CData ODBC Driver for ZohoInvoice to visualize ZohoInvoice in Power BI Desktop and then publish them to Power BI Report Server.
-
Object-Relational Mapping (ORM) with Amazon Marketplace Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon Marketplace into a Java-based ORM framework, Hibernate.
-
Build Semantic Layer Views for DocuSign Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for DocuSign.
-
Automated Continuous AfterShip Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AfterShip replication to Amazon S3.
-
Connect to ServiceDesk Plus Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Stack Exchange 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 Stack Exchange into TIBCO Spotfire.
-
Integrate Okta Data into Power Automate Desktop using CData Connect
CData Connect for Okta Data enables you to integrate Okta into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for LeadDesk Data using the CData ODBC Driver
Use the SQL Gateway and LeadDesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Add Drip Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Drip with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Copper Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Copper from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Amazon DynamoDB.
-
Create Dynamic Close Grids Using the Infragistics XamDataGrid
Learn how you can connect Close to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Quaderno Data in DBxtra
Create dynamic dashboards and perform analytics based on Quaderno in DBxtra.
-
How to Design MailChimp Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to MailChimp from mobile and tablet Power Apps.
-
Trigger Sybase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sybase with standard wizards in Logic Apps.
-
Integrating Gumloop with LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on LinkedIn Ads within automated workflows.
-
Visualize Odoo Data in Sisense
Create an ElastiCube in Sisense app with access to Odoo ERP.
-
Automated Continuous Nethunt Replication to Snowflake
Use CData Sync for automated, continuous, customizable Nethunt replication to Snowflake.
-
How to integrate Cloudflare with Apache Airflow
Access and process Cloudflare in Apache Airflow using the CData JDBC Driver.
-
How to publish and share SAP HANA Data dashboards with Tableau Server
The CData ODBC driver for SAP HANA enables you integrate SAP HANA into Tableau dashboards.
-
Connect to OnePageCrm Data in Jaspersoft Studio
Execute SQL to remote OnePageCrm in Jaspersoft Studio.
-
Import and Visualize Dropbox Data in Power View
Create data visualizations based on Dropbox in Excel.
-
ETL Cassandra in Oracle Data Integrator
This article shows how to transfer Apache Cassandra into a data warehouse using Oracle Data Integrator.
-
Automated Continuous REST Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable REST replication to delimited files (CSV/TSV).
-
Connect to QuickBooks Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for QuickBooks Online to connect to QuickBooks Online and execute queries in PowerBuilder.
-
Analyze Float Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Float in Microsoft R Open.
-
Connect to Foursquare Data in Aqua Data Studio
Access Foursquare from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with Paylocity Data in Dundas BI
Create dynamic dashboards and perform analytics based on Paylocity in Dundas BI.
-
How to Query Live DocuSign Data in Perplexity MacOS Desktop
Connect to and query live DocuSign Data in Perplexity Desktop using CData MCP Server.
-
Integrate Theia IDE with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
DataBind Charts to LinkedIn Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LinkedIn 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.
-
Use the CData Software ODBC Driver for Cloudant in MicroStrategy Web
Connect to IBM Cloudant in MicroStrategy Web using the CData Software ODBC Driver for Cloudant.
-
Integrate Cline with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Presto from within your IDE.
-
Provide OData Services of Twilio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Twilio by developing a WCF Service Application.
-
How to connect to LightSpeedRetail Data with Squirrel SQL client
Connect to LightSpeedRetail and execute queries in the Squirrel SQL Client.
-
Automated Continuous SparkPost Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SparkPost replication to OneLake in Microsoft Fabric.
-
Build a Simple VCL Application for Oracle Eloqua Reporting Data
How to build a simple VCL Application to view Oracle Eloqua Reporting in RAD Studio using the CData ODBC Driver for Oracle Eloqua Reporting.
-
Integrate EnterpriseDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate EnterpriseDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to EnterpriseDB.
-
Query Live HBase 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 Apache HBase directly from the development environment.
-
Automated Continuous Sybase IQ Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sybase IQ replication to delimited files (CSV/TSV).
-
Analyze Hive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hive from Power Pivot. You will use the Table Import Wizard to load Apache Hive. You can visually build the import query or use any SQL supported by the driver.
-
How to Easily Query GitLab Data in OpenOffice Base
Connect to GitLab data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Design BIRT Reports on Rootly Data
Provide current Rootly to your embedded analytics.
-
Integrating Kiro CLI with HelloSign 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.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Business Cloud Accounting in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Replicate HubDB Data in Heroku for Use in Salesforce Connect
Replicate HubDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query HelloSign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against HelloSign from Node.js.
-
RabbitMQ Reporting in OBIEE with the RabbitMQ JDBC Driver
Deploy the RabbitMQ JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect and process SAP Business One from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Business One.
-
Build an OLAP Cube in SSAS from YouTube Analytics Data
Establish a connection to YouTube Analytics data from SQL Server Analysis Services, and use the YouTube Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Samanage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Samanage replication to Amazon S3.
-
Query Drift Data as a MySQL Database in Node.js
Execute MySQL queries against Drift from Node.js.
-
How to Access Live Jodoo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jodoo enables you to integrate Jodoo into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to Discord: Complete Guide
Connect to the CData Software Power BI Connector for Discord from PowerBI.com to provide real-time Discord across the organization.
-
Build Asana-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Asana and build web apps with connectivity to live Asana.
-
How to Build an ETL App for Microsoft Planner Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Planner in Python with petl.
-
A PostgreSQL Interface for Humanity Data using the CData ODBC Driver
Use the SQL Gateway and Humanity ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live Oracle Sales Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Sales.
-
How to use SQLAlchemy ORM to access WooCommerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of WooCommerce.
-
Operational Reporting on Tickspot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tickspot.
-
How to Query Live Adobe Commerce Data in Perplexity MacOS Desktop
Connect to and query live Adobe Commerce Data in Perplexity Desktop using CData MCP Server.
-
How to Easily Query FHIR Data in OpenOffice Base
Connect to FHIR data in OpenOffice Base using the CData ODBC Driver for FHIR and generate reports with live data insights.
-
Build Agents in Relevance AI with Access to Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on FreshBooks within intelligent agent workflows.
-
Access Live Oracle HCM Cloud 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 Oracle HCM Cloud through MCP integration.
-
How to publish and share FreshBooks Data dashboards with Tableau Server
The CData ODBC driver for FreshBooks enables you integrate FreshBooks into Tableau dashboards.
-
Connect to Instantly Data in Aqua Data Studio
Access Instantly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Replicate Multiple Zoho Inventory Accounts
Replicate multiple Zoho Inventory accounts to one or many databases.
-
How to Connect the Power BI Service to Parquet: Complete Guide
Connect to the CData Software Power BI Connector for Parquet from PowerBI.com to provide real-time Apache Parquet across the organization.
-
Explore Geographical Relationships in SAP Fieldglass Data with Power Map
Create data visualizations with SAP Fieldglass in Power Map.
-
Connect to and Visualize Live Codat Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Codat.
-
Use the CData Software ODBC Driver for Pingdom in MicroStrategy Web
Connect to Pingdom in MicroStrategy Web using the CData Software ODBC Driver for Pingdom.
-
Integrating GitHub Copilot CLI with Oracle HCM Cloud 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.
-
Create Dynamic PolarTeamPro Grids Using the Infragistics XamDataGrid
Learn how you can connect PolarTeamPro to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy Web
Connect to Zoho Projects in MicroStrategy Web using the CData Software JDBC Driver for Zoho Projects.
-
Use the CData Software ODBC Driver for ClickTime in SAS for Real-Time Reporting and Analytics
Connect to real-time ClickTime in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ClickTime.
-
Getting Started with the CData ADO.NET Provider for Float
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish Crystal Reports on Brex Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Brex.
-
Trigger Lakebase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Lakebase with standard wizards in Logic Apps.
-
How to publish and share AfterShip Data dashboards with Tableau Server
The CData ODBC driver for AfterShip enables you integrate AfterShip into Tableau dashboards.
-
Automated Continuous Helpscout Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Helpscout replication to OneLake in Microsoft Fabric.
-
Automated Continuous LightSpeedRetail Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Amazon S3.
-
Connect to CampaignMonitor Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CampaignMonitor.
-
Access Live Aha! Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Aha! in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Controls to Adobe Target Data in Delphi
DataBind to Adobe Target in Delphi with standard data access components and controls.
-
Add Drift Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Drift with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bidirectional Access to SAP Business Warehouse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Business Warehouse in Filemaker Pro for Mac or Windows.
-
Vercel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Vercel facts in real time.
-
Prepare, Blend, and Analyze CloudConvert Data in Alteryx Designer (ODBC)
Build workflows to access live CloudConvert for self-service data analytics.
-
Replicate MessageBird Data in Heroku for Use in Salesforce Connect
Replicate MessageBird to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live SAP Netweaver Gateway Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Netweaver Gateway securely in real time.
-
Visualize ServiceNow Data in Tableau
The CData ODBC driver for ServiceNow enables you integrate ServiceNow into Tableau dashboards.
-
Connecting to MongoDB Atlas with MongoDB Drivers
Connect to a MongoDB Atlas instance using any CData Software Driver for MongoDB.
-
Query Amazon Marketplace Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon Marketplace entities in PHP by modeling them as objects.
-
Connect to Calendly from Asprova with CData Software ODBC Driver for Calendly
This article shows how to connect faster to Calendly data from Asprova.
-
Connect to HubSpot Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HubSpot and the Script function in FileMaker Pro to connect to HubSpot and work with HubSpot in your FileMaker application.