Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Configuring Simba Gateway

Introduction

Simba Gateway is a comprehensive connectivity solution that enables connections between a diverse variety of applications and data sources, and streamlines the process of connecting to your data.

Note: To use the Simba driver, configure network request interceptor tools such as Fiddler, Charles Proxy, or Netskope to allow self-signed certificates for seamless connectivity. These tools intercept and analyze HTTP/HTTPS data. If they are not configured to enable connections using self-signed certificates, they can cause communication problems between your application and the Simba driver.

Configure Simba Gateway for Excel reporting

SaaS

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle > Oracle EBS > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

On-premises

  1. Select Run from Windows, enter %PROGRAM DATA%\Magnitude\Simba\Simba Gateway, and click OK.

  2. Open Client.config file. In SIMBAGATEWAYAPP section, afterInitialSetup=0 step, enter the following and save the file:

    UseLegacyAnglesAuthWorkflow=1

    3. Configure Simba Gateway

    Note: If you are configuring Simba Gateway for On-premises offline version with identity provider, you have to provide your identity provider credentials after the entering the Angles Hub URL (Refer Step 3).

Configure Simba Gateway for Power BI reporting

SaaS

OCA reporting with Snowflake

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle. Select Snowflake > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

OCA reporting with Azure SQLDB

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle. Select Oracle EBS > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

Advanced

You can manually configure Simba Gateway features by making the changes to the Client.config.ini file, based on the following table:

Feature

Description

Configuration Section

Configuration Property

Values

Default

Add Connector from Package

Enable user to manually install ConnectorPackages

SIMBAGATEWAYAPP

EnableAddConnectorFromPackage

0/1

0 (Disabled)

Angles Application Environment

Enable users to toggle between different Anglesapplication environments

SIMBAGATEWAYAPP

AppEnvironmentType

development/staging/production

production

Angles Authentication Configuration

Enable users to manually update the authentication configuration for an Anglesapplication server.

SIMBAGATEWAYAPP

EnableAnglesAuthConfig

0/1

0 (Disabled)

Connector Catalog

Displays a list of Connectors available for theSimba Gateway app

SIMBAGATEWAYAPP

CatalogLocation

http url, or local file path prefixed with file:///

https://simba.com/products/Gateway/GatewayAdapterCatalog_2_8.json

Gateway Versions URL

URL that provides the latest version for different platforms

SIMBAGATEWAYAPP

GatewayVersionsURL

http url, or local file path prefixed with file:///

https://simba.com/products/Gateway/gatewayversion.json

Initial UseGuidedSetup

Enable users to download and install a Connectorand configure a Connection Profile the first timethey launch Simba Gateway

SIMBAGATEWAYAPP

InitialSetup

0/1

1 (Enabled)

License Management

Enable users to manage Connector Licensesvia the Simba Gateway app

SIMBAGATEWAYAPP

EnableLicensePage

0/1

0 (Disabled)

TO DO Gateway Link

Enable users to manage Gateway Link via the Simba Gatewayapp

SIMBAGATEWAYAPP

EnableGWLSettings

0/1

0 (Disabled)

Use Legacy Angles Authentication Workflow

Use the legacy Angles authentication workflow (IDP selection for A4O and STS for A4S) when configuring anAngles connection profile.

SIMBAGATEWAYAPP

UseLegacyAnglesAuthWorkflow

0/1

1 (Enabled)

Troubleshooting

  1. Enable debug logging

    To enable debug logging in Simba Gateway, perform the following:

    1. Go to Command Prompt and select run as administrator.

    2. Go to the Simba Gateway.exe file location by entering the following command in the command prompt and click Enter on the keyboard.

      CD <install location where Simba Gateway.exe is available>

    3. Enter the following command and click Enter on the keyboard.

      "Simba Gateway.exe" --args --loglevel=6 --logpath=<Path to the folder where you want to download logs>

      The logs folder is created in the desired location. When you run into any issue while using Simba Gateway, you can check the logs folder to know the cause of the issue.

  2. Allow SSL decryption

    To allow SSL decryption for Simba Gateway, whitelist the following URLs:

    • *.windows.net

    • *.msidentity.com

    • *.b2clogin.com

    If you encounter any network or certificate-specific issue, to understand the issue in detail, run the following commands in the SSL Utility:

    1. openssl s_client -servername www.insightsoftware.com -connect www.insightsoftware.com:443

    2. openssl s_client -servername download.insightsoftware.com -connect download.insightsoftware.com:443
Published:

Configuring Simba Gateway

Introduction

Simba Gateway is a comprehensive connectivity solution that enables connections between a diverse variety of applications and data sources, and streamlines the process of connecting to your data.

