Has anyone used KeePass / KeeForm in a SSIS package? If so, I'd like to pick your brain for ideas, pitfalls, etc. I'm starting a project to automate a process that involves signing on to clients' servers using the data stored in KeePass. Looking for any input, advice, even derision at my naivety. Thanks.
Are you asking about SQL Server Integration Services?
How do you expect / hope this will work?
I apologize, I should have been more clear.
Yes, I'm referring to SQL Server Integration Services (SSIS). I know that a SSIS package can be built to connect to a remote server (been there, done that). My issue arises when retrieving the login information (user id, password). Currently, we store all of the login information to our clients servers in KeePass. I don't particularly want to keep a separate copy of this data in a SQL database - that would defeat the purpose of using KeePass in the first place. However, I don't know how to access KeePass data from a SSIS package.
Hmmm, on second thought, my question is more appropriately phrased as: how do I access KeePass data programmatically (C#, .NET, whatever)? I should do some more research.
Assuming that you are using KeePass 2.x, it is a .NET program and has plugin support, so it is pretty easy to extend. If KeePass is running on the same machine as your SQL server, you could write your own plugin so that the two can communicate.
There is also KPscript.
Thanks, guys. I will experiment with both suggestions. I appreciate the timely feedback - most helpful.
Log in to post a comment.