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

CData Software - Knowledge Base

Recent Articles

Build Semantic Layer Views for SurveyMonkey in APOS Live Data Gateway

Use the CData Connector for SurveyMonkey in APOS Live Data Gateway to build Semantic Layer Views for SurveyMonkey.
How to Design Facebook Ads Power Apps with Database-Like Connectivity

This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
MarkLogic: SQL-NOCOLUMN: Column Not Found Error

In this entry you will find information relating to MarkLogic's "SQL-NOCOLUMN" error.
Visualize Live WooCommerce in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live WooCommerce.
Access Live Twitter in Excel 365 Online (Excel for the web)

Connect to Twitter from Excel 365 Online (Excel for the web) with CData Connect Cloud.
How to connect PolyBase to Snowflake

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Snowflake.
Create LinkedIn-Connected Dashboards in Grafana

Connect to LinkedIn via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to LinkedIn.
Working with Redis in LINQPad

Execute LINQ queries to Redis in LINQPad.
Publish Reports with HBase in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Apache HBase.
Analyze Dynamics 365 in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Microsoft Dynamics 365 and visualize Microsoft Dynamics 365 in SAP Analytics Cloud.
Automated Continuous Sybase Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Sybase replication to IBM DB2.
PowerShell Scripting to Replicate SAP HANA XS Advanced to MySQL

Write a simple PowerShell script to replicate SAP HANA XS Advanced to a MySQL database.
Prepare, Blend, and Analyze IBM Informix in Alteryx Designer (ODBC)

Build workflows to access live IBM Informix for self-service data analytics.
Access Excel from MySQL in PHP

Connect to Excel through the standard MySQL libraries in PHP.
Build SAP SuccessFactors-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for SAP SuccessFactors and create custom apps in Mendix.
How to Seamlessly Import Azure Table Data into IBM SPSS Modeler

Integrate Azure Table data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Use the CData Software ODBC Driver for Klaviyo in SAS for Real-Time Reporting and Analytics

Connect to real-time Klaviyo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klaviyo.
Visualize Live Zendesk in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Zendesk into custom reports in Power BI.
Enable the Blackbaud FE NXT JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Blackbaud FE NXT.
Import Real-Time SuiteCRM via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use SuiteCRM in ColdFusion.
Use JayDeBeApi to access Klaviyo in Python

Use standard Python scripting and the development environment of your choice to access live Klaviyo.
Configure the CData JDBC Driver for Jira Service Management in a Connection Pool in Tomcat

Connect to Atlassian Jira Service Management from a connection pool in Tomcat.
DataBind Charts to LinkedIn

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.
How to Create Power BI Visual Reports with Real-Time Sage 50 UK

Use CData Power BI Connectors to visualize Sage 50 UK in Power BI.
Create SSAS Tabular Models from eBay Analytics

How to build a SQL Server Analysis Service Tabular Model from eBay Analytics using CData drivers.
PowerShell Scripting to Replicate Google Drive to MySQL

Write a simple PowerShell script to replicate Google Drive to a MySQL database.
How to Connect to & Open Tableau CRM Analytics in Microsoft Excel

This article uses the CData ODBC driver for Tableau CRM Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
How to connect and process SQL Analysis Services from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Analysis Services.
How to Work with Spark in ETL Validator JDBC

Connect to Spark from ETL Validator jobs using the CData Software JDBC Driver.
How to Design Google Spanner Power Apps with Database-Like Connectivity

This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
Oracle Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Database through CData Connect Cloud using different applications and tools.
Analyze FTP in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze FTP Servers in Microsoft R Open.
Manage SingleStore in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for SingleStore.
Create SAP Ariba Source-Connected Business Apps in AppSheet

Connect to SAP Ariba Source via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to SAP Ariba Source.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HBase

Provide connectivity to Apache HBase through an SAP BusinessObjects universe.
Build a Simple VCL Application for Authorize.Net

How to build a simple VCL Application to view Authorize.Net in RAD Studio using the CData ODBC Driver for Authorize.Net.
Use Biml to Build SSIS Tasks to Replicate Klaviyo to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Klaviyo to SQL Server.
Automated Continuous Highrise Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Highrise replication to PostgreSQL.
Extend Google Sheets with Amazon DynamoDB

Make calls to the API Server from Google Apps Script.
Automated Continuous Zuora Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Zuora replication to PostgreSQL.
Start and Stop Windows Services Using the CData Excel Add-In for PowerShell

Share and organize scripts, start and stop services, and create system reports from within Excel.
Use the CData Software JDBC Driver for Teradata in MicroStrategy Desktop

Connect to Teradata in MicroStrategy Desktop using the CData Software JDBC Driver for Teradata.
Visualize SQL Analysis Services in Tableau

The CData ODBC driver for SQL Analysis Services enables you integrate SQL Analysis Services into Tableau dashboards.
Automated Continuous Vault CRM Replication to MySQL

Use CData Sync for automated, continuous, customizable Vault CRM replication to MySQL.
Create Workday-Connected Applications in Appsmith

Connect to Workday via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Workday.
Build a Simple VCL Application for OneNote

How to build a simple VCL Application to view Microsoft OneNote in RAD Studio using the CData ODBC Driver for OneNote.
Visualize Oracle in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Database into TIBCO Spotfire.
Connect to Certinia from a Connection Pool in Jetty

The Certinia JDBC Driver supports connection pooling: This article shows how to connect faster to Certinia from Web apps in Jetty.
Connect to SAP Ariba Procurement in Claris FileMaker Pro