Micro Focus QTP (UFT) Forums
QTP Database automation - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: QTP Database automation (/Thread-QTP-Database-automation)



QTP Database automation - nexabi - 08-25-2008

We are trying to find a solution for our customer, the requirements are:

1- Can connect to database (Oracle)
2- Open a file using ftp
3- Execute select statements
4- Compare data values in database and text file
5- Generate a report about the resuts


Using QTP VBScripting can we implement a solution for our customer? This script will be executed every week, and read parameters from DB and using these parameters will execute a data comparison scenario using database and files.


Thanks


RE: QTP Database automation - somisays - 08-25-2008

Hi,
Read the following post..
https://www.learnqtp.com/forums/Thread-QTP-Database-conenction-and-parameterization-of-the-values