Step 1. In the Main Window:

Click New Profile in the File menu. This will bring up the Add / Edit Profile Window.

Step 2. Create Your New Profile:

In the Add / Edit Profile Window for your profile you can make changes to your profile.

Section 1 (Empty)

In Section 1 you can see the Key File Folder you have entered in your Global Settings. Your job in this section is to select your API Key File. To do this you just click the open file button () and select which API Key File you wish to use. If you choose a file from outside of your Key File Folder it will be automatically copied into your Key Files Folder. If you need help you can click the help button () to get to this document.

Section 1 (Filled Out)

After you have selected your API Key File the Info button () and the Test Connection button will become enabled. Click the Info button () to display a API Key Report with a wealth of information about the SQL Schema Engine Schema profile which it came from.

Click the button to make sure that this product can connect to the database schema using the API Key File you have chosen. **IMPORTANT - This connection test is especially important IF your SQL Schema Extender product is installed on a different computer/server than the UltraPort SQL Schema Engine. If this connection fails you need to correct this problem before you proceed further. See Troubleshooting for more help on testing the connection to the database.

Section 2 (Empty)

In Section 2 you will give your profile a name. This name must be unique for every profile you create. If you completed Section 1 first you will notice that the Profile Name field is automatically filled out with the display name of the UltraPort SQL Schema which was the source for your API Key File. It only does this ONCE (if the Profile Name is empty), so if you selected an API Key File and then corrected and selected a different one it will NOT automatically set the Profile Name a second time.

Section 2 (Filled Out)

You can "force" the program to name your profile (if you have selected a valid API Key File in Step 1) by clicking the blue link field under the Profile Name Field (Click HERE to use the Schema Name as the Profile Name). Clicking this will read your API Key File and set the Profile Name to the SQL Schema Profile name. IF you have OTHER profiles which are using the SAME API Key File you will note that it will append a number to the end of the profile name. As an example from the screenshot above if you had another profile already using the same API Key File it would name your profile [ZZZ] MS SQL ODBC1 (2), or [ZZZ] MS SQL ODBC1 (3) and so on.

The Profile ID field is read-only and will be automatically generated by the program. This field is used mostly in File Naming of System Log Files, Traffic Log Files, and Archive files.

Section 3 (Filled Out)

In Section 3 you tell your profile where to look for HL7 messages to import, which of the 4 MS Windows Services will run the profile, whether you want the program to execute a stored procedure after it imports each message (Microsoft SQL Server only) and whether your profile is enabled or disabled.

Click the browse for folder button () to select the data folder where HL7 message data files will be found. Enter the Data File Extension to look for. The Data File Extension must be alpha-numeric characters only (no wildcard characters). The (Data Folder + Data File Extension) combination MUST be unique for every enabled profile. IE you can have a profile which looks in C:\HL7Messages\ for *.HL7 files and another that looks in the SAME folder for *.TXT files.

If you want the program to run a Stored Procedure after importing each HL7 message you can check the Run a Stored Procedure box and then enter the name of the SQL Stored Procedure.

NOTE 1: Rules for naming and writing stored procedures follow the outline in the UltraPort SQL Schema Engine rules for Inbound Stored Procedures.

NOTE 2: Stored Procedure execution is not supported in this program for MySQL.

And finally check the Runtime Processing is Enabled box to enable your processor.

Click the Save and Exit Button when you have finished making changes.