Monday, March 12, 2012

Getting password from another source!

I am using a shared data source to access a Teradata machine but the password
I need to use is generated elsewhere in a component and changed regularly.
Is there a way I can get the shared data source to grab the current password
from the component on the fly?Interesting. Every now and then I come across a question that leaves me
baffled for a while. The guy who implemented this must have been really
influenced by trustworthy computing :-) I am just curious how will the data
source be synchronized with the new password.
Well, you can't change the connection string during runtime which limits (at
least as far as I can tell) your choices to:
1. If that component raises an event or if you have other means to know when
the password is going to be changed you can write a simple app to update the
shared data source definition programmatically.
2. Wrap this data source in a custom data extension.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:EF4BC011-4E6B-4E84-B54A-339B27C7DB0D@.microsoft.com...
> I am using a shared data source to access a Teradata machine but the
password
> I need to use is generated elsewhere in a component and changed regularly.
> Is there a way I can get the shared data source to grab the current
password
> from the component on the fly?|||Look at SetDataSourceContents SOAP API.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:75326DAC-383F-42E5-A5B9-27D8DBA9F8E5@.microsoft.com...
> I can get the password change to trigger an event no problem so option 1
> looks good but I can't find any syntax on updating the shared data source
> definition programmatically.
> Thanks for your help!
> "Teo Lachev" wrote:
> > Interesting. Every now and then I come across a question that leaves me
> > baffled for a while. The guy who implemented this must have been really
> > influenced by trustworthy computing :-) I am just curious how will the
data
> > source be synchronized with the new password.
> >
> > Well, you can't change the connection string during runtime which limits
(at
> > least as far as I can tell) your choices to:
> >
> > 1. If that component raises an event or if you have other means to know
when
> > the password is going to be changed you can write a simple app to update
the
> > shared data source definition programmatically.
> >
> > 2. Wrap this data source in a custom data extension.
> >
> > --
> > Hope this helps.
> >
> > ----
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ----
> >
> > "St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
> > news:EF4BC011-4E6B-4E84-B54A-339B27C7DB0D@.microsoft.com...
> > > I am using a shared data source to access a Teradata machine but the
> > password
> > > I need to use is generated elsewhere in a component and changed
regularly.
> > > Is there a way I can get the shared data source to grab the current
> > password
> > > from the component on the fly?
> >
> >
> >|||Thanks for that!
"Teo Lachev" wrote:
> Look at SetDataSourceContents SOAP API.
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
> news:75326DAC-383F-42E5-A5B9-27D8DBA9F8E5@.microsoft.com...
> > I can get the password change to trigger an event no problem so option 1
> > looks good but I can't find any syntax on updating the shared data source
> > definition programmatically.
> >
> > Thanks for your help!
> >
> > "Teo Lachev" wrote:
> >
> > > Interesting. Every now and then I come across a question that leaves me
> > > baffled for a while. The guy who implemented this must have been really
> > > influenced by trustworthy computing :-) I am just curious how will the
> data
> > > source be synchronized with the new password.
> > >
> > > Well, you can't change the connection string during runtime which limits
> (at
> > > least as far as I can tell) your choices to:
> > >
> > > 1. If that component raises an event or if you have other means to know
> when
> > > the password is going to be changed you can write a simple app to update
> the
> > > shared data source definition programmatically.
> > >
> > > 2. Wrap this data source in a custom data extension.
> > >
> > > --
> > > Hope this helps.
> > >
> > > ----
> > > Teo Lachev, MCSD, MCT
> > > Author: "Microsoft Reporting Services in Action"
> > > Publisher website: http://www.manning.com/lachev
> > > Buy it from Amazon.com: http://shrinkster.com/eq
> > > Home page and blog: http://www.prologika.com/
> > > ----
> > >
> > > "St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
> > > news:EF4BC011-4E6B-4E84-B54A-339B27C7DB0D@.microsoft.com...
> > > > I am using a shared data source to access a Teradata machine but the
> > > password
> > > > I need to use is generated elsewhere in a component and changed
> regularly.
> > > > Is there a way I can get the shared data source to grab the current
> > > password
> > > > from the component on the fly?
> > >
> > >
> > >
>
>

No comments:

Post a Comment