Syteview - Installation Guide

Syteview™ - Installation Guide

Syteview uses one or more Microsoft SQL Servers and Internet Information Servers to retrieve, format and deliver data to your users’ web browsers. These Servers can run on anything from a single computer to a large distributed network of web and database servers. Each computer that will be running an IIS Server will have Syteview’s web server components installed. Similarly, each computer that will be running an SQL Server will have Syteview’s database components installed on it. In the case where a single computer is running both your IIS Server and your SQL Server both sets of Syteview components will be installed, though each set of components must be installed into a separate directory.

During the the Syteview installation process you will be asked if you want to create a recommended set of Domain Groups that can be used to manage user access to your data. We strongly suggest that you answer yes to this question and allow the SyteSetup program to create these groups for you. If the computer(s) hosting your Microsoft SQL Server and IIS Server belong to an NT or Active Directory domain you will need to create this set of recommended Global Groups on your Domain Controller before installing the Syteview components on your SQL and IIS Servers. The easiest way to create these Global Groups on your Domain Controller is install the SyteSetup program on your Domain Controller and let it create the Global Groups for you.

Note: The SyteSetup program is also used to install the Syteview Database and Web Server Components and will need to be installed on each computer that will be hosting either your SQL or IIS Server.

Installing SyteSetup Program

To install the SyteSetup program, run the Install.bat program (located in the root directory of the Syteview CD). When this program is run the first screen you see will be a welcome screen that also asks you to close any other programs that you may be running.

Close any running programs and the click the OK button to continue.

The next screen you see will allow you to specify the installation directory for the SyteSetup program. In this example we will be installing SyteSetup into the \Syteview\SyteSetup directory on the computer’s D: drive. You can install the program elsewhere if you wish by clicking the Change Directory button.

After you have chosen the directory you wish to install the SyteSetup program into, click the square button with the picture of the computer on it to begin the installation process. It will take several seconds for the SyteSetup program to install, afterwhich it launch itself and you will be presented with the following screen.

If you are using the SyteSetup program to create the Global Groups on your Domain Controller click the Begin the Installation button. This will bring up the following screen:

Click the Create the Syteview Global Groups button and sit back while the Global Groups are created.

After the Global Groups have been create on your Domain Controller click the Exit button and you will be returned to the previous screen.

If you have just installed the Global Groups on your Domain Controller (and this Domain Controller is not also the computer that will be hosting either your SQL Server or you IIS Server) then click the Exit button on this screen to close the program. Your next step will be to install the Syteview SQL Server components on your SQL Server followed by installing the Syteview Web Server Components on your IIS Server.

Installing the Syteview Database Server Components on Your SQL Server

Begin the Syteview Database Server Components installation process by installing the SyteSetup program on the computer hosting your SQL Server. When the SyteSetup program finishes installing it will launch itself and you will be presented with the following screen:

Click the Begin the Installation button to begin the installation process on your SQL Server. This will bring up the following screen which will assist you in creating the recommended set of Local Groups on this computer.

Click the Create the Syteview Local Groups button to create the Local Groups that will assist you in managing permissions on your SQL Server.

After creating the Local Groups, your next step will be to install the Syteview SQL Server components. Checkmark the SQL Server Components checkbox and clear the Web Server Components checkbox if it is checked and then click the Install button to begin installing the Syteview SQL Server components.

This will bring up the Syteview SQL Server Components Installation screen.

This screen lists the five steps involved in installing the SQL Server components.

Starting with Step 1, you will specify the installation directory for the Syteview SQL Server files. In this example we will be installing Syteview’s SQL Server components into the \Syteview directory on the computer’s D: drive. If you wish to install the Syteview SQL Server files in another location either type the full path to that location in the text box or click the Browse button and select the desired location from the Change Directory dialog box that appears. Once the correct location is in the text box, click the Install button to begin the process of installing the Syteview SQL Server files.

As the SQL Server files installation begins you will be shown a dialog box that lists the location of the Syteview SQL Server installation files on the Syteview Installation CD.

You should not have to change anything here unless the location of your CD-ROM drive has changed since you installed the SyteSetup program, so simply click the OK button to continue. It may take a minute or two, but eventually you should see the following screen that tells you that the Syteview SQL Server files have been successfully installed.

