BCP Authentication

You don’t need to pass a dblogin/pass to this procedure.  You can use a trusted connection, which will use the SQL Proxy Account for the process.  This is what the Extractions process, and the import utilities use.  Just pass ‘-T’ as the dblogin parameter value and NULL for the password.  Take a look at AP_CONSTITUENT_IMPORT around line 343 for an example.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
Sent: Thursday, October 20, 2011 1:25 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] BCP Authentication

I'm attempting to create a procedure that makes use of AP_BCP_FILE and wondered if anyone has thoughts on what the best practices are for authenticating using that proc. It takes a db_login and db_password. I suspect hard-coding  a login and pass are probably not best. 

Any thoughts?

thanks,

Brian

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

You don’t need to pass a dblogin/pass to this procedure.  You can use a trusted connection, which will use the SQL Proxy Account for the process.  This is what the Extractions process, and the import utilities use.  Just pass ‘-T’ as the dblogin parameter value and NULL for the password.  Take a look at AP_CONSTITUENT_IMPORT around line 343 for an example.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
Sent: Thursday, October 20, 2011 1:25 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] BCP Authentication

I'm attempting to create a procedure that makes use of AP_BCP_FILE and wondered if anyone has thoughts on what the best practices are for authenticating using that proc. It takes a db_login and db_password. I suspect hard-coding  a login and pass are probably not best. 

Any thoughts?

thanks,

Brian

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!