This DNAapp is a useful utility which transforms an Excel spreadsheet into a dynamic report containing real-time information from DNA. It can be used to query DNA for account balances, loan amounts and tax owner information among other things. Excel Data Extractor empowers the end user to customize the output using a variety of pre-defined queries without having to know Structured Query Language and without ever having to leave DNA.
During installation a table is created to store the queries that can be used to populate a worksheet with data. Each query defines a default batch size and total batch size indicating the number of input records that can be processed during each interval of the extraction as well as the total number of input records that can be processed at a given time. These values can be updated by a database administrator as needed based on the performance needs of each Financial Institution.
Write Your Own Review
Only registered users can write reviews. Please, log in