Click the OK button to return to the Syteview SQL Server Components Installation screen. Step 1 should now display >> DONE.

Step 2 involves connecting the SyteSetup program to the SQL Server, selecting the Syteview Administrative Account, specifying the location of the physical database files, and finally creating the Syteview database, tables, views and stored procedures used by Syteview. At the time you create the main Syteview database you will be able to create three other databases:

SyteWebs - Used by the Battleaxe Forums
SyteShop - used by the VP-ASP Shopping Cart program
SyteData - used by the Bi-Directional DataLinks

First, make sure that the Select the MS-SQL Server text box is filled in with (local). You could install Syteview on a remote database server by filling its name in here, but in this case we are installing Syteview on the local SQL Server. Click the Connect to the SQL Server button to actually connect the installation program to the SQL Server. Connected to: (local) should appear directly above the button that you just clicked.

Note: Do not continue without connecting to the SQL Server.

Next you will be selecting the Syteview Administrative Account (also called a Server Login) that will be used to create the Syteview database, tables, views and stored procedures. Clicking the Select the Admin Account button will bring an warning screen that tells that the administrative account must already exist on your SQL Server before proceeding.

If the account you will be using already exists on your SQL Server and it has sufficient rights to create the database click the Yes button to continue. Otherwise click No, exit the SyteSetup program, create the administrative account and then re-run the SyteSetup program.

After you click the Yes button a list of accounts on your SQL Server will be displayed.

Select the Account that will become the administrative account for the Syteview database. In this example we will be using the SYTECORP\SQL account.

After selecting the Syteview Administrative Account your next step will be to specify the location for the Syteview database’s physical files. In this example we are putting them in the D:\Syteview\Data directory. If you want to put them in another location, Click the Browse button and select the new location from the Change Directory dialog box that appears.

After specifying the location for the Syteview database’s physical database files select the version of the Progress/Syteline tables that you will be replicating into the SQL Server using

Note: Leave the Version field blank if you do not want to create any version specific tables.

Next, select any of the other three databases, SyteWeb, SyteShop and SyteData, that you will be using. Go ahead and install all three if you are not sure whether or not you will be using them in the future. All together they will take up less than ten megabytes of physical storage if you don't use them.

Finally, click the Create the Database(s) button to begin creating each of the databases you checkmarked above.

You will be shown the parameters you have just specified for the Syteview database you are about to create.

Click the Yes button to continue.

The following screen will be notify you when the empty Syteview database has been successfully created.

Click the OK button to continue.

After creating the Syteview database, the SyteSetup program will next create the SyteWebs database which holds the message forums.

Click the Yes button to continue.

The following screen will be notify you when the SyteWebs database has been successfully created.

Click the OK button to continue.

The SyteSetup program will next create the Server Logins (based on the Local Groups you created on this SQL Server) that will be used to manage user access to your data.

Click the OK button to continue.

The following screen will be notify you when the Server Logins have been successfully created.

Click the OK button to continue.

Next the SyteSetup program will create the a few preliminary tables in the Syteview database that are used by all versions.

Click the OK button to continue.

The following screen will be notify you when the preliminary tables have been successfully created.

Click the OK button to continue.

Next the SyteSetup program will create the Syteview Stored Procedures.

Click the OK button to continue.

The following screen will be notify you when the stored procedures have been successfully created.

Click the OK button to continue.

Next the SyteSetup program will apply permissions to the Syteview stored procedures that were just created.

Click the OK button to continue.

The following screen will be notify you when the permissions have been applied to the stored procedures.

Click the OK button to continue.

Next the SyteSetup program will create the SchemaMap table that is used to create version independent data views that allow you to write programs that access data from any version of Syteline without modifications.

Note: This step will be skipped if you left the Version field blank in Step 2.

Click the OK button to continue.

Note: Be patient. This step will take 5 to 10 minutes to complete.

The following screen will be notify you when the SchemaMap table has been created.

Click the OK button to continue.

Next the SyteSetup program will create the DbSchema table that is used by the Syteview DataLink programs that link your Progress and Microsoft SQL Server databases together in real-time.

