def get_jdbc_url(config_dict, dialect='sqlserver'):
    """Retrieve the jdbc url connection string, given a DataBase dialect.

    Args:
        config_dict (dict): Dictionary with configuration details: first key is the dialect, then 'server', 'port',
            'database', 'user', 'pw'
        dialect (str): The SQL dialect of the database, like 'sqlserver'

    Returns:
        str: a string for the jdbc connection to the database.
    """
    jdbc_url = "jdbc:{dialect}://{server}:{jdbcPort};database={database};user={user};password={pw}".format(
        dialect=dialect,
        server=config_dict[dialect]['server'],
        jdbcPort=config_dict[dialect]['port'],
        database=config_dict[dialect]['database'],
        user=config_dict[dialect]['user'],
        pw=config_dict[dialect]['pw']
    )
    return jdbc_url