The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
I want to create a connection string from SSRS to Vertica using Datasource

Can anyone provide me the connection string for vertica from SSRS, Like Servername =' XXX', Databasename='''';
Tagged:
0
Best Answer
-
soumya Vertica Customer
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.0
Answers
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