• 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) 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.

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]