Manual Connecting without Storing Credentials

Connect to Oracle Databases

Once databases are added, this class can be used to instantiate an object for the proper database name. The instance will have a create_engine method that should be used with just username and password.

class dsdbmanager.oracle_.Oracle(db_name: str, host_dict: Dict[str, Dict[str, Dict[str, str]]] = None)
create_engine(user: str = None, pwd: str = None, **kwargs)
Parameters:
  • user – username
  • pwd – password
  • kwargs – for compatibility/additional sqlalchemy create_engine kwargs
Returns:

sqlalchemy engine

Connect to Mysql Databases

Once databases are added, this class can be used to instantiate an object for the proper database name. The instance will have a create_engine method that should be used with just username and password.

class dsdbmanager.mysql_.Mysql(db_name: str, host_dict: Dict[str, Dict[str, Dict[str, str]]] = None)
create_engine(user: str = None, pwd: str = None, **kwargs)
Parameters:
  • user – username
  • pwd – password
  • kwargs – for compatibility/additional sqlalchemy create_engine kwargs
Returns:

sqlalchemy engine

Connect to Mssql Databases

Once databases are added, this class can be used to instantiate an object for the proper database name. The instance will have a create_engine method that should be used with just username and password.

class dsdbmanager.mssql_.Mssql(db_name: str, host_dict: Dict[str, Dict[str, Dict[str, str]]] = None)
create_engine(user: str = None, pwd: str = None, **kwargs)
Parameters:
  • user – username
  • pwd – password
  • kwargs – for compatibility/additional sqlalchemy create_engine kwargs
Returns:

sqlalchemy engine

Connect to Teradata Databases

Once databases are added, this class can be used to instantiate an object for the proper database name. The instance will have a create_engine method that should be used with just username and password.

class dsdbmanager.teradata_.Teradata(db_name: str, host_dict: Dict[str, Dict[str, Dict[str, str]]] = None)
create_engine(user: str = None, pwd: str = None, **kwargs)
Parameters:
  • user – username
  • pwd – password
  • kwargs – for compatibility/additional sqlalchemy create_engine kwargs
Returns:

sqlalchemy engine