Connecting Using Basic Authentication

You can use basic authentication such as your user name and password to connect to your business process from Oracle Smart View for Google Workspace.

  1. Sign in to Google Sheets using your Google Workspace credentials and open a new spreadsheet
  2. In the Extensions menu, select Smart View for Google Workspace, and then select Connect under Start.
    Displays the navigation to the Connect menu which is part of the Smart View for Google Workspace menu under Extensions
  3. In the Connect dialog, enter the Server URL of your business process and then enter your user name and password in the User and Password fields.
    Displays the Connect dialog with basic authentication of user name and password.
  4. Click Connect.

    Once connected, the Launch Home button appears in the Connect dialog. You are now connected to your business process from Google Sheets.

    • If you want to only establish the connection to your data source, you can click Close to close the Connect dialog. This is helpful when you are working with multiple data sources and want to keep active connections ready before setting a specific one for your sheet.
    • If you want to launch the Smart View Home panel and access the library of you data source, proceed with step 5.
  5. Click Launch Home to open the Smart View Home panel.
    Displays the Launch Home button in the Connect dialog after the connection is successful.

    In the Smart View Home panel, you can view the library and work on forms and ad hoc grids present in the business application.


    Displays the Smart View Home panel containing various forms and ad hoc grids

    Note:

    When trying to open the Home panel, if you get an error message stating "Administrator has not enabled Google Sheets support for this instance", then you cannot use Smart View in Google Sheets, even though you have installed the extension and connected to your business process.

    As a prerequisite, your Service Administrator needs to enable the Smart View Extension for Google Sheets in the web application settings for every business process that you want to connect through Smart View in Google Sheets. For more information, see Enabling the Smart View Extension for Google Sheets in Getting Started with Oracle Smart View for Google Workspace.