SAP ASE (Sybase)
Pre-requisites​
Check the supported versions​
DBmarlin supports versions of SAP ASE (Sybase) from 16 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.
Create a monitoring user with the correct permissions​
Before adding a target SAP ASE instance in the UI you should first create a dbmarlin user in the target database instance. Note you can choose to use a name other than dbmarlin if you prefer.
For SAP ASE you can create a monitoring user like this:
create login 'dbmarlin' with password 'securepassword' go
exec sp_locklogin 'dbmarlin', 'unlock' go
exec sp_role 'grant', 'mon_role', 'dbmarlin' go
# Needed for schema change detection
exec sp_role 'grant', 'sa_role', 'dbmarlin' go
Adding the Database Target​
This is done through the User Interface using the Add Database screen