Establish a connection to GST — GSTPy documentation

# Establish a connection to GST

## Postgres

    import GSTPy

    # The name of the GST user used as login
    user = "gstpy_user"
    # The password of that user
    password = "gstpy_user_pw"
    # The hostname or ip address of the database instance
    host = "localhost"
    # The port of the database instance
    port = 5432
    # The name of the database instance
    db = "gstpy"

    # Call get_pg_connection with the required parameters
    ni = GSTPy.get_pg_connection(user, password, host, port, db)

## Oracle

    import GSTPy

    # The name of the GST user used as login
    user = "gstpy_user"
    # The password of that user
    password = "gstpy_user_pw"
    # The hostname or ip address of the database instance
    host = "localhost"
    # The port of the database instance
    port = 1521
    # The service name of the database instance
    service = "gst"
    # The schema of the database instance
    schema = "gstpy"

    # Call get_ora_connection with the required parameters
    ni = GSTPy.get_ora_connection(user, password, host, port, service, schema)

## GST3

    import GSTPy

    # The name of the GST user used as login
    user = "gstpy_user"
    # The password of that user
    password = "gstpy_user_pw"
    # The hostname or ip address of the gst3 instance
    host = "localhost"
    # The port of the gst3 instance
    port = 50051
    # The file path to the DER encoded client SSL certificate
    client_cert = r"C:\GST\cert\gst3.der"

    # Call get_gst3_connection with the required parameters
    ni = GSTPy.get_gst3_connection(user, password, host, port, client_cert)

See also

`get_pg_connection()`

`get_ora_connection()`

`get_gst3_connection()`