Setting Up SAC Connection

Access your SAC instance using your credentials. It is your starting point for integrating data from your Universal Model.​

You must have a predefined model in SAC that reflects the data structure you are working with in your Universal Model. This model acts as a template for how the data are organized and analyzed.​

Example Model Structure: ​

Measures: Define the key performance indicators or metrics that you wish to analyze. For this example, our measures include:​

• Dividend
• Tax-Free Income
• Capital Gains

Dimensions: They provide contextual details for your measures. Key dimensions could be:​

• Date
• Currency
• Company
• Year Description
• Importing Data into SAC

Navigate to the data management section of SAC.​

Prepare your data in a CSV file format, ensuring it matches the structure of your SAC model. The CSV file contains the records that you wish to upload.​

Step 4: Upload Data ​

Use the Data Upload functionality in SAC to bring your CSV data into your model. This step is crucial for populating your SAC model with data from your Universal Model, enabling further analysis.​

Navigate to the Systems Administration section within SAC. This is where you manage various administrative settings, including OAuth clients.​

Initiate the process of adding a new OAuth client. This action opens a pop-up screen that prompts you to enter specific details and configure permissions.​

Name: Provide a meaningful name for the OAuth client that reflects its purpose.​

Purpose: Purpose: Specify the purpose of this client, helping you identify its role in future configurations.​

Access Types: Select the appropriate access types based on your intended data communication needs. Common access types include:​

• Data Export Service
• Data Import Service API

In this example, we are focusing on import and export services.​

In the OAuth client configuration, you can generate client credentials. This process produces:​

• Client ID
• Client Secret

These credentials are used for authentication and secure communication between your systems.​

Once the client credentials (Client ID and Client Secret) are generated, make sure to copy them immediately. SAC does not display these credentials again. It's crucial to document this information securely.​

Record the Client ID, Client Secret, and any other relevant credentials in a secure location. Failing to save them requires generating new credentials, which can disrupt ongoing integrations.​

Navigate to the 'Systems' section within SAP Analytics Cloud.​

Access the App Integration subtab. Here, you find the Token Service URL. This URL is essential for authenticating and securing your connection.​

Token Service URL: Copy this URL for use in the next steps.​

Client ID: You already have the Client ID from the OAuth configuration.​

Log in to your SAP Business Technology Platform (BTP) account.​

Navigate to the Destinations section, where you can configure the new destination for SAC integration.​

Name: Provide a meaningful name for the destination, such as SAC_Integration.​

Type: Set the destination type to HTTP.​

Description: Enter a brief description, like Integration with SAP Analytics Cloud.​

URL: Use the Token Service URL that you copied from SAC.​

Proxy Type: Set this to Internet.​

Authentication: Choose OAuth 2.0 for authentication. It is aligned with the OAuth setup in SAC.​

Client ID: Populate this field with the Client ID obtained from SAC.​

Client Secret: Enter the Client Secret that you securely stored during the OAuth client setup.​

Step 1: Generate a Unique Key ​

For each new connection in SAC to BTP, you must create a unique key. This key serves as a distinct identifier for the connection, preventing conflicts and ensuring that each connection is properly tracked.​

Steps to Generate a Unique Key: ​

Identify the Environment: Determine the specific environment (for example, development, testing, production) where you’re creating the connection.​

Create a Unique Field: In your environment’s configuration settings, introduce a new field dedicated to holding unique ID values.​

Generate the Key: Assign a unique key value to this field. Ensure that this key does not duplicate any existing keys within your environment.​

When you configure the new destination or connection in SAP BTP, include the generated unique key in the appropriate field.​

Field Name: Use the field that you created for unique ID values.​

Key Value: Input the unique key you generated for this specific connection.​

Within your Universal Model configuration, navigate to the section where you can manage data connections.​

Begin the process of creating a new connection.​

Select the connection type as SAC Model. It specifies that the data exchange is with a model in SAP Analytics Cloud.​

You are prompted to choose the SAC model you wish to sync with. This model matches the structure of the data that you are managing in the Universal Model.​

Steps to Sync Specific Models: ​

Deselect Other Models: During the setup, make sure to deselect any other models that are not relevant to the particular data sync you are setting up. It reduces unnecessary data syncing and keeps your operations focused.​

Select the Target Model: Specifically select the SAC model that contains the data you want to integrate. In this example, you can opt to synchronize only the Fact Data model, which contains specific datasets like sales figures, financial transactions, and so on.​

Syncing with Specific Models ​

Ensure you only sync the selected SAC model (for example, Fact Data).​

The Fact Data model typically contains crucial elements such as sales numbers, transactional data, financial metrics, and other key performance indicators.​

In order to pull in data from SAC we would need to create Reader function in the Universal Model. With Reade we will be able to see imported data.