Skip to main content

Manage data source connections

Access through: Administration > Data source administration

In preparation to load system data, you can create data source connections in the Data source administration feature in Snow Optimizer for SAP® Software. There are also functions to Create Master Synchronization Point, Check connection status, Reload system data, and Assign reporting group.

tip

Contact your SAP system administration team for the setup and maintenance of the required RFC and secondary database connections.

Create data source or folder

Create data source or folder​

Data source administration.png

  1. Select Switch to change mode.png.

  2. Do one of the following:

    • To create the very first entry:

      1. Right-click in the empty area.

      2. In the context menu, select Create, Data source or Folder, and the place to insert.

    • To create more data sources or folders:

      1. Right-click on an existing data source, folder, or Master Synchronization Point.

      2. In the context menu, select Create, Data source or Folder, and the place to insert.

  3. If you selected Folder, enter the folder name and description and select Accept.png.

  4. If you selected Date source, select the data source type and select Accept.png.

    note

    The following steps differ depending on the selected data source type.

  5. Save.

Create Master Synchronization Point

Create Master Synchronization Point​

Create_master_synchronization_point.png

note

A Master Synchronization Point must not contain any data sources that already exist in the data source administration.

  1. Select Switch to change mode.png.

  2. Do one of the following:

    • Create a very first entry:

      1. Right-click in the empty area.

      2. In the context menu, select Create, Master Synchronization Point, and the place to insert.

    • Create another Master Synchronization Point:

      1. Right-click on an existing data source, folder, or Master Synchronization Point.

      2. In the context menu, select Create, Master Synchronization Point, and the place to insert.

  3. In the pop-up, enter the Master Synchronization Point name and description.

  4. Enter the RFC destination.

  5. To load the system data of Submaster data sources, select Load submaster data.

  6. Deselect the activation of the Master Synchronization Point if necessary.

  7. Select Accept.png.

  8. Save.

Rename Master Synchronization Point folder or data source

Rename Master Synchronization Point folder or data source​

The names of folders and data sources are unique in the data source administration. Hence, if the name of a folder, BusinessObjects data source, or external data source of loaded Submaster system data already exists in the data source administration, an ascending number is added to the name in arrow brackets.

You can also change the names of folders, BusinessObjects data sources, and external data sources in Master Synchronization Points manually.

  1. Select Switch to change mode.png.

  2. Right-click on an existing folder, BusinessObjects data source, or external data source of the Master Synchronization Point.

  3. In context menu, select Change.

  4. In the pop-up, enter the name.

    tip

    The Original-ID field shows the original name of the folders.

  5. Select Accept.png.

  6. Save.

Check connection status

Check connection status​

  1. Select Switch to change mode.png.

  2. Right-click on a data source entry.

  3. In the context menu, select Check connection status.

tip

You can check the connection status of many data sources at once using the Connection status of data sources report.

Reload system data

Reload system data​

  1. Select Switch to change mode.png.

  2. Right-click on a data source entry.

  3. In the context menu, select Reload system data.

Assign reporting group

Assign reporting group​

note

Before you can assign reporting groups, you must create reporting groups in Reporting groups.

  1. Select Switch to change mode.png.

  2. Right-click on a data source entry.

  3. In the context menu, select Maintain reporting groups.

  4. In the pop-up, select or deselect the checkboxes of the reporting groups.

  5. Select Accept.png.

  6. Save.

Data source types​

Create ABAP data source entry

Create ABAP data source entry​

ABAP data sources.png

  1. Enter the description.

  2. Enter the RFC destination.

  3. To activate the system connection and load system data, select Load system data.

    note

    After you loaded the system data, the data fields below Loaded data are filled automatically. By selecting Detailed data.png, you can show detailed data which is also filled in automatically.

  4. If required, deselect checkboxes.

  5. If an override is required, select the client category and default license type.

  6. Select Accept.png.

Create JAVA-UME data source entry

Create JAVA-UME data source entry​

Java-UME data sources.png

  1. Enter the description.

  2. Enter the RFC destination.

  3. To activate the system connection and load system data, select Load system data.

    note

    After you loaded the system data, the data fields below Loaded data are filled automatically. By selecting Detailed data.png, you can show detailed data which is also filled in automatically.

  4. Enter the default license type.

  5. Enter the RFC destination CEN.

  6. If required, deselect checkboxes.

  7. Select Accept.png.

Create HANA data source entry

Create HANA data source entry​

HANA data sources.png

  1. Enter the description.

  2. Enter the HANA database connection.

  3. To activate the system connection and load system data, select Load system data.

    note

    After you loaded the system data, the data fields below Loaded data are filled automatically. By selecting Detailed data.png, you can show detailed data which is also filled in automatically.

  4. Enter the default license type.

  5. If required, deselect checkboxes.

  6. Select Accept.png.

Create BusinessObjects data source entry

Create BusinessObjects data source entry​

BO data sources.png

  1. Enter the description.

  2. Enter the RFC destination CMC and the RFC destination REST.

    note

    You have to enter the RFC destination REST Webservice only for changing, not for reading data.

  3. Enter the user name and password.

  4. To activate the system connection and load system data, select Load system data.

    note

    After you loaded the system data, the data fields below Loaded data are filled automatically. By selecting Detailed data.png, you can show detailed data which is also filled in automatically.

  5. Enter the data source name.

  6. Select the system type.

  7. Enter the default license type.

  8. If required, deselect checkboxes.

  9. Select Accept.png.

Create S/4HANA Cloud data source entry

Create S/4HANA Cloud data source entry​

HANA_cloud_data_sources.png

  1. Enter the description.

  2. Enter the data source name.

  3. Select the system type.

  4. If required, deselect checkboxes.

  5. Select Accept.png.

Create external system data source entry

Create external system data source entry​

note

Before you can create entries for external system data sources, you have to create external system types in Manage external system types.

External system data sources.png

  1. Enter the description.

  2. Enter the external system type.

  3. Enter the data source name.

  4. Enter the default license type.

  5. If required, deselect checkboxes.

    note

    By selecting Detailed data.png, you can show detailed data which is also filled in automatically.

  6. Select Accept.png.