Prerequisites for SourceConnect Management Console
The SourceConnect Management Console requires two categories of prerequisites to function smoothly: those for SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANASAP Central Finance Master Data Replication by insightsoftware and those specifically for the Management Console itself. This section describes the prerequisites for SourceConnect Management Console.
The following prerequisites must be met before installing the SourceConnect Management Console.
Hardware Requirements
The following table consists of the hardware requirements.
| Requirement | Specification |
|---|---|
RAM(GB) |
32 or more |
Disk space(GB) |
150 or more |
Software Requirements
The following tables consist of the software requirements.
| Windows | |||
|---|---|---|---|
| Software | Mandatory/Optional | Version | Link |
SAP Data Services |
Mandatory |
4.2, 4.3 |
|
SAP HANA Client |
Mandatory for SAP HANA as the staging database |
2.24.26 |
|
Oracle Client Software |
Mandatory when Oracle E-Business Suite and JD Edwards EnterpriseOne are sources and connection is via TNS mode. |
11.2+ |
NA |
Google Chrome |
Optional |
Latest version |
Download |
| Linux | |||
|---|---|---|---|
| Package/Software | Mandatory/Optional | Command/Version | Link |
dos2unix |
Mandatory |
For Red Hat Enterprise Linux: sudo yum install dos2unix -yFor SUSE Linux: sudo zypper install dos2unix |
NA |
SAP Data Services |
Mandatory |
4.2, 4.3 |
Download |
SAP HANA Client |
Mandatory for SAP HANA as the staging database |
2.24.26 |
|
Oracle Client Software |
Mandatory when Oracle E-Business Suite and JD Edwards EnterpriseOne are sources and connection is via TNS mode. |
11.2+ |
NA |
| Client Computer Requirements | ||
|---|---|---|
| Software | Mandatory/Optional | Link |
Google Chrome |
Mandatory |
|
Microsoft Excel |
Mandatory for Master Data Mapping |
|
Read and Write Access:
Ensure that the following users have read and write access to the <SAP Data Services Installation Folder> and <Log and Cache Folder>:
-
For Windows:
IIS_IUSRS - For Linux: The user/group that installed the SourceConnect Management Console.
Default Install location for SAP:
- Windows: $LINK_DIR
- Linux: $HOME/sap businessobjects/bin
Default Log and Cache location:
- Windows: C:\insightsoftware\SourceConnect\
- Linux: /var/log/insightsoftware/SourceConnect/
Ensure that the following users have read and write permissions for the folders at the locations below:
-
For Windows:
IIS_IUSRS - For Linux: The user or group that installed the SourceConnect Management Console.
Location:
- Logs folder located at %DS_COMMON_DIR% (Linux: $LINK_DIR)
- WebContent folder located at <Source Connect Installation Folder>\insightsoftware\SourceConnect\
Prerequisite for ETL Project Deployment: Perform the following prerequisite steps to prevent a “Read timed out” error during deployment:
- Edit the
admin.xmlconfiguration file located in the following location and update the value ofjs-socket-timeoutto300000(milliseconds).- Windows: %DS_COMMON_DIR%\conf
- Linux: $LINK_DIR/conf
- Open the central configuration manager.
- Restart the relevant services to apply the updated configuration.
For more information, refer to SAP Community.
Environment Variables
Set the following environment variables to the respective locations:
- Set the TNS_ADMIN environment variable to the location of the
tnsnames.orafile to load the TNS entries for Oracle E-Business Suite, JD Edwards EnterpriseOne, and Oracle PeopleSoft. - Set the HDBADONET environment variable to the
<SAP HANA client installation folder>\ado.net>folder. - Set the HDBDOTNETCORE environment variable to the
<SAP HANA client installation folder>\dotnetcore>folder. - Add the
<SAP HANA client installation folder>entry to the PATH environment variable.- For Windows: When installing the SAP HANA client without administrative rights, the installed SAP HANA client is only available to the user that installed it, and the default installation folder is <%USERPROFILE%>\SAP \hdbclient. For example, C:\Program Files (x86)\SAP\hdbclient (64-bit), C:\Program Files\SAP\hdbclient (32-bit)
- For Linux: When installing the SAP HANA client without administrative rights, the installed SAP HANA client is only available to the user that installed it, and the default installation folder is <$HOME>/sap/hdbclient. For example, /usr/sap/hdbclient.
- Run the following commands:
- For Windows - Open command prompt as administrator > Run
iisreset - For Linux - Run the following commands:
sudo systemctl daemon-reload
sudo systemctl start isw_sct
- For Windows - Open command prompt as administrator > Run
Source System Prerequisites
- Before configuring an instance in the Management Console, run the user or database creation scripts. For example, for Oracle E-Business Suite, run the script at <SetupFolder>\Master Data Replication 8.0\SourceConnect 8.0 Management Console\Prerequisites\EBS\Scripts\DB_Script_Auto.sql with appropriate inputs.
Upgrade Queries
Existing customers must run the following query when upgrading to SourceConnect Management Console 8.0 to ensure connection to the same staging database.
Azure database
ALTER TABLE DEPLOYMENT_ITEMT
ALTER COLUMN version VARCHAR(255);
UPDATE DEPLOYMENT_ITEMT
SET version =
CASE
WHEN version LIKE '%.%.%' THEN version
WHEN version LIKE '%.%' THEN version + '.000'
ELSE version + '.00.000'
END;
HANA database
ALTER TABLE DEPLOYMENT_ITEMT
ALTER COLUMN version VARCHAR(255);
UPDATE DEPLOYMENT_ITEMT
SET version =
CASE
WHEN version LIKE '%.%.%' THEN version
WHEN version LIKE '%.%' THEN version + '.000'
ELSE version + '.00.000'
END;