Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bulk Insert of user ID's using a script of VB...??? 1

Status
Not open for further replies.

WildWest

Programmer
Apr 2, 2002
111
US
Does anyone know how I can do a bulk insert of user ID's into Cognos using a script or (preferrably) VB???

I want to be able to query a table from a relational database and then do a insert into the Cognos console for each record from the raltional DB.

Thanks in advance.
 
You can either format the query to output a file in a format that is AccessManager Batch Maintenance (Cognos utility that can bulk load users)ready. Or, you can use the API and programatically load the users using a series of loops. There are examples in the Cognos Script Editor help section.

Flex
 
Thanks Flex13. I don't have the Script Editor Help file. Could you please post some example scripts for me? Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top