Note: This step will be skipped if you left the Version field blank in Step 2.

Click the OK button to continue.

Note: Be patient. This step will take 2 to 3 minutes to complete.

The following screen will be notify you when the DbSchema table has been created.

Click the OK button to continue.

Next the SyteSetup program will create the tables and views that replicate your tables in your Progress database.

Note: This step will be skipped if you left the Version field blank in Step 2.

Click the OK button to continue.

The following screen will be notify you when the tables and views have been created.

Click the OK button to continue.

This completes the Syteview database installation.

Click the OK button to continue on to Step 3 - Creating the Progress-ODBC Connection.

Clicking the Instructions for Creating the Progress-ODBC Connection button will open a page in your web browser that describes the steps to follow in order to create an ODBC connector to your Progress database. Click here to see these instructions.

Note: The Progress Server that you will be connecting to must be running in order to successfully test your ODBC connection, but it does not have to be running at the time you create the ODBC connection.

Note: The Progress Server can, but does not have to be running on the same computer that is hosting your SQL Server.

A summary of these steps are as follows:

Open the ODBC Data Sources applet in the Control Panel on your SQL Server if you are using the Windows NT 4.0 operating system, or open the Data Sources (ODBC) applet in Administrative Tools if you are using the Windows 2000 or greater Operating System.
Switch to the System DSN Property Page
Highlight the MERANT 3.60 32-BIT Progress SQL92 v9.1B (or greater) ODBC driver.
*** Install the Merant ODBC Driver from your Progress CD if it does not appear in the list of ODBC drivers.

On the ODBC Progress SQL92 Driver Setup screen fill in the following

