1. Knowledge base
  2. Using Warewolf
  3. Artículos

Using Stored Procedures

To create a Connector to a database stored procedure so that it can be consumed inside a service:

  1. Click the database icon
    Image 48
  2. Select a Source from the drop down list or click New to create a new one.
    1. If you are creating a New connection, enter the database server URL / IP address / computer name in the Server input box. NOTE: A port can be specified by typing a , and the port number e.g. mysqlserver, 1189. If no port is specified Warewolf will use the default SQL Server port of 1433.
    2. Select either Windows or User authentication.
      1. If you selected User authentication, provide your credentials.
    3. The Test Connection button should be enabled, click it.
    4. If your connection is valid, select the Database you want to use from the drop down list. This database will be the source that you have created.
    5. Click Save Connection.
  3. Select an action from the list available by clicking on it. You can click the link under Provide Test Values to see the TSQL of the function or stored procedure.
  4. If inputs are required, insert them. This step enables Warewolf to get an idea of what data will be returned from the connector so the output maps can be built. The execution happens in a transaction that is not committed so this data will not enter your database.
  5. Click Test.
  6. In Defaults and Mapping, enter any default values you want to use as inputs. These will be used at run time if no data is mapped in or the mapped in data is empty.
  7. If a field is required for execution, select Required Field.
  8. To pass Null when the value is empty, select Empty is Null.
  9. To rename the output fields that will be seen, simply put the name you would like in the input box next to the name you do not like.
  10. To not return a particular field, simply remove its name. It will not be mapped out.
  11. By default the results will be put into a recordset that has the name of the procedure or function being used. You can change this to a more suitable / manageable name if require in the Recordset Name field.
  12. Click OK.
  13. Save your Connector.
  14. Locate the connector you created in the Explorer window and drag it onto a service to use it.
Artículo anterior: Using External Web Services
Siguiente artículo: Versioning of Resources

Este artículo fué útil para 1 persona. ¿Le resulta útil este artículo?

Servicio de atención al cliente por UserEcho