Hello my name is Jay Campbell with The Fax Guys for RightFax University. This installment is a basic primer covering the logic behind RightFax and SQL integration. This video is recorded at 1280 by 720 resolution for high definition and is best viewed in full screen mode.
RightFax stores all its data including information, faxes, users and value rules in a structured query language data base. Remember fax images are stored separately as a graphic file in the RightFax image folder.
The RightFax SQL instance may be installed directly in the RightFax server, can be installed on an existing SQL server. You select where the SQL data base is to be installed when you install the right Fax server software.
Let’s look at RightFax services that actually touch SQL. For performance reasons only a few services directly access the SQL server to gather information and update the fax server database. These services are: the RightFax Database Module, the RightFax Doc Transport Module and the RightFax Remoting Service.
Let’s look at a common deployment scenario, as Shared Services Collective. Shared Services collectives work in exactly the same way as a standalone RightFax server. The multiple instances of RightFax will share a common SQL database .
Collectives may also have local Doc Transport services in addition to remote services as well.
A remote Doc Transport server, Doc Transport Module runs on its own remote server computer and needs to access the database to send and receive faxes.
A Web Access Module running on IAS on a separate computer from the fax server needs independent database access which is provided by the other remoting service. The SQL express server that is provided with RightFax includes all the SQL functionality required by the RightFax software. However this version of SQL does not include all the tools and administrative capabilities as the full version. It is strongly recommended that you do not make any changes directly to the RightFax SQL database. A complete schema of the RightFax database can be viewed using SQL Administrator. On some versions of RightFax an image of the schema is also available in Docs folder in the RightFax installation CD in the RightFax database schema dot PDF file.
RightFax creates a link to a SQL database during installation. The SQL database connection can be modified if at any time you need to make changes to your existing SQL installation. To enter this SQL connection you must change the connection string from the RightFax server service, The RightFax Doc Transport Module service and the RightFax Remoting service. Refer to yourself for documentation for detailed instructions on where to change these items in the RightFax software. This configuration has moved from time to time with version change. As you can see though the logic to Right Fax SQL integration is pretty straight forward and intuitive.
This is Jay Campbell with The Fax Guys from RightFax University saying thank you for watching and please visit us again. The RightFax University is a work under continual progress and we update often.