Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

After you log into Sigma Studio, perform the following steps to create a database connection.

  1. Click Manage > Connectors.


    The Create New Connection page appears.

  2. Click DB option from the left menu.

  3. Select the database used for your application. By default, MSSQL appears selected.

  4. Enter an unique name for the connection in the Connection Name field.

  5. Enter the server name that hosts the database in the Host Name field. Use the database server's natted IP address in case direct IP is not working.

  6. Enter the server port number in the Port field.

    SID and Service Name fields are mutually exclusive, which means when SID is used, Service Name is not required and vice versa.

    • If you select MySQL as the database, enter the database or the schema name in DB/Schema Name field. 

    • If you select PostgreSQL as the database, enter the database name in DB Name field and the schema name in Schema Name field.

    • If Oracle 12c is the database, choose SERVICE NAME option and enter the database service name in the Service Name field. For Oracle 11g, choose SID option and enter the security identifier of the database in the SID field.
  7. Enter the user name to connect to the database in the User Name field.

  8. Enter the password to connect to the database in the Password field.

    To create connections on the SIR environment, it is required to use Natted IP information from the SIR's database server instead of the IP address from SQL developers. Kindly contact the IT team for the Natted IP information for any specific SIR environment. 

  9. Click Test. If the provided credentials are correct, a successful message appears else a failure message appears. If failure message appears, enter the correct credentials and click Test again.

  10. Click Save.

    When you try to exit the Connectors screen, before saving the configured database connection, a warning pop-up message appears, as shown in the following screen shot:

    • Click Cancel, if you do not want to exit the Connectors screen.
    • Click Ok, if you want to exit the Connectors screen.


    The database connection is established with the provided information. If the connection is successful, the following message appears:

After you create a DB connection, refer Create a DB Datasource. 

  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.