The interface IDL.SmartConnectivity is started by a call of SSIS packages (SQL Server Integration Services). An integrated login to SSIS is required for the start of SSIS packages.
Up to now the start was performed by calling „IDL.INTEGRATOR.SSIS.exe" in the MEN commands. For this purpose each invoking IDL.KONSIS user had to be authorised with his Windows account directly in the SSIS database on the SQL Server.
From Release 2019 Update 1 Fixpack A on there is a new program start „SSISINTEGRATOR.jar" for the start of IDL.SmartConnectivity. For the time being the previous call of „IDL.INTEGRATOR.SSIS.exe" continues to be useable.
The new call „SSISINTEGRATOR.jar" is designed in the way that the IDL.KONSIS.FORECAST Application Server now performs the login by itself. However, for this purpose now the service account of IDL.KONSIS.FORECAST Application Servers has to be authorised accordingly on the SSIS database. Thus now the final user no longer requires any authorisations on the SSIS database.
An additional advantage ist that the new interface using „SSISINTEGRATOR.jar" no longer requires the firmly installed IDL.KONSIS.FORECAST Client on the client computer. Thus the interface can also be used by clients using the IDL.KONSIS.FORECAST Portal (via IDL.LAUNCHER or Java Webstart, respectively). A direct connection between client computer and SQL Server is no longer required.
For usage of „SSISINTEGRATOR.jar" the following settings have to be provided.
The IDL.KONSIS.FORECAST Application Server service now mandatory has to run under a Windows account to enable the service to login to SSIS. Two cases have to be distinguished:
In case of the All-In-One architecture the Windows account may be a local Windows account, too. Otherwise always a domain account has to be established. This account requires the authorisation for „Login as a service".
For the time being the service account for „IDL.KONSIS.FORECAST Application Server" has to be entered manually in the Windows service administration in the server.
Note: After running of „configure.exe" currently it may happen, that the service account is reset to „Local System". Therefore please always check this and add it in case again.
The service account has to be established in SQL Server as Windows user and receive the following properties:
The call parameters are the same as for the previous command „idl.integrator.ssis.exe", see documentation of IDL.SmartConnectivity. Command:
ssisintegrator.jar [List of required parameters]
If you intend to replace the old interface by the new one you have to replace the old command
start idl.integrator.ssis.exe [List of required parameters]
by the new one
ssisintegrator.jar [List of required parameters]
The visual appearance of the SAP Connection Manager, RFC-Report and RFC-Function Windows has been improved.
The windows are now resizable and all the controls inside the window will be resized, respectively, according to the size of the window.
In addition, the performance of these components has been improved.