Modify an SAP HANA connection

Learn how to modify an SAP HANA connection and its tables.

You can modify an Embrace SAP HANA connection in the following ways:

  • Edit a connection: to add or remove tables and columns

  • Remap a connection: to map a table or column to a different table or column

  • Remove a column

  • Delete a table

  • Delete a connection

Editing an SAP HANA connection

You can edit an SAP HANA connection to add tables and columns.

To edit an SAP HANA connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab.

  3. Click the name of the connection you want to edit.

    Select a connection to edit
  4. Click Edit connection at the upper-right-hand side of the page.

    Edit connection
  5. On the Choose connection type page, change the connection name or description (if needed), and then click Continue.

  6. On the SAP HANA connection details page, make any changes needed, and then click Continue.

  7. Expand the database table drop-down menu, and select the tables and columns you want to add.

    Select tables and columns

  8. Click Update, and then click Confirm to save the updated connection detail.

To remove a table from a connection, delete it from the connection details page. For more information, see Deleting a table.

Remapping an SAP HANA connection

Modify the connection parameters by editing the source mapping yaml file that was created when you added the connection. For example, you can remap the existing table or column to a different table or column in an existing database connection. ThoughtSpot recommends that you check the dependencies before and after you remap a table or column in a connection to ensure they display as intended.

To remap an SAP HANA connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab.

  3. Click the name of the connection you want to remap.

  4. Click the More icon more options menu icon and select Remapping on the upper-right-hand side of the page.

    Remap a connection
  5. Click Download to download the source mapping file.

    Download the source mapping file
  6. Edit the file, as required, and save it.

  7. On the Remapping page, click Browse your files, and upload your edited mapping file to update the mapping of your connection.

Removing a column from an SAP HANA connection

You can edit an SAP HANA connection to remove a column.

To remove a column from an SAP HANA connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab.

  3. Click the name of the connection that contains the column you want to remove.

  4. Click Edit connection at the upper-right-hand side of the page.

  5. In the Select tables page, click the Selected tab.

  6. Click the name of the table that contains the column you want to remove.

    Select table that contains the column
  7. In the list of columns at the right, uncheck the column you want to remove.

  8. Click Update.

    The Update connection message appears, summarizing the changes that will be made to the connection.

  9. Confirm your changes, by clicking Confirm.

Deleting a table from an SAP HANA connection

ThoughtSpot checks for dependencies whenever you try to remove a table in a connection. ThoughtSpot shows a list of dependent objects, and you can click them to delete them or remove the dependency. Then you can remove the table.

To delete a table from an SAP HANA connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab.

  3. Click the name of the connection that contains the table you want to delete.

  4. Find the table you want to delete in the list, and check the box next to its name.

  5. Click Delete, and then click Delete again to confirm.

    Delete a connection table

    If you attempt to delete a table with dependent objects, the operation is blocked. A Cannot delete window appears, with a list of links to dependent objects. See Deleting a table with dependent objects.

Deleting a table with dependent objects

  • In the Cannot delete window, click the link for each object to modify or delete it.

    When all dependencies are removed, you can delete the table.

    embrace delete table depend

You can also click the name of a table and then click the linked objects to see a list of dependent objects with links. The list shows the names of the dependent objects (worksheets, pinboards or answers), and the columns they use from that table. You can use this information to determine the impact of changing the structure of the data source or to see how widely used it is. Click a dependent object to modify or delete it.

Deleting an SAP HANA connection

A connection can be used in multiple data sources or visualizations. Because of this, you must delete all of the sources and tasks that use that connection, before you can delete the connection.

To delete an SAP HANA connection:

  1. Click Data in the top navigation bar.

  2. Click the Connections tab.

  3. Check the box next to the connection you want to delete.

  4. Click Delete, and then click Delete again to confirm.

    If you attempt to delete a connection with dependent objects, the operation is blocked, and a "Cannot delete" warning appears with a list of dependent objects with links.

    connection delete warning
  5. If the "Cannot delete" warning appears, click the link for each object to delete it, and then click Ok. Otherwise, go to the next step.

  6. When all its dependencies are removed, delete the connection by clicking Delete, and then click Delete again to confirm.