User Guide / Deployment to Catalog

Toad Data Studio
1

Hello, I am demoing Toad Data Studio for use with our Oracle Cloud/Fusion ERP system and I am looking for a User Guide, however the link on the Help menu in the application takes me to a bad link that doesnt work. Can someone point me to a user guide?

Also when I was doing the initial setup there was a setup option for something related to Automatic Deployment to the BIP Catalog. I selected this option and noticed that it automatically created a "Quest" folder under my Custom folder in Fusion BIP. I'm curious what this is for and if there is documentation about it's use? Can this deploy/create Data Model and/or Report objects in the catalog?

Thanks,
Kevin

2

Hi Kevin,
Welcome to the user forums.
You're right that the application link for the User Guide is non-operational at the moment and our team is looking into it. For now, I've attached the User Guide here or you can download it from our Technical Documentation page.
ToadDataStudio_2.0_UserGuide.pdf (3.1 MB)

For users to connect to Oracle Fusion app databases, they'll need to deploy reports to BIP first using two different methods: Automatic or Manual deployment. Both performing the same steps. These reports must be created (by Toad or by the user) under the Quest folder placed under the Custom Folder of your PIB. You can find more details in KB article 4377986 or you can refer to the attached document. Toad essentially builds a data model and a data report in BI publisher in order gain access to the data.
Oracle Fusion Security and Deployment Steps.pdf (443.1 KB)

Let us know of any other questions.

3

@Gita.Sharifi Thank you for the information regarding the User Guide and how the deployment works in order to execute queries.

I am trying to run a query that has bind variables (parameters) in it, however I am not getting any kind of dialog box to populate values for the bind variables. The Help section states that the Bind Variables dialog box may need to be enabled but it does not provide any information how to do this. I could not find anything related to Bind Variables within the Options settings. I am attempting to run the below simple query and we are not being prompted for the bind variable.

        SELECT *
        FROM EGP_SYSTEM_ITEMS
        WHERE INVENTORY_ITEM_ID = :p_inv_num

I think our team would also be interested in seeing a live demo of the product where we could ask some additional questions as well. If that is something we could arrange I can provide my contact details.

Thanks,
Kevin