Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Visualize Live OData Services in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OData.
-
Automate Zoho Books Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Books from PowerShell? This article demonstrates how to utilize the Zoho Books Cmdlets for tasks like connecting to Zoho Books, automating operations, downloading data, and more.
-
Create a Data Access Object for ShipStation using JDBI
A brief overview of creating a SQL Object API for ShipStation in JDBI.
-
Analyze Live Zoho Creator in SAS Viya
Use CData Connect Cloud to connect to Zoho Creator from SAS Viya and deploy self-service analytics using live Zoho Creator.
-
Build Semantic Layer Views for Highrise in APOS Live Data Gateway
Use the CData Connector for Highrise in APOS Live Data Gateway to build Semantic Layer Views for Highrise CRM.
-
Build Automated SharePoint-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Microsoft SharePoint and build automated workflows in Zapier.
-
Automated Continuous SAP HANA XS Advanced Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQL Server.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy
Connect to GitHub in MicroStrategy Developer using the CData Software ODBC Driver for GitHub.
-
How to Work with Microsoft OneDrive in AWS Glue Jobs Using JDBC
Connect to Microsoft OneDrive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect PolyBase to IBM Cloud Object Storage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloud Object Storage.
-
Create a Data Access Object for SAP Ariba Source using JDBI
A brief overview of creating a SQL Object API for SAP Ariba Source in JDBI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Fieldglass
Provide connectivity to SAP Fieldglass through an SAP BusinessObjects universe.
-
Build Stripe-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stripe and build web apps with connectivity to live Stripe.
-
Creating MYOB AccountRight-Connected Applications in Unqork
You can use CData Connect Cloud to feed MYOB AccountRight to Unqork and build custom business apps.
-
Build Snapchat Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Snapchat Ads.
-
Import Real-Time Sage Cloud Accounting in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
-
Automated Continuous Coinbase Replication to Azure SQL
Use CData Sync for automated, continuous, customizable Coinbase replication to Azure SQL.
-
How to Access Live Snowflake in Power Automate Desktop via ODBC
The CData ODBC Driver for Snowflake enables you to integrate Snowflake into workflows built using Microsoft Power Automate Desktop.
-
Extract, Transform, and Load Pipedrive in Informatica PowerCenter
Create a simple Workflow for Pipedrive in Informatica PowerCenter.
-
Publish Bing Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bing Ads.
-
DataBind Controls to EnterpriseDB in C++Builder
DataBind to EnterpriseDB in C++Builder with standard components and controls.
-
Query, Visualize, and Share live Power BI XMLA in Redash
Use CData Connect Cloud to connect to live Power BI XMLA in Redash for querying, visualizing, and sharing.
-
Create Facebook Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Apps from Dynamics GP in Qlik Sense Cloud
Use the CData Connect Server to create an OData API for Microsoft Dynamics GP and build apps from live Microsoft Dynamics GP in Qlik Sense Cloud.
-
Build Interactive Dashboards from SFTP in Amazon QuickSight
Create a virtual SQL Server database for SFTP in CData Software Connect Server and import SFTP into Amazon QuickSight SPICE to build interactive dashboards.
-
Perform Batch Operations with Azure Synapse in Apache NiFi
Connect to Azure Synapse and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for Zuora on an SSRS Report Server
Connect to Zuora 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 WordPress from Asprova with CData Software ODBC Driver for WordPress
This article shows how to connect faster to WordPress data from Asprova.
-
Prepare, Blend, and Analyze Azure Active Directory in Alteryx Designer
Build workflows to access live Azure Active Directory for self-service data analytics.
-
View Reports on Real-Time SAP Fieldglass in Power BI Report Server
Use the CData ODBC Driver for SAP Fieldglass to visualize SAP Fieldglass in Power BI Desktop and then publish them to Power BI Report Server.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrate Sage Intacct into Power Automate Desktop using CData Connect
CData Connect for Sage Intacct enables you to integrate Sage Intacct into workflows built using Microsoft Power Automate Desktop.
-
Creating Amazon DynamoDB-Connected Applications in Unqork
You can use CData Connect Cloud to feed Amazon DynamoDB to Unqork and build custom business apps.
-
Integrate Zoho Creator into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Zoho Creator and integrate live Zoho Creator into your Power Automate tasks.
-
Query Klipfolio through ODBC in Node.js
Use node-odbc to execute SQL queries against Klipfolio from Node.js.
-
How to Access MariaDB Using Entity Framework
This article shows how to access MariaDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query SAP BusinessObjects BI as a MySQL Database in Node.js
Execute MySQL queries against SAP BusinessObjects BI from Node.js.
-
Build PayPal-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PayPal.
-
Use the CData Software ODBC Driver for Databricks in SAS for Real-Time Reporting and Analytics
Connect to real-time Databricks in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Databricks.
-
Enable the Excel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Excel.
-
Automated Continuous Jira Service Management Replication to Vertica
Use CData Sync for automated, continuous, customizable Jira Service Management replication to Vertica.
-
Publish Crystal Reports on MYOB AccountRight
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MYOB AccountRight.
-
Access Box from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Box from HeidiSQL.
-
Create Data Visualizations Based On Adobe Commerce in Mode
Use CData Connect Cloud to connect to Adobe Commerce from Mode and build visualizations using live
-
How to connect to Jira from Spring Boot
Connect to Jira in a Spring Boot Application using CData JDBC Jira Driver
-
Object-Relational Mapping (ORM) with Oracle HCM Cloud 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 Oracle HCM Cloud into a Java-based ORM framework, Hibernate.
-
Build Semantic Layer Views for MongoDB in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for MongoDB.
-
Natively Connect to Adobe Analytics in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Analytics. Leverage the native support for ODBC in PHP.
-
Enable the LinkedIn JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LinkedIn.
-
How to use SQLAlchemy ORM to access REST in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of REST.
-
Connect to Jira Service Management in Aqua Data Studio
Access Atlassian Jira Service Management from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with Acumatica in DBxtra
Create dynamic dashboards and perform analytics based on Acumatica ERP in DBxtra.
-
Access Xero from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Xero Accounting from HeidiSQL.
-
Automated Continuous Cloudant Replication to SQLite
Use CData Sync for automated, continuous, customizable Cloudant replication to SQLite.
-
Build Dashboards with Snapchat Ads in DBxtra
Create dynamic dashboards and perform analytics based on Snapchat Ads in DBxtra.
-
Create Dynamic SAP Concur Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Concur to Infragistics XamDataGrid to build dynamic grids.
-
Import Azure Synapse into FileMaker Pro
Create reports that integrate Azure Synapse in Filemaker Pro.
-
Prepare, Blend, and Analyze Google Contacts in Alteryx Designer
Build workflows to access live Google Contacts for self-service data analytics.
-
Create Exact Online-Connected Business Apps in AppSheet
Connect to Exact Online via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Exact Online.
-
How to Import ConstantContact into SQL Server using SSIS
Easily back up ConstantContact to SQL Server using the SSIS components for ConstantContact.
-
Automate Amazon Marketplace Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon Marketplace replication to Azure Data Lake.
-
Bridge ServiceNow Connectivity with Apache NiFi
Access and process ServiceNow in Apache NiFi using the CData JDBC Driver.
-
Operational Reporting on Trello from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Trello.
-
Access Live Microsoft Dataverse in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Microsoft Dataverse to create a Microsoft Dataverse (CDS) source in TIBCO Data Virtualization Studio and gain access to live Microsoft Dataverse (CDS) from your TDV Server.
-
How to Work with eBay Analytics in AWS Glue Jobs Using JDBC
Connect to eBay Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to integrate Metabase with Azure Synapse
Use CData Connect Cloud to connect to live Azure Synapse and create an interactive dashboard in Metabase from Azure Synapse.
-
Integrate Odoo into Power Automate Desktop using CData Connect
CData Connect for Odoo enables you to integrate Odoo ERP into workflows built using Microsoft Power Automate Desktop.
-
Import Redis Using Azure Data Factory
Use CData Connect Cloud to connect to Redis from Azure Data Factory and import live Redis.
-
Connect to Microsoft Planner as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Microsoft Planner.
-
Access Live SuiteCRM in AWS Lambda
Connect to live SuiteCRM in AWS Lambda using the CData JDBC Driver.
-
DataBind Dropbox to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Dropbox with the DevExpress Windows Forms and Web controls to provide Dropbox to a chart.
-
Access Odoo as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Odoo ERP from your Oracle system.
-
Visualize BambooHR in Sisense
Create an ElastiCube in Sisense app with access to BambooHR.
-
Integrate with ClickUp using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ClickUp to a JSON file on disk.
-
How to Work with SAS xpt in ETL Validator JDBC
Connect to SAS xpt from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for Aha in Microsoft Power Query
You can use the CData Aha ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Aha! into Microsoft Power Query.
-
Viewing HubDB in RAD Studio Data Explorer
How to view HubDB in RAD Studio Data Explorer using the CData ODBC Driver for HubDB.
-
Analyze Bing Search Results in Looker
Use CData Connect Cloud to connect to Bing Search Results from Looker and build custom apps using live Bing Search.
-
Integrate Microsoft Planner into Power Automate Desktop using CData Connect
CData Connect for Microsoft Planner enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.
-
Connect to JDBC-ODBC Bridge from a Connection Pool in WebLogic
Use the CData JDBC Driver for JDBC-ODBC Bridge to connect to JDBC-ODBC Bridge from Web applications running on WebLogic.
-
Build an OLAP Cube in SSAS from Coinbase
Establish a connection to Coinbase data from SQL Server Analysis Services, and use the Coinbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Clio as a SQL Server in Node.js
Execute SQL Server queries against Clio from Node.js.
-
How to Build Dynamic React Apps with Epicor Kinetic
Use the CData Connect and React to Build Dynamic Web Apps with Live Epicor Kinetic .
-
A PostgreSQL Interface for Workday
Use the SQL Gateway and Workday ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Microsoft Planner Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Instagram Replication to Azure Data Lake
Use CData Sync to customize and automate Instagram replication to Azure Data Lake.
-
Object-Relational Mapping (ORM) with Salesforce Marketing 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 Salesforce Marketing Cloud into a Java-based ORM framework, Hibernate.
-
Analyze Sage 50 UK in R
Create data visualizations and use high-performance statistical functions to analyze Sage 50 UK in Microsoft R Open.
-
Viewing Smartsheet in RAD Studio Data Explorer
How to view Smartsheet in RAD Studio Data Explorer using the CData ODBC Driver for Smartsheet.
-
How to Import PayPal into SQL Server using SSIS
Easily back up PayPal to SQL Server using the SSIS components for PayPal.
-
Import Real-Time SingleStore in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SingleStore in ColdFusion.
-
Query SAP Fieldglass through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Fieldglass from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay Analytics
Create an ODBC connection to eBay Analytics in Informatica and browse and transfer eBay Analytics.
-
How to connect to Splunk from IntelliJ
Integrate connectivity to Splunk with wizards in IntelliJ.
-
Access Live BigCommerce in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for BigCommerce to create a BigCommerce source in TIBCO Data Virtualization Studio and gain access to live BigCommerce from your TDV Server.
-
Integrate Real-Time Access to Email in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Email in real time.
-
How to Build an ETL App for Azure DevOps in Python with CData
Create ETL applications and real-time data pipelines for Azure DevOps in Python with petl.
-
Automated Continuous Salesforce Marketing Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to PostgreSQL.
-
How to Build Dynamic React Apps with TaxJar
Use the CData Connect and React to Build Dynamic Web Apps with Live TaxJar .
-
Visualize Harvest in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for Harvest in CData Software Connect (or Connect Server) and build visualizations from live Harvest in Tableau Desktop.