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
-
How to Work with SAP Ariba Source in ETL Validator JDBC
Connect to SAP Ariba Source from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Charts to OData Services
Use the standard ADO.NET procedures for databinding to provide bidirectional access to OData 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.
-
Prepare, Blend, and Analyze Excel Online in Alteryx Designer
Build workflows to access live Microsoft Excel Online for self-service data analytics.
-
Automated Continuous Exact Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.
-
Access Office 365 from MySQL in PHP
Connect to Office 365 through the standard MySQL libraries in PHP.
-
How to load Sage Cloud Accounting data into Elasticsearch via Logstash
Introducing a simple method to load Sage Cloud Accounting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to Klipfolio
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klipfolio from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for Jira Assets in MicroStrategy Desktop
Connect to Jira Assets in MicroStrategy Desktop using the CData Software JDBC Driver for Jira Assets.
-
How to import Act CRM into Apache Solr
Use the CData Software JDBC Driver for Act CRM in Data Import Handler and create an automated import of Act CRM to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for xBase in APOS Live Data Gateway
Use the CData Connector for xBase in APOS Live Data Gateway to build Semantic Layer Views for xBase.
-
Design BIRT Reports on Kafka
Provide current Apache Kafka to your embedded analytics.
-
Query DocuSign in MySQL Workbench
Create a virtual MySQL database for DocuSign in CData Software Connect (or Connect Server) and work with live DocuSign in MySQL Workbench.
-
SQL Analysis Services Reporting in OBIEE with the SQL Analysis Services JDBC Driver
Deploy the SQL Analysis Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Bullhorn CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MongoDB.
-
Connect to FHIR in SpagoBI
Create reports featuring live FHIR in SpagoBI Studio. Host FHIR reports on SpagoBI Server.
-
How to work with Redis in Apache Spark using SQL
Access and process Redis in Apache Spark using the CData Software JDBC Driver.
-
Connect to Oracle Sales in DBeaver
Use the CData ODBC Driver to connect to Oracle Sales in DBeaver.
-
Query Presto as a MySQL Database in Node.js
Execute MySQL queries against Presto from Node.js.
-
How to Access Live Wave Financial in Power Automate Desktop via ODBC
The CData ODBC Driver for Wave Financial enables you to integrate Wave Financial into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for LinkedIn in MicroStrategy Desktop
Connect to LinkedIn in MicroStrategy Desktop using the CData Software ODBC Driver for LinkedIn.
-
Create Reports from IBM Informix in Looker Studio
Use CData Connect Cloud to gain access to live IBM Informix and create custom reports in Looker Studio.
-
Create SSAS Tabular Models from BambooHR
How to build a SQL Server Analysis Service Tabular Model from BambooHR using CData drivers.
-
Viewing OneNote in RAD Studio Data Explorer
How to view Microsoft OneNote in RAD Studio Data Explorer using the CData ODBC Driver for OneNote.
-
CData AWS Glue Connector for Salesforce Deployment Guide
A detailed deployment and usage guide for the CData AWS Glue Connector for Salesforce
-
Connect to Access in Google Apps Script
Use the ODBC Driver for Access and the SQL Gateway to access Microsoft Access from Google Apps Script.
-
Analyze Email in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of Email and visualize live Email in Ingragistics Reveal.
-
Connect to Reckon as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy Web
Connect to Pinterest in MicroStrategy Web using the CData Software JDBC Driver for Pinterest.
-
Integrate Real-Time Access to FTP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to FTP Servers in real time.
-
Integrate with Live eBay in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to eBay from the MuleSoft Anypoint Platform to integrate live eBay into custom reports and dashboards.
-
Object-Relational Mapping (ORM) with Cloudant 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 Cloudant into a Java-based ORM framework, Hibernate.
-
Automated Continuous Avalara AvaTax Replication to Vertica
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Vertica.
-
Query SQL Analysis Services as a SQL Server in Node.js
Execute SQL Server queries against SQL Analysis Services from Node.js.
-
Object-Relational Mapping (ORM) with Impala 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 Apache Impala into a Java-based ORM framework, Hibernate.
-
Build IBM Informix-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to IBM Informix from Zoho Analytics and import live IBM Informix.
-
Deploy the ADO.NET Provider for Excel on an SSRS Report Server
Connect to Microsoft Excel 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.
-
Build a Simple VCL Application for Bitbucket
How to build a simple VCL Application to view Bitbucket in RAD Studio using the CData ODBC Driver for Bitbucket.
-
Feed RSS Feeds into FineReport
How to set RSS Feeds as a JDBC data source in FineReport.
-
Create a Data Access Object for Quickbase using JDBI
A brief overview of creating a SQL Object API for Quickbase in JDBI.
-
ETL Greenhouse in Oracle Data Integrator
This article shows how to transfer Greenhouse into a data warehouse using Oracle Data Integrator.
-
Connect to HubDB in HULFT Integrate
Connect to HubDB as a JDBC data source in HULFT Integrate
-
Analyze Odoo in R
Create data visualizations and use high-performance statistical functions to analyze Odoo ERP in Microsoft R Open.
-
How to Create Power BI Visual Reports with Real-Time SAP HANA
Use CData Power BI Connectors to visualize SAP HANA in Power BI.
-
Using AngularJS to Build Dynamic Web Pages with Google Spanner
Use the CData Connect Server to create Google Spanner OData feeds and build single-page applications with live Google Spanner.
-
Connect to Live Zoho Inventory in MicroStrategy through CData Connect Cloud
Create a live connection to Zoho Inventory in CData Connect Cloud and connect to your Zoho Inventory from MicroStrategy.
-
Add Todoist to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Todoist with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Salesforce Pardot from PowerBuilder
This article demonstrates how to access Salesforce Pardot from PowerBuilder using the Salesforce Pardot JDBC Driver.
-
Create Snapchat Ads-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Snapchat Ads from OutSystems and build custom enterprise apps using live Snapchat Ads.
-
How to Query Live PayPal Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PayPal data in natural language using Python.
-
How to update Smartsheet from Excel
This article explains how to transfer data from Excel to Smartsheet using the Excel Add-In for Smartsheet.
-
Connect to Sage Cloud Accounting as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Sage Business Cloud Accounting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Unbounce
Provide connectivity to Unbounce through an SAP BusinessObjects universe.
-
Publish Crystal Reports on MariaDB
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MariaDB.
-
Visualize Live YouTube Analytics in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live YouTube Analytics into custom reports in Power BI.
-
Automated Continuous Raisers Edge NXT Replication to SQLite
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SQLite.
-
Automated NetSuite Replication to Teradata
Use CData Sync to Customize and automate NetSuite CRM & ERP replication to Teradata.
-
Create Zuora Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Zuora to build custom dashboards in Bold BI.
-
Visualize Authorize.Net in Tableau
The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net into Tableau dashboards.
-
Automated Continuous TaxJar Replication to Azure SQL
Use CData Sync for automated, continuous, customizable TaxJar replication to Azure SQL.
-
How to Build an ETL App for Tally in Python with CData
Create ETL applications and real-time data pipelines for Tally ERP in Python with petl.
-
Integrate Real-Time Access to Pinterest in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pinterest in real time.
-
Query Procore through ODBC in Node.js
Use node-odbc to execute SQL queries against Procore from Node.js.
-
Connect to Google Search Results as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Google Search.
-
BigQuery Reporting in OBIEE with the BigQuery JDBC Driver
Deploy the BigQuery JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous WordPress Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable WordPress replication to PostgreSQL.
-
Publish Reports with SAP Concur in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Concur.
-
How to Access Twilio Using Entity Framework
This article shows how to access Twilio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Model, Search, and Visualize Live Azure Active Directory in ThoughtSpot
Use CData Connect Cloud to connect to live Azure Active Directory for modeling, searching, and visualizing.
-
A PostgreSQL Interface for IBM Cloud Data Engine
Use the Remoting features of the IBM Cloud Data Engine JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share QuickBooks dashboards with Tableau Server
The CData ODBC driver for QuickBooks enables you integrate QuickBooks Desktop into Tableau dashboards.
-
Automated Continuous Salesforce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce replication to MongoDB.
-
Visualize SAP Hybris C4C in Tableau
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.
-
Query Microsoft Teams as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Teams from Node.js.
-
Connect to Google Cloud Storage in DBArtisan
Use wizards in DBArtisan to configure Google Cloud Storage as a data source.
-
Integrate Sybase into Automated Tasks with Power Automate
Use CData Software Connect Server to create a virtual SQL Server database for Sybase and integrate live Sybase into your Power Automate (Microsoft Flow) tasks.
-
Publish Parquet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Parquet.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Desktop
Connect to xBase in MicroStrategy Desktop using the CData Software JDBC Driver for xBase.
-
How to Create Power BI Visual Reports with Real-Time Azure DevOps
Use CData Power BI Connectors to visualize Azure DevOps in Power BI.
-
Model Stripe Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Stripe, enabling the direct import of real-time Stripe.
-
Create Impala-Connected Nintex Workflows
Use CData Connect Cloud to connect to Impala from Nintex Workflow Cloud and build custom workflows using live Apache Impala.
-
Build an OLAP Cube in SSAS from ClickUp
Establish a connection to ClickUp data from SQL Server Analysis Services, and use the ClickUp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate xBase Replication to Azure Synapse
Use CData Sync to customize and automate xBase replication to Azure Synapse.
-
Use CData Connect Cloud to Access Facebook in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Facebook in the Power Pivot business intelligence tool.
-
Configure the CData JDBC Driver for Dynamics 365 Business Central in a Connection Pool in Tomcat
Connect to Dynamics 365 Business Central from a connection pool in Tomcat.
-
Automated Continuous Cloudant Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cloudant replication to IBM DB2.
-
Access Live Cosmos DB in Excel 365 Online (Excel for the web)
Connect to Azure Cosmos DB from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Import and Visualize Tableau CRM Analytics in Power View
Create data visualizations based on Tableau CRM Analytics in Excel.
-
Validate Oracle Financials Cloud with QuerySurge
Access and validate Oracle Financials Cloud in QuerySurge using the CData JDBC Driver.
-
Access SAP Ariba Procurement from MySQL in Amazon QuickSight
Connect to SAP Ariba Procurement and build visualizations of SAP Ariba Procurement using a MySQL Connection in Amazon QuickSight.
-
A PostgreSQL Interface for Dynamics 365
Use the Remoting features of the Dynamics 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from Dynamics 365 Business Central
How to build a SQL Server Analysis Service Tabular Model from Dynamics 365 Business Central using CData drivers.
-
Automate Avro Replication to Couchbase
Use CData Sync to Customize and automate Apache Avro replication to Couchbase.
-
Bridge eBay Analytics Connectivity with Apache NiFi
Access and process eBay Analytics in Apache NiFi using the CData JDBC Driver.
-
Connect to PayPal in Aqua Data Studio
Access PayPal from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Edit and Search External Pipedrive Objects in Salesforce Connect
Use CData Connect Server to securely provide OData feeds of Pipedrive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Pipedrive objects that you can access from apps and the dashboard.
-
Create a Data Access Object for Clio using JDBI
A brief overview of creating a SQL Object API for Clio in JDBI.
-
Connect to Calendly in Ruby
Connect to Calendly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to use SQLAlchemy ORM to access Azure Analysis Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Analysis Services.
-
Automated Continuous QuickBooks Time Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to MongoDB.
-
Use JayDeBeApi to access SurveyMonkey in Python
Use standard Python scripting and the development environment of your choice to access live SurveyMonkey.