Skip to main content

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