Home Analytics

Adding a Data Source (DWDataMart)

Karen_Bruster1Karen_Bruster1 Member IT Monkey ✭

I need to add the SCSM DWDataMart database to Cireson for some reports. I am trying to get the full Incident classification hierarchy.

This is what I am using to make the connection but I think I am missing something.

Data Source=servername;Initial Catalog=DWDataMart;Integrated Security=SSPI;

My question is for servername do you put the host name and then the instance or just the instance?

Karen

Best Answer

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    The same string you use to connect via SSMS. 
    So you can use the direct server name or the instance or the cluster name. However your environment is setup.
  • Karen_Bruster1Karen_Bruster1 Member IT Monkey ✭
    @Brian_Wiest Is there a way to test it? When  I select it as the source in the SQL Chart it will not let me save the SQL Script.
  • Karen_Bruster1Karen_Bruster1 Member IT Monkey ✭
    @Brian_Wiest Thank you, that gave me the information I needed and it now lets me create my SQL scripts against the DWDataMart.
Sign In or Register to comment.