How to connect to grafana

 mesverrum  Has a great post here: (+) Connecting to the SWIS API with Grafana - DevOps Forum - DevOps Discourse - THWACK . This may not be your exact situation but may be helpful. 

I'll also mention that the Grafana PDC doesn't have to be on the same box, it can be set up to essentially act as a proxy within your environment so it can reach anything that the server you run the PDC on can reach.  Directly connecting your dashboards to the DB is not recommended for a variety of reasons so you should use the SWIS API on your main Orion app server as described in the article.

taht assumes grafana can access the solarwinds API no ?  my sw isnt publically available. 

No,  the pdc software is the a proxy between the grafana cloud and your internal environments.  This is how basically all grafana cloud customers use it.

I must not be very smart. YOURSERVER:17774/.../Query this string for health checks fails no matter if i do 17774 or 17778. however the pdc metric log indicates success 

im consistently seeing this type of error in grafana 

error while performing the infinity query. requested URL is not allowed. To allow this URL, update the datasource config Security -> Allowed Hosts section
(Trace ID: 0270a3d37b52b3ba334187140078d4ca)

ive tried all flavors of this url  below. ensuring that in the authentication tab has it on the allowed hosts, the security tab has it on the allowed hosts, and the health check tab has this explicitly YOURSERVER:17774/.../Query

When i click to save and test, it says successful. However im trying to build a dashboard per your instructions. and no matter what query i have selected from your github pags.. i always get the error above. 

on the dashbaord page  i am selecting URL and backend but it fails no mater what. so i tried all the URLS below as a test and they fail. 

https://YOURSERVER:17774/SolarWinds/InformationService/v3/Json/Query 

https://YOURSERVER:17774/

https://YOURSERVER:17774/SolarWinds/InformationService/v3/Json/Query?

In the dashboard itself you don't have to specify a URL, that part was a bit confusing for me the first time. Basically you are already inheriting the base url from the data source config, and since pretty much all operations we would use for a dashboard are aimed at the same url i just leave it blank.  I expect you are getting complaints about an invalid url when you do the dashboard because it sounds like stacking the same info on both parts.

url set inside the data source, i also set this exact same one in my allowed hosts section.

myserver:17774/SolarWinds/InformationService/v3/Json/Query

for my health check i do

myserver:17774/SolarWinds/InformationService/v3/Json/Query?query=SELECT+TOP+1+Uri+FROM+Orion.Pollers

url left bank inside my dashboard panel and the query passed into the key:value params

thanks ill try again tomorrow

ok 2 things i missed.. i didnt set the base URL to begin with when settting up the infinity conneciton so now i ste that, i must have overlooked that.. but for me.. no matter which one of your swql scripts i paste in the value field for a dashboard i get a 400 error