CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with DB2 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 IBM DB2 into a Java-based ORM framework, Hibernate.
-
Building Dynamic Web Pages with SAP ByDesign Using AngularJS
Create single-page applications with live connectivity to SAP ByDesign using the CData API Server.
-
Consume Salesforce OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce & Force.com as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Zoom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoom replication to MongoDB.
-
How to Build an ETL App for Harvest in Python with CData
Create ETL applications and real-time data pipelines for Harvest in Python with petl.
-
Visualize Google Spanner in TIBCO Spotfire through ADO.NET
Integrate Google Spanner into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Directory Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Directory replication to OneLake in Microsoft Fabric.
-
How to Connect to Oracle SCM in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle SCM. Leverage the pyodbc module for ODBC in Python.
-
Connect and Visualize Live FHIR Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FHIR into the Databricks platform and create visualization dashboards with real-time FHIR.
-
Use the CData Software JDBC Driver for Oracle SCM in MicroStrategy Desktop
Connect to Oracle SCM in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle SCM.
-
Visualize Act CRM in TIBCO Spotfire through OData
Integrate Act CRM into dashboards in TIBCO Spotfire.
-
Configure the CData JDBC Driver for Todoist in a Connection Pool in Tomcat
Connect to Todoist from a connection pool in Tomcat.
-
How to create Visio diagrams from Dropbox
Automatically update Dropbox with the changes you make to Visio master shapes.
-
Deploy the ADO.NET Provider for WooCommerce on an SSRS Report Server
Connect to WooCommerce 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.
-
Connect to Google Contacts from a Connection Pool in Jetty
The Google Contacts JDBC Driver supports connection pooling: This article shows how to connect faster to Google Contacts from Web apps in Jetty.
-
Use the CData API Server to Access Wave Financial in Microsoft PowerPivot
Use the CData API Server to connect to live Wave Financial in the Power Pivot business intelligence tool.
-
Integrate Amazon Marketplace in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Marketplace from Informatica Cloud.
-
Stream Basecamp into Apache Kafka Topics
Access and stream Basecamp in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software ODBC Driver for PayPal in MicroStrategy
Connect to PayPal in MicroStrategy Developer using the CData Software ODBC Driver for PayPal.
-
Access Live Trello in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Trello from your Excel spreadsheets.
-
Connect to Clio in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clio and the SQL Gateway to access Clio from Google Apps Script.
-
Add BigCommerce to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for BigCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Biml to Build SSIS Tasks to Replicate Salesloft to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesloft to SQL Server.
-
DataBind Controls to Drift in Delphi
DataBind to Drift in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Box in MicroStrategy Web
Connect to Box in MicroStrategy Web using the CData Software ODBC Driver for Box.
-
Publish Google Directory-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Directory.
-
Create a Data Access Object for Excel Online using JDBI
A brief overview of creating a SQL Object API for Microsoft Excel Online in JDBI.
-
Integrate Live Stripe into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Stripe and integrate live Stripe into apps built in Microsoft Power Apps.
-
Connecting Moonlit Workflow with SAP Hybris C4C via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Hybris C4C in real time.
-
Connect to Snowflake from PowerBuilder via ADO.NET
This article demonstrates how to access Snowflake from Appeon PowerBuilder using the CData ADO.NET Provider for Snowflake.
-
View Reports on Real-Time MariaDB in Power BI Report Server
Use the CData ODBC Driver for MariaDB to visualize MariaDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Hive
Create an ODBC connection to Hive in Informatica and browse and transfer Apache Hive.
-
Provide OData Services of DB2 from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM DB2 by developing a WCF Service Application.
-
Viewing Greenplum in RAD Studio Data Explorer
How to view Pivotal GreenPlum in RAD Studio Data Explorer using the CData ODBC Driver for Greenplum.
-
Automated Continuous Google Campaign Manager 360 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Azure SQL Database.
-
Build an OLAP Cube in SSAS from SAP BusinessObjects BI
Establish a connection to SAP BusinessObjects BI data from SQL Server Analysis Services, and use the SAP BusinessObjects BI Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating LangChain with Zoho Books via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Books within automated workflows.
-
How to Query Live CSV in Perplexity MacOS Desktop
Connect to and query live CSV in Perplexity Desktop using the CData MCP Server.
-
Connect to SAP Business One in DBeaver
Use the CData ODBC Driver to connect to SAP Business One in DBeaver.
-
Connect to Oracle Financials Cloud in CloverDX (formerly CloverETL)
Transfer Oracle Financials Cloud using the visual workflow in the CloverDX data integration tool.
-
Access Live Sage 200 in AWS Lambda
Connect to live Sage 200 in AWS Lambda using the CData JDBC Driver.
-
Configure the CData JDBC Driver for HDFS in a Connection Pool in Tomcat
Connect to Apache HDFS from a connection pool in Tomcat.
-
Access Live Office 365 in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Office 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Office 365 in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for REST
Complete guide to installing, licensing, and connecting with the CData SSIS Components for REST.
-
How to publish and share Microsoft Dataverse dashboards with Tableau Server
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse (CDS) into Tableau dashboards.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy Web
Connect to SAP Hybris C4C in MicroStrategy Web using the CData Software JDBC Driver for SAP Hybris C4C.
-
How to publish and share WordPress dashboards with Tableau Server
The CData ODBC driver for WordPress enables you integrate WordPress into Tableau dashboards.
-
Using the CData Software ODBC Driver for Sage 200 in PyCharm
Connect to Sage 200 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 200.
-
Connect Parquet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Parquet using the CData Python MCP Server.
-
Access Live Amazon S3 in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon S3 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Creating YouTube Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed YouTube Analytics to Unqork and build custom business apps.
-
Automated Wave Financial Replication to Teradata
Use CData Sync to Customize and automate Wave Financial replication to Teradata.
-
Seamlessly Bring OneNote into Retool Using CData Connect AI
Integrate OneNote data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Data Visualizations in Cognos BI with SendGrid
Access SendGrid as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Gmail from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Gmail for you.
-
ETL Google Directory in Oracle Data Integrator
This article shows how to transfer Google Directory into a data warehouse using Oracle Data Integrator.
-
Integrate Real-Time Access to PostgreSQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PostgreSQL in real time.
-
Integrate Cursor with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live DocuSign from within the editor.
-
Analyze Snapchat Ads in Looker
Use CData Connect AI to connect to Snapchat Ads from Looker and build custom apps using live Snapchat Ads.
-
Create Data Visualizations in Cognos BI with Snapchat Ads
Access Snapchat Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Hive from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Hive to connect to Apache Hive and execute queries in PowerBuilder.
-
Feed Highrise into FineReport
How to set Highrise CRM as a JDBC data source in FineReport.
-
Analyze Splunk in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Splunk and visualize live Splunk in Infragistics Reveal.
-
Create Dynamic Raisers Edge NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Raisers Edge NXT to Infragistics XamDataGrid to build dynamic grids.
-
Connect to QuickBooks in SpagoBI
Create reports featuring live QuickBooks Desktop in SpagoBI Studio. Host QuickBooks reports on SpagoBI Server.
-
How to Query Live Acumatica in Perplexity MacOS Desktop
Connect to and query live Acumatica in Perplexity Desktop using the CData MCP Server.
-
Query Vault CRM using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Vault CRM entities in PHP by modeling them as objects.
-
Query Certinia in ColdFusion
Write standard ColdFusion data access code to connect to Certinia.
-
Configure the CData JDBC Driver for Exact Online in a Connection Pool in Tomcat
Connect to Exact Online from a connection pool in Tomcat.
-
LINQ to Box
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 Box Data Provider.
-
Shopify Reporting in OBIEE with the Shopify JDBC Driver
Deploy the Shopify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Stream Microsoft OneDrive into Apache Kafka Topics
Access and stream Microsoft OneDrive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Access OData Services Using Entity Framework
This article shows how to access OData using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Real-Time Adobe Analytics Data in Power Apps Using Dataflows to Build Custom Applications
-