Data Source Name:	Progress-ODBC
Description:	Progress ODBC Connection
Host Name:	[Your server's name]
Port Number:	7225
	-or whatever Symix is listed as in your Services file on your Progress Server
Database Name:	symix.db
	-or whatever your Progress database is named
User ID:	sysprogress
	-User ID is only used if you have setup security on your Progress database

Click the Test button to test the connector you have just created
If you have enabled security on your Progress database fill in your User ID and Password and click the OK button
You should see the Connection Established! message box within a few seconds.

After creating and testing the Progress-ODBC connection you should continue on to Step 4 Creating the SQL-Server (ODBC) Connection.

Clicking the Instructions for Creating the SQL Server Connection button will open a page in you web browser that describes the steps to follow in order to create an ODBC connector to your Syteview SQL Server database. Click here to see these instructions.

A summary of these steps are as follows:

Open the ODBC Data Sources applet in the Control Panel on your SQL Server if you are using the Windows NT 4.0 operating system, or open the Data Sources (ODBC) applet in Administrative Tools if you are using the Windows 2000 or greater Operating System.
Switch to the System DSN Property Page
Highlight the SQL Server driver and click Finish.
On the Create a New Data Source to SQL Server fill in the following fields:

Data Source Name: SQL-Server

Description: MS-SQL Server - Syteview Database

Host Name: [Your server's name]
Click the Next button
On the following screen select Windows NT Authentication and then click the Next buttons
On the next screen Change the default database to: Syteview and make sure the Use ANSI quoted identifiers and Use ANSI nulls, paddings and warnings checkboxes are both checked
Click the Next button
On the next screen make sure the Perform translation for character data checkbox is checked
Click the Finish button
The next screen shows the settings of the ODBC Driver you have just created. Click the Test Data Source button.
You should see the TESTS COMPLETED SUCCESSFULLY! message box.

Close the ODBC Drive window on move on to Step 5 Configuring the DataLink and DataGrabber programs

Note: You do not have to configure the DataLink and DataGrabber programs at this time. You can close the Syteview SQL Server Components Installation screen at this time and continue on to installing the Syteview Web Server Components if you wish.

If you wish to configure the DataLink and DataGrabber programs at this time, click the Instructions for Configuring the DataLinks and DataGrabbers button which will open a page in you web browser that describes the steps to follow to configure the DataLink and DataGrabber programs provided with Syteview and how to create new DataLink and DataGrabber programs using the Syteview DTS2VB.exe and DTS2VB_Link.exe programs.

Note: DataLink programs are used to keep tables in your Syteview database on the Microsoft SQL Server synchronized with matching tables in the Progress database.

Note: DataGrabber programs are used to move entire tables from your Progress database to the Syteview database on your Microsoft SQL Server.

Follow the instructions on this page to configure the DataLink and DataGrabber programs and to create new DataLink and DataGrabber programs for new tables that you will be replicating from your Progress database to the Syteview database on your SQL Server.

The following pages provide additional information on configuring and using the DataLink and DataGrabber programs:
Creating Table DataLinks and Creating DataGrabbers

This completes the installation of the Syteview SQL Server Components

Installing the Syteview Web Server Components on Your IIS Server

Begin the Syteview Web Server Components installation process by installing the SyteSetup program on the computer hosting your IIS (web) Server. When the SyteSetup program finishes installing it will launch itself and you will be presented with the following screen:

Click the Begin the Installation button to begin the installation process on your IIS Server. This will bring up the following screen which will assist you in creating the recommended set of Local Groups on this computer.

Click the Create the Syteview Local Groups button to create the Local Groups that will assist you in managing permissions on your IIS Server.

After creating the Local Groups, your next step will be to install the Syteview Web Server components. Checkmark the Web Server Components checkbox and clear the SQL Server Components checkbox if it is checked and then click the Install button to begin installing the Syteview Web Server components.

This will bring up the Syteview Web Server Components Installation screen.

This screen lists the three steps involved in installing the Web Server components.

Starting with Step 1, you will specify the installation directory for the Syteview Data Control. In this example we will be installing the Syteview Data Control in the I:\Syteview\Asp2Sql directory so you will have to change from the default D:\Syteview\Asp2Sql directory. You can either type the full path to that location in the text box or click the Browse button and select the desired location from the Change Directory dialog box that appears. Once the correct location is in the text box click the Install button to begin the process of installing the Syteview Data Control.

This will bring up a dialog box that lists the location of the Data Control installation files on the Syteview Installation CD.

You should not have to change anything here unless the location of your CD-ROM drive has changed since you installed the SyteSetup program, so simply click the OK button to continue. Within a few seconds you should see the following screen that tells you that the Syteview Data Control has been successfully installed.

Press the OK button to continue.

Next, a message box telling you that the Syteview Data Control: ASP2SQL.DLL was successfully registered on your computer should appear.

Click the OK button to return to the Syteview Web Server Components Installation screen. Step 1 should now display >> DONE.

Step 2 specifies the Web Site Files Installation Directory. This will be the location of the files that make up the Syteview web site. In this example we are installing these files to the I:\Syteview directory so you will have to change from the default D:\Syteview directory. You can either type the path for location in the text box, or click the Browse button and select the location from the Change Directory dialog box that appears. Once the correct location is in the text box, click the Install button to begin the process of installing the web site files.

Note: If you are installing the SQL Server components and the Web Server components on the same computer DO NOT INSTALL BOTH SETS OF COMPONENTS INTO THE SAME DIRECTORY.

After clicking the Install button the first thing you see will be a dialog box that lists the location of the Web Site installation files on the Syteview Installation CD.

Click the OK button to begin installing the web site files.

You may have to wait for up to several minutes while the web site files are being copied to your web server.

During the installation process a system that protects your system from SQL Injection attacks will be installed. After this is installed you will be shown the following message box.

Click the OK button to continue.

Next, the permissions on your web site directories will be set.

Click the OK button to continue. Be patient. This may take several minutes.

After the permissions on your web site directories have been set you have completed Step 2.

Click the OK button to return to the Syteview Web Server Components Installation screen. Step 2 should now display >> DONE.

Step 3 does not install anything else, but it does help you configure your web server.  Clicking the Instructions for Configuring the Web Server button will bring up a web page that outlines the basic steps involved in configuring and securing your web server.  Click here to view these instructions.  If you are familiar with configuring and securing web servers this web page should give you sufficient information to complete this process.

Note: Placing an improperly configured or unsecured web server on the internet, or even on your intranet, can be a very dangerous thing.  If you are not sure that you have properly secured your web server please seek professional assistance.

You have now finished installing the Syteview web server components on your web server.  Click the Close button on the Syteview Web Server Components Installation screen.