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

CData Software - Knowledge Base

Recent Articles

How to connect Amazon QuickSight to Zoho Projects

Create a connection to Zoho Projects in CData Connect Cloud and insert Zoho Projects into Amazon QuickSight SPICE to build interactive dashboards.
Automated Continuous Amazon Athena Replication to Vertica

Use CData Sync for automated, continuous, customizable Amazon Athena replication to Vertica.
Access Live Reckon in AWS Lambda

Connect to live Reckon in AWS Lambda using the CData JDBC Driver.
Create SSAS Tabular Models from Cassandra

How to build a SQL Server Analysis Service Tabular Model from Apache Cassandra using CData drivers.
Connect to Presto from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Presto using standard SQL.
How to connect to Redshift in DBVisualizer

Integrate Amazon Redshift with visual data analysis tools and data connection wizards in DBVisualizer
Access MYOB AccountRight from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live MYOB AccountRight from HeidiSQL.
Connect to and Visualize Live Azure Data Catalog in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Catalog.
Create Data Visualizations in Cognos BI with SAP ByDesign

Access SAP Business ByDesign as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
Connect to Bing Search Results from PowerBuilder via JDBC

This article demonstrates how to access Bing Search from PowerBuilder using the Bing Search JDBC Driver.
Add Cloudant to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Cloudant with the Informatica Enterprise Data Catalog to classify and organize data.
Perform Batch Operations with Jira Assets in Apache NiFi

Connect to Jira Assets and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Analyze Sybase IQ with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Sybase IQ from Power Pivot. You will use the Table Import Wizard to load Sybase IQ. You can visually build the import query or use any SQL supported by the driver.
Add SAP Business One to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for SAP Business One with the Informatica Enterprise Data Catalog to classify and organize data.
How to connect to Excel Online from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Excel Online and work with Microsoft Excel Online in Microsoft Excel on Mac OS X.
Create Dynamics 365-Connected Nintex Workflows

Use CData Connect Cloud to connect to Dynamics 365 from Nintex Workflow Cloud and build custom workflows using live Microsoft Dynamics 365.
Create Datasets from Amazon Athena in Domo Workbench and Build Visualizations of Amazon Athena in Domo

Use the CData Software ODBC Driver for Amazon Athena to create datasets from Amazon Athena in Domo Workbench and then build visualizations in the Domo service.
Import Real-Time PingOne via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use PingOne in ColdFusion.
How to Import Data from Tally into Google Sheets

Import Tally ERP into a Google spreadsheet that is automatically refreshed.
Design BIRT Reports on Zoho Creator

Provide current Zoho Creator to your embedded analytics.
Import Real-Time Bitbucket via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Bitbucket in ColdFusion.
Import Real-Time Google Campaign Manager 360 via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Google Campaign Manager 360 in ColdFusion.
Analyze Marketo with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Marketo from Power Pivot. You will use the Table Import Wizard to load Marketo. You can visually build the import query or use any SQL supported by the driver.
Connect and Visualize Live Oracle Data in Databricks Lakehouse Federation with CData Connect Cloud

Use CData Connect Cloud to integrate live Oracle Database into the Databricks platform and create visualization dashboards with real-time Oracle Database.
How to work with Twitter Ads in Apache Spark using SQL

Access and process Twitter Ads in Apache Spark using the CData Software JDBC Driver.
Automate Zoom Replication to Couchbase

Use CData Sync to Customize and automate Zoom replication to Couchbase.
Use the CData API Server in Microsoft Power BI

You can use the CData API Server to feed SAP Hybris C4C to Power BI dashboards. Simply drag and drop SAP Hybris C4C into data visuals on the Power BI canvas.
Build Dashboards with Drip in Dundas BI

Create dynamic dashboards and perform analytics based on Drip in Dundas BI.
Automated Continuous Parquet Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Apache Parquet replication to OneLake in Microsoft Fabric.
Use the CData ODBC Driver for Microsoft Planner from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Microsoft Planner to connect to Microsoft Planner from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Planner in Excel.
Use the CData Software ODBC Driver for Microsoft Project in SAS for Real-Time Reporting and Analytics

Connect to real-time Microsoft Project in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Project.
Build Avalara AvaTax Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Avalara AvaTax and build visualizations in Tableau Cloud.
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Desktop

Connect to Microsoft Teams in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Teams.
Analyze Parquet in R via JDBC

Use standard R functions and the development environment of your choice to analyze Apache Parquet with the CData JDBC Driver for Parquet.
Connect to Slack in Google Apps Script via SQL Gateway

Use the ODBC Driver for Slack and the SQL Gateway to access Slack from Google Apps Script.
Query Active Directory in DataGrip

Create a Data Source for Active Directory in DataGrip and use SQL to query live Active Directory.
Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy Web

Connect to Azure Synapse in MicroStrategy Web using the CData Software ODBC Driver for Azure Synapse.
Build Apps with Live Smaregi in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Smaregi into the Adalo platform and build custom mobile and web applications with real-time Smaregi.
Viewing Azure DevOps in RAD Studio Data Explorer

How to view Azure DevOps in RAD Studio Data Explorer using the CData ODBC Driver for Azure DevOps.
How to pipe SingleStore to CSV in PowerShell

Use standard PowerShell cmdlets to access SingleStore tables.
How to Connect to OData Services in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to OData. Leverage the pyodbc module for ODBC in Python.
Extend Google Sheets with Oracle Sales

Make calls to the API Server from Google Apps Script.
How to Work with Clio in AWS Glue Jobs Using JDBC

Connect to Clio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Analyze GitHub with Power Pivot

This article walks you through the process of using the CData ODBC Driver for GitHub from Power Pivot. You will use the Table Import Wizard to load GitHub. You can visually build the import query or use any SQL supported by the driver.
Choosing the Best Method to Connect Amazon S3 to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Amazon S3 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Import SendGrid Using Azure Data Factory

Use CData Connect Cloud to connect to SendGrid from Azure Data Factory and import live SendGrid.
Edit and Search External Salesforce Pardot Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Salesforce Pardot to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Pardot objects that you can access from apps and the dashboard.
Connect to Oracle Financials Cloud from a Connection Pool in JBoss

Integrate Oracle Financials Cloud into Java servlets: Use the Management Console in JBoss to install the Oracle Financials Cloud JDBC Driver.
Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Procurement

Create an ODBC connection to SAP Ariba Procurement in Informatica and browse and transfer SAP Ariba Procurement.
Build Semantic Layer Views for Zoho Projects in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Zoho Projects.
How to Connect the Power BI Service to Microsoft Project: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Import Real-Time Zenefits via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Zenefits in ColdFusion.
Connect to QuickBooks Time from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Time, and over 250 other data sources, right inside your Excel and Google spreadsheets!
Access Live SAP Ariba Source in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to SAP Ariba Source from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
Automated Continuous Instagram Replication to SQL Server

Use CData Sync for automated, continuous, customizable Instagram replication to SQL Server.
How to use SQLAlchemy ORM to access Smartsheet in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Smartsheet.
Use Dash to Build to Web Apps on Oracle

Create Python applications that use pandas and Dash to build Oracle-connected web apps.
Connect to Printify from a Connection Pool in JBoss

Integrate Printify into Java servlets: Use the Management Console in JBoss to install the Printify JDBC Driver.
Deploy the ADO.NET Provider for Greenhouse on an SSRS Report Server

Connect to Greenhouse 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.
Paylocity Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Paylocity facts in real time.
Connect to SQL Server in Claris FileMaker Pro