Axess SOAP EDE interface
Prerequisites:
1. Axess: Must install the Oracle database.
2. Axess: Must install the SOAP EDE interface.
3. Client: SQL Server must have the .NET 4.0 framework installed if it isn’t already
4. Client: CLR needs to be enabled by running the script below
-- Script to enable CLR
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
5. Client: Ensure the DB Owner is SA
Installation of stored procedures and tables:
2. Extract the files to a folder that is accessible to the log-in for the SQL Server service.
3. Drop any old Axess procedures by running: DropAxessCLRProcsAndAssemblies.sql
• Remember to double-check the directory names and DB names on this and all following scripts
4. Create the new ones by running: CreateAxessCLRProcsAndAssemblies.sql
5. Create the tables and T-SQL stored procedures by running: CreateTSQLStoredProcsAndSupportTables.sql
6. Create the Sirius CLR Procedures (different than the Axess ones) by running: DropAndCreateSiriusSP_CLR.sql
7. Set your Axess configuration properly:
• exec SiriusSP_ax_SetValue @tcKeyName = 'AxessUrl', @tcValue = 'http://192.168.2.91:16302/axis_990/services/SOAPEDEInterface'
• exec SiriusSP_ax_SetValue @tcKeyName = 'AxessUserName', @tcValue = 'Siriusware'
• exec SiriusSP_ax_SetValue @tcKeyName = 'AxessPassword', @tcValue = 'Siriusware'
• exec SiriusSP_ax_SetValue @tcKeyName = 'AxessProjectNumber', @tcValue = '990'
8. Set your Siriusware configuration properly:
• exec SiriusSP_Ax_SetValue @tcKeyName = 'SalesEzIpPort', @tcValue = '127.0.0.1:4203'
9. Run the test scripts, and verify the output is similar to the commented examples.
• Axess: TestAxessConnect.sql
• Sirius: TestSiriusConnect.sql
10. Give SiriusWeb execute permissions to [SiriusSP_Ax_GetWtpReloadList]
Creating a SQL Server Agent job:
A SQL Server Agent job is created that runs every five minutes and executes a SQL Script. There are two steps:
1. Process Siriusware Activity: T-SQL script: exec SiriusSP_Ax_ProcessActivity
2. Process Gate Scans: T-SQL script: exec SiriusSP_Ax_GetReaderTransactions
Note: On the Advanced tab in step one above, ensure that Go to next step is selected for both success and failure. On the Advanced tab in step two, ensure that Quit the job reporting success is selected for both.