SQL Table Editor Example

The following use case describes how to send a query after establishing a connection.

  1. Go to Application > Presentation > Workspaces > [choose Workspace] > [ Maintenance Unit] > [choose Maintenance Unit] > Components > SQL Table Editor.

  2. Create Dashboard Component or open a SQL Table Editor.

  3. Choose SQL Table Editor and select OK.

  4. Verify the following:

    • Database Location is External,

    • External Database Connection is the custom connection that you defined earlier,

    • Table Name is defined as the table you want to return data from.

  5. Open the associated dashboard and run the query. The OneStream Smart Integration Connector will connect to the external database. If it connects correctly, the query will populate.

NOTE: If you plan on modifying data with SQL Table Editor using Smart Integration Connector, then you will need to write back data with a custom business rule using the Execute Dashboard Extender Business Rule feature under the Save Data Server Task action.