Configure SQL to call Bizweaver WebService

• The file is installed in C:\Program Files\Bizweaver\BWPortal\BWSQLSP when Bizweaver is installed.
• The file can be downloaded from https://portal/twbs.com in the Software Download section.

Execute the following SQL statements against the Master database

sp_configure 'show advanced options', 1 
GO  
RECONFIGURE 
GO  
sp_configure 'clr enabled', 1
GO  
RECONFIGURE 
GO
 
-- Create Asymmetric Key using DLL.
CREATE ASYMMETRIC KEY [bwws]
AUTHORIZATION [dbo]
-- Source DLL file must be located in C:\Program Files\Bizweaver\BWPortal\BWSQLSP, or path changed below
FROM EXECUTABLE FILE = 'C:\Program Files\Bizweaver\BWPortal\BWSQLSP\SQLWSCall.dll'
-- Create login
CREATE LOGIN TWBS
FROM ASYMMETRIC KEY [bwws]
-- Modify login
GRANT UNSAFE ASSEMBLY TO TWBS

Create an Assembly in the Target (SAP or VersagoData) database

• Expand the folder tree for the target (SAP) database.
• Expand the “Programmability” folder.
• Right-click on “Assemblies”; select “New Assembly”.

• Browse to folder where the SQLWSCall.dll is located and select it.
  • This will be the same folder as in the previous steps.
• The Assembly Name and Assembly Owner are set automatically.
• Select “External Access” from the drop-down for “Permission Set”.
• Click [OK] to register the assembly.

Create the following stored procedure in the target (SAP) database.

CREATE PROCEDURE [dbo].[spCallBizweaverWS]
@wsMethod NVARCHAR (MAX), 
@wsUrl NVARCHAR (MAX),
@wsPort NVARCHAR (MAX),
@wsContent NVARCHAR (MAX),
@wsAuthToken NVARCHAR (MAX),
@wsTaskId INT,
@wsStartAfter INT,
@wsParameters NVARCHAR (MAX)
AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS]