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
-