Workflow Tutorial: Monitoring Database Values
How many times have you asked yourself, "What is going on with my data?" OK, maybe not too often, but you do need to keep track of that pesky data in your database. This tutorial will show you how to keep an eye on things. Get out your No. 2 pencil and prepare to begin.
Prerequisites: A pre-existing SQL database.
Objective: To learn how to use the Embedded Monitoring Model component.
Estimated time to complete: 30 minutes
Step 1: Create a new Monitoring Project
To begin, open the project which will be deployed to your local hard drive:
Step 2: Click on the Import Components button in the Toolbox. Then click Create Integration Library and name the library 'MonitorDatabaseValues'. Click OK.
Step 3: The Dynamic Type Creation Selection window will appear and the user will select the SQL Script Generator
Step 4: Click OK and a Wizardform will appear for the SQL Script Generator. In the Select Provider window, select SQL Server Provider. Then, input the user's connection string and hit the Test Connection button. If it is a valid connection to the database, an Works! box will appear click OK:
Then enter a SQL query in the box as shown below and click Next:
Step 5: The Fields box will appear. Check the Returns Data box and hit Fill Schema. Then, click Next:
Step 6: In the Components box, click Finish and click OK twice to return to the main project model.
Step 7: Drag and drop the Embedded Monitoring Model Component from the Monitoring tree in the Components toolbox and connect the components as shown below:
Step 8: Click on Input Data and set the Name as 'name', Type as EntityObject and check Array, as shown below:
Step 9: Double-click the Embedded Monitoring Model Component. An editor will appear, click the ... button to the right of Embedded Model:
Step 10: In the Edit Embedded Decision Model window, drag and drop a GetEntities component from the Sql Queries component toolbox, connect them as shown below and double-click the GetEntities component:
Step 11: Select the Ouput tab from the GetEntities Editor, click the ... button to the right of Result Variable Name and select 'name'. Then click OK three times:
Step 12: Click the Output tab of the Embedded Monitoring Model Component Editor and enter 'RetValue' in the Result Variable Name box:
Step 13: Run the project by selecting the Run project button on the toolbar. This button appears as a bug with a green arrow over it.
To complete running the project, double-click on the blue Begin link and set the input values as shown below:
Step 14: When the project is complete, the following window will appear:
Step 15: Finished!