QTP Database automation

[nexabi]

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