New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
How to Read Encrypted Data from SQL DB?

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to Read Encrypted Data from SQL DB?
lagunascorpio Offline
Junior Member
**
Posts: 3
Threads: 2
Joined: May 2012
Reputation: 0
#1
Not Solved 05-31-2012, 01:24 AM (This post was last modified: 05-31-2012, 01:25 AM by lagunascorpio.)
I'm evaluating QTP 11. If our SQL Server database has encrypted fields for SSN, credit card, etc... what's the best way to read that data for data-driven tests?

From my earliest research... one way would be to create a .NET DLL with a method capable of connecting to SQL Server, querying & decrypting the data, then returning it to QTP in real time.

Can this be done using Visual Studio 2010? I followed a simple example I found online and it didn't work.
Find
Reply


Messages In This Thread
How to Read Encrypted Data from SQL DB? - by lagunascorpio - 05-31-2012, 01:24 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,173 07-10-2017, 04:20 PM
Last Post: rajeevk7
  Exe invoked through UFT is unable to access IIS and SQL Server service bkdevise 0 1,977 08-25-2015, 05:49 PM
Last Post: bkdevise
  parameterize Excel Sheet Name in SQL bjitsidhu 0 2,740 07-20-2014, 08:34 AM
Last Post: bjitsidhu
  Is there a possible way to execute sql in QTP using 'WITH' clause shruthic 0 2,994 04-26-2014, 11:42 PM
Last Post: shruthic
  Getting ODBC error while executing the sql query in excel(DB) Shkumari 5 4,624 05-10-2013, 06:15 PM
Last Post: Shkumari

Forum Jump:


Users browsing this thread: 1 Guest(s)