I need to create a report that management can use, that compares server data in another database, to server information in Commvault.
Unfortunately, I can’t get access to the other database, and need to run a report against it, and save the results into a tab delimited file.
Using this, I have the SQL set up to bulk insert the data into a temp table, and do what I need to get information from CV, based on that data. Runs fine.
However, when I try to paste it into a dataset in a report, and “Preview” the data, prior to saving, I’m told that I don’t have permissions to bulk insert.
It appears to be a jdbc error, so I’m assuming they are running java in the background. I can find what I need to add to a java connection, to allow bulk insert. However, I have no access to the background java.
Does anyone know of a way to allow bulk insert in a web console report?