Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Building Dynamic Web Pages with Sage Intacct Using AngularJS

Create single-page applications with live connectivity to Sage Intacct using the CData API Server.
Automated Continuous Facebook Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Facebook replication to Apache Kafka.
Process & Analyze PingOne in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live PingOne .
Rapidly Develop QuickBooks Time-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
How to Connect DBeaver to Outreach.io via a JDBC Driver

Manage Outreach.io with visual tools in DBeaver like the query browser.
Connect to EventBrite in Google Apps Script via SQL Gateway

Use the ODBC Driver for EventBrite and the SQL Gateway to access Eventbrite from Google Apps Script.
Automated Continuous Calendly Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Calendly replication to Google Cloud SQL.
How to create an RPA flow for Microsoft Planner in UiPath Studio

Use the Microsoft Planner ODBC Driver to create workflows that access real-time Microsoft Planner without any coding.
How to Visualize Oracle Eloqua Data in Python with pandas

Use pandas and other modules to analyze and visualize live Oracle Eloqua in Python.
Integrate with SharePoint in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Microsoft SharePoint in SnapLogic.
Connect to Google Search Results from HeidiSQL

Use CData Connect Cloud to connect to and query live Google Search from HeidiSQL.
Visualize Live Zuora of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Zuora using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Create Reports with IBM Cloud Object Storage in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date IBM Cloud Object Storage.
Operational Reporting on Adobe Analytics from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Adobe Analytics.
Analyze Unbounce with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Unbounce from Power Pivot. You will use the Table Import Wizard to load Unbounce. You can visually build the import query or use any SQL supported by the driver.
LINQ to QuickBooks Online

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 QuickBooks Online Data Provider.
Integrate Google Sheets in the Pentaho Report Designer

Publish reports based on Google Sheets in the Pentaho BI tool.
How to import SQL Server into Apache Solr

Use the CData Software JDBC Driver for SQL Server in Data Import Handler and create an automated import of Microsoft SQL Server to Apache Solr Enterprise Search platform.
How to publish and share Sybase IQ dashboards with Tableau Server

The CData ODBC driver for Sybase IQ enables you integrate Sybase IQ into Tableau dashboards.
Connect to Confluence from a Connection Pool in WebLogic

Use the CData JDBC Driver for Confluence to connect to Atlassian Confluence from Web applications running on WebLogic.
Integrate with live Elasticsearch in Jitterbit

Use CData Connect Cloud to connect to and integrate live Elasticsearch in Jitterbit.
Automate Google Sheets Replication to Azure Synapse

Use CData Sync to customize and automate Google Sheets replication to Azure Synapse.
Access XML 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 XML Files.
Access Live Google Search Results in Google Sheets via Connect Cloud

Use CData Connect Cloud to gain access to live Google Search from your Google Sheets.
Create Dashboards and Visualize Live Google Sheets in Geckoboard

Use CData Connect Cloud to connect to live Google Sheets and create dashboards for real-time monitoring and visualization in Geckoboard.
How to Seamlessly Import Todoist Data into IBM SPSS Modeler

Integrate Todoist data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Connect to Drip from a Connection Pool in Jetty

The Drip JDBC Driver supports connection pooling: This article shows how to connect faster to Drip from Web apps in Jetty.
Visualize Live Exact Online in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Exact Online into custom reports in Power BI.
Feed Salesloft into FineReport

How to set Salesloft as a JDBC data source in FineReport.
Import TaxJar into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access TaxJar. In this article, you will use the OData format to import TaxJar into Microsoft Power Query.
Load Freshdesk to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshdesk to a database.
Create SAP HANA XS Advanced Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web

Connect to Salesforce Pardot in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.
Model, Search, and Visualize Live Dynamics 365 Business Central in ThoughtSpot

Use CData Connect Cloud to connect to live Dynamics 365 Business Central for modeling, searching, and visualizing.
Import GitHub Using Azure Data Factory

Use CData Connect Cloud to connect to GitHub from Azure Data Factory and import live GitHub.
How to update Dynamics CRM from Excel

This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
Build Dashboards with Monday.com in Dundas BI

Create dynamic dashboards and perform analytics based on Monday.com in Dundas BI.
Create WordPress-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to WordPress from OutSystems and build custom enterprise apps using live WordPress.
PowerShell Scripting to Replicate Active Directory to MySQL

Write a simple PowerShell script to replicate Active Directory to a MySQL database.
Automated Continuous LDAP Replication to IBM DB2

Use CData Sync for automated, continuous, customizable LDAP replication to IBM DB2.
Connect to Sage Intacct in RazorSQL

Connect to Sage Intacct from wizards and query Sage Intacct from the GUI in the RazorSQL database management tool.
Create Informatica Mappings From/To an ODBC Data Source for HubDB

Create an ODBC connection to HubDB in Informatica and browse and transfer HubDB.
Access Live Oracle Sales Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Oracle Sales data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Building Dynamic Web Pages with Google Calendar Using AngularJS

Create single-page applications with live connectivity to Google Calendar using the CData API Server.
Launch the CData Connect AMI on Amazon Web Services

Host the Java edition of CData Connect on Amazon Web Services using the CData Connect Amazon Machine Instance.
Connect to Microsoft Planner as an External Source in Dremio

Use the CData JDBC Driver to connect to Microsoft Planner as an External Source in Dremio.
Object-Relational Mapping (ORM) with MongoDB 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 MongoDB into a Java-based ORM framework, Hibernate.
Analyze SAP HANA XS Advanced in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze SAP HANA XS Advanced in Microsoft R Open.
Connect to SAP SuccessFactors as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live SAP SuccessFactors.
Automated Continuous PayPal Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable PayPal replication to Apache Cassandra.
Back Up Splunk to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Splunk. In this article, we will employ an SSIS workflow to populate a database with Splunk data.
Import Real-Time Harvest via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Harvest in ColdFusion.
How to pipe Box to CSV in PowerShell

Use standard PowerShell cmdlets to access Box tables.
Integrate Real-Time Access to Facebook Ads in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook Ads in real time.
Create Data Visualizations in Cognos BI with Salesforce Pardot

Access Salesforce Pardot as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
How to Connect to & Open Salesforce Marketing in Microsoft Excel

This article uses the CData ODBC driver for Salesforce Marketing to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
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.
How to Easily Query SAP SuccessFactors in OpenOffice Base