Connectors – Create a Database Connection

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

1. Click Manage > Connection.
   
   
   
   The Create New Connection screen appears.
   
   
   
   

2. Click DB option from the left menu.

3. Select the database used for your application, e.g. Oracle. By default, MSSQL appears as the selected database.

4. Enter a 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 if the 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 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. If required, enter the connection pool size in the Pool Size field, e.g. 30. The Pool Size field is used to determine the connection thread count. This is an optional field.

   Pool Size is used to indicate the count of the connection pool threads for a dynamic database. Based on the provided value (e.g. 30) in the Pool Size field, the size of the connection pool threads will determine the usage of database connections while the connection pool gets initialized.

10. If required, enter the query timeout period in the Query Timeout field, e.g. 60. This is an optional field.

    Query Timeout should be specified only in seconds. It is is used to terminate the execution of queries in a report, with regard to the specified period of the query timeout process. For instance, if the query timeout is specified as 60, the timeout period or interval is one minute. The execution of queries should take place within the stipulated query timeout period of 60 seconds or 1 minute. For the query-based reports, if the query execution process exceeds the one-minute mark, then the report will not generated in Sigma Application, as the execution of queries will be terminated once the specified time of 60 seconds (1 minute) ends. So, it must be ensured that the queries used in a data source to configure a report will get executed within the stipulated query timeout period of sixty seconds or one minute.

    
    
    
    

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

12. Click Submit.

    When you try to exit the Create New Connection 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 Create New Connection screen.
    • Click Ok, if you want to exit the Create New Connection screen.

    
    
    
    A success confirmation message appears:
    
    

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