Skip to main content
Question

I want to create a connection string from SSRS to Vertica using Datasource

  • February 19, 2020
  • 2 replies
  • 13 views

soumya

Can anyone provide me the connection string for vertica from SSRS, Like Servername =' XXX', Databasename='''';

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • February 19, 2020

You need to do it via User Interface. Please check the below link. Where are you planning to use the SSRS connection string?

https://www.vertica.com/kb/Vertica-QuickStart-for-SSRS/Content/Partner/Vertica-QuickStart-for-SSRS.htm


soumya
  • Author
  • New Participant
  • February 20, 2020

Hi Sruthi
Thanks for the update, I was able to create the SSRS report as you specified, But when i want to deploy the report I want to create a datasource from with in Report Server URL, Driver={Vertica}; Database=XXXX; Servername=XXXXX; UID=XXXX; PWD=<>; PreferredAddressFamily=none; like this not able to do it.