The CData ADO.NET Provider for Google Sheets automates SSRS deployment, adding the report type "CData Google Sheets Report." This section shows the typical deployment flow. See Installed Assemblies for more information on the SSRS assemblies used by the provider.

Deploy to Native-Mode Servers

The provider installation provides an option to automatically deploy the provider on native mode report servers.

Sharepoint-Mode Report Servers

On SharePoint mode report servers, you can run the install-sprs.ps1 PowerShell script. Run the script from the lib subfolder in the installation directory.