Managing stored procedures - 6.2

Talend Data Fabric Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

An authorized user can also import/export, copy/paste, duplicate and delete stored procedures from Talend Studio.

How to export stored procedures

From Talend Studio you can export one or more stored procedures in order to exchange them between two different MDM Servers or Repositories.

The steps to export one or multiple stored procedures are similar to those for any other data object in the MDM Repository tree view. For detailed information on how to export stored procedures, see How to export data models.

How to import stored procedures

From Talend Studio, you can import stored procedures created on other MDM servers or in different MDM Repositories into the current MDM Repository.

The steps to import one or multiple stored procedures are similar to those for any other data object in the MDM Repository tree view. For detailed information on how to import stored procedures, see How to import data models.

How to edit a stored procedure

You can open a stored procedure you have already created to check its settings and/or edit the defined parameters.

Prerequisite(s): You have already connected to the MDM server from Talend Studio. At least one stored procedure exists.

To edit a stored procedure, do the following:

  1. In the MDM Repository tree view, expand the Stored Procedure node.

  2. Double-click the stored procedure you want to edit and select Edit from the contextual menu.

    An editor opens on the selected stored procedure in the workspace.

  3. Modify the stored procedure settings as required and then click the save icon on the toolbar or press Ctrl + S on your keyboard to save your changes.

The selected stored procedure is modified accordingly.

How to copy/paste a stored procedure

To avoid creating one or multiple stored procedures from scratch, you can copy an existing one in the MDM Repository tree view and modify its settings to have a new procedure.

Prerequisite(s): You have already connected to the MDM server from Talend Studio. At least one stored procedure exists.

To copy/paste a stored procedure, do the following:

  1. In the MDM Repository tree view, expand the Stored Procedure node.

  2. Right-click the procedure you want to duplicate and select Copy from the contextual menu.

  3. Right-click the Stored Procedure node and select Paste from the contextual menu.

    A dialog box displays prompting you to enter a name for the new stored procedure.

  4. Enter a name for the new stored procedure and click OK to validate the changes and close the dialog box.

    The new stored procedure is listed under the Stored Procedure node in the MDM Repository tree view.

How to duplicate a stored procedure

To avoid creating one or multiple stored procedures from scratch, you can duplicate an existing one in the MDM Repository tree view and modify its settings to have a new procedure.

Prerequisite(s): You have already connected to the MDM server from Talend Studio. At least one stored procedure exists.

To duplicate a stored procedure, do the following:

  1. In the MDM Repository tree view, expand the Stored Procedure node.

  2. Right-click the procedure you want to duplicate and select Duplicate from the contextual menu.

    A dialog box displays prompting you to enter a name for the new stored procedure.

  3. Enter a name for the new stored procedure and click OK to validate the changes and close the dialog box.

    The new stored procedure is listed under the Stored Procedure node in the MDM Repository tree view.

Note

You can also duplicate the stored procedure if you drop it onto its parent node in the MDM Repository tree view.

How to delete a stored procedure

You can delete any of the stored procedures you create through a simple right-click on the selected item.

Prerequisite(s): You have already connected to the MDM server from Talend Studio. At least one stored procedure exists.

To delete a stored procedure, do the following:

  1. In the MDM Repository tree view, expand the Stored Procedure node.

  2. Right-click the procedure you want to delete and select Delete from the contextual menu.

    A confirmation dialog box displays prompting you to confirm the deletion operation or to cancel it.

  3. Click OK to close the dialog box.

    The selected stored procedure is deleted from the MDM Repository tree view.