Note: To use the Simba driver, configure network request interceptor tools such as Fiddler, Charles Proxy, or Netskope to allow self-signed certificates for seamless connectivity. These tools intercept and analyze HTTP/HTTPS data. If they are not configured to enable connections using self-signed certificates, they can cause communication problems between your application and the Simba driver.

Configure Simba Gateway for Excel reporting

SaaS

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle > Oracle EBS > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

On-premises

  1. Select Run from Windows, enter %PROGRAM DATA%\Magnitude\Simba\Simba Gateway, and click OK.

  2. Open Client.config file. In SIMBAGATEWAYAPP section, afterInitialSetup=0 step, enter the following and save the file:

    UseLegacyAnglesAuthWorkflow=1

    3. Configure Simba Gateway

    Note: If you are configuring Simba Gateway for On-premises offline version with identity provider, you have to provide your identity provider credentials after the entering the Angles Hub URL (Refer Step 3).

Configure Simba Gateway for Power BI reporting

SaaS

OCA reporting with Snowflake

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle. Select Snowflake > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

OCA reporting with Azure SQLDB

  1. Go to Simba Gateway. The Simba-Gateway Guided Setup window is displayed.

  2. Select Angles for Oracle. Select Oracle EBS > Next. The Angles for Oracle Configuration page is displayed.

  3. Enter the Angles Hub URL and select Connect. Perform the authentication. The Create Angles Connection Profile window is displayed.

  4. Select the required connection from the dropdown and select Create. The Connection profile is created.

Advanced

You can manually configure Simba Gateway features by making the changes to the Client.config.ini file, based on the following table:

Feature

Description

Configuration Section

Configuration Property

Values

Default

Add Connector from Package

Enable user to manually install ConnectorPackages

SIMBAGATEWAYAPP

EnableAddConnectorFromPackage

0/1

0 (Disabled)

Angles Application Environment

Enable users to toggle between different Anglesapplication environments

SIMBAGATEWAYAPP

AppEnvironmentType

development/staging/production

production

Angles Authentication Configuration

Enable users to manually update the authentication configuration for an Anglesapplication server.

SIMBAGATEWAYAPP

EnableAnglesAuthConfig

0/1

0 (Disabled)

Connector Catalog

Displays a list of Connectors available for theSimba Gateway app

SIMBAGATEWAYAPP

CatalogLocation

http url, or local file path prefixed with file:///

https://simba.com/products/Gateway/GatewayAdapterCatalog_2_8.json

Gateway Versions URL

URL that provides the latest version for different platforms

SIMBAGATEWAYAPP

GatewayVersionsURL

http url, or local file path prefixed with file:///

https://simba.com/products/Gateway/gatewayversion.json

Initial UseGuidedSetup

Enable users to download and install a Connectorand configure a Connection Profile the first timethey launch Simba Gateway

SIMBAGATEWAYAPP

InitialSetup

0/1

1 (Enabled)

License Management

Enable users to manage Connector Licensesvia the Simba Gateway app

SIMBAGATEWAYAPP

EnableLicensePage

0/1

0 (Disabled)

TO DO Gateway Link

Enable users to manage Gateway Link via the Simba Gatewayapp

SIMBAGATEWAYAPP

EnableGWLSettings

0/1

0 (Disabled)

Use Legacy Angles Authentication Workflow

Use the legacy Angles authentication workflow (IDP selection for A4O and STS for A4S) when configuring anAngles connection profile.

SIMBAGATEWAYAPP

UseLegacyAnglesAuthWorkflow

0/1

1 (Enabled)

Troubleshooting

  1. Enable debug logging

    To enable debug logging in Simba Gateway, perform the following:

    1. Go to Command Prompt and select run as administrator.

    2. Go to the Simba Gateway.exe file location by entering the following command in the command prompt and click Enter on the keyboard.

      CD <install location where Simba Gateway.exe is available>

    3. Enter the following command and click Enter on the keyboard.

      "Simba Gateway.exe" --args --loglevel=6 --logpath=<Path to the folder where you want to download logs>

      The logs folder is created in the desired location. When you run into any issue while using Simba Gateway, you can check the logs folder to know the cause of the issue.

  2. Allow SSL decryption

    To allow SSL decryption for Simba Gateway, whitelist the following URLs:

    • *.windows.net

    • *.msidentity.com

    • *.b2clogin.com

    If you encounter any network or certificate-specific issue, to understand the issue in detail, run the following commands in the SSL Utility:

    1. openssl s_client -servername www.insightsoftware.com -connect www.insightsoftware.com:443

    2. openssl s_client -servername download.insightsoftware.com -connect download.insightsoftware.com:443
For an optimal Community experience, Please view on Desktop