Forum Discussion
Gateway connection setup
I did not see a similar post so I thought I would post this. I am taking over the management of a dataset within a specific workspace in my organization. I am having trouble setting up the connection to some of our data sources and wondering if this is something that someone who could "walk me through" this? I have looked at the documentation for this and it appears to be too generic for my purposes.
Where I am running into trouble is taking over a dataset such as “BP Data Compliance - Missing Premium Detail” dataset in the “Benefits Services Business Process” workspace in my organization. In the Gateway connection, it looks like this:
I have blurred out the emails for security purposes but mine is in there. If I click on “Add to gateway”, I see the following:
I don’t know what credentials to put here. If I put my own, they will expire, so I don’t think I use my own. Are my DBAs supposed to provide me with the credentials? I hope everyone can see what is in the two graphics I pasted in here. If not let me know and I'll add the verbiage some other way.
Hi dfox09
When connecting to SQL Server you will need to put in either Windows Credentials or Basic Credentials (Which will be a SQL Username and Password supplied by your DBA which can query the underlying tables)