Highlighted
Absent Member.
Absent Member.
609 views

Insert bulk data into Oracle database using LoadRunner without UI

Hi

We have a situation here that we need to insert bulk data into Oracle database using LoadRunner without using User Interface. Actually what happens when a user use the UI and enter the data & related information it will be converted into SQL statements and stored into multiple tables in database. SQL statements will be generated depends on the business logic/rule at App Server. My question is can we trace and record those SQL queries using LoadRunner and reply them to insert directly into database same type of data in bulk ( for ex: same type applications with unique application #) by bypassing the app server in other words without UI?

Thanks in advance!!
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

Re: Insert bulk data into Oracle database using LoadRunner without UI

Do this. Use web service protocol and enter the SQL query if you know to insert the data.

Webservice protocol can do this.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.