Learn more
 

CData Software - Knowledge Base

Recent Redshift Excel Articles

Automated Continuous SharePoint Excel Services Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon Redshift.

Use the CData ODBC Driver for Redshift from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Amazon Redshift from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Redshift in Excel.

Work with Live Redshift in Power Query

Use CData Connect Cloud to connect to Amazon Redshift and work with live Amazon Redshift in Microsoft Power Query.

How to connect to Redshift from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Redshift and work with Amazon Redshift in Microsoft Excel on Mac OS X.

Import and Visualize Redshift in Power View

Create data visualizations based on Amazon Redshift in Excel.

Author and Share Power BI Reports on Real-Time Redshift

Use the CData ODBC Driver for Redshift to visualize Amazon Redshift in Power BI Desktop and then upload to the Power BI service.

Automated Continuous Excel Online Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Excel Online replication to Amazon Redshift.

Access Live Redshift in Excel (Desktop)

Use CData Connect Cloud to gain access to live Amazon Redshift from your Excel spreadsheets.

Access Live Redshift in Excel 365 Online (Excel for the web)

Connect to Amazon Redshift from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.