Saturday, 11 March 2017

SSIS support for AX OData connection

With prior versions of SSIS, the you couldn’t save online authentication with OData connections. If you wanted to use it, you had to wrap the messages using c# code. Now with the latest SQL 2016 update there was a nice feature that sneaked under the radar.

The OData Connection Manager now supports five modes of authentication.

  • Windows Authentication

  • Basic Authentication (with username and password)

  • Microsoft Dynamics AX Online (with username and password)

  • Microsoft Dynamics CRM Online (with username and password)

  • Microsoft Online Services (with username and password)

Read more here on msdn https://msdn.microsoft.com/library/dn584133.aspx

This is what the interface looks like.

image

It will pop up with the sign in and will save it.

image

This is a very exciting release.

2 comments:

oracle fusion said...

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. Your write up is a fine example of it.For more details about oracle fusion financial please check our website.

Oracle Fusion Financial Training Institute

Bogdan Vaciu said...

Hey man,

I'm trying yo use this feature and I run into a problem.
The OData Source shows on preview but at the run-time, the validation fails.
Have you used this feature end to end?

10x,
Bogdan