Forum Discussion
Consolidate OData data source authentication within Data Gateway
As tends to the be the case whenever I post a query up here, I've managed to solve it myself a matter of minutes later!
Unfortunately this solution requires me to go through and amend all the dataflows, but it'll be worth it in the long-run.
When you set up an OData feed to Dynamics, you're best using the base URI first. So where I had previously entered http://servername:8048/NAV2017/OData/Company('companyname1')/BI_GeneralLedgerEntries, I simply enter http://servername:8048/NAV2017/OData/.
You can then use a couple navigation steps to filter down to 'Company' and then the specific OData feed. Setting it up this way means the credentials are stored purely at the base URI level, and so only one 'Data Source' will show under 'Manage Gateways' (in my case it uses the one I tried to set up previously).
Navigation Step 1 - Select CompanyNagivation Step 2 - Select the data feed (the rows show the various different companies)
As tends to the be the case whenever I post a query up here, I've managed to solve it myself a matter of minutes later!
Unfortunately this solution requires me to go through and amend all the dataflows, but it'll be worth it in the long-run.
When you set up an OData feed to Dynamics, you're best using the base URI first. So where I had previously entered http://servername:8048/NAV2017/OData/Company('companyname1')/BI_GeneralLedgerEntries, I simply enter http://servername:8048/NAV2017/OData/.
You can then use a couple navigation steps to filter down to 'Company' and then the specific OData feed. Setting it up this way means the credentials are stored purely at the base URI level, and so only one 'Data Source' will show under 'Manage Gateways' (in my case it uses the one I tried to set up previously).
Navigation Step 1 - Select CompanyNagivation Step 2 - Select the data feed (the rows show the various different companies)
Hi Anonymous ,
Thanks for sharing.
Please consider accepting your own answer as a solution, it will help others to find it more quickly, thanks in advance.
Best Regards,
Community Support Team_Gao