Menu
AWS Database Migration Service
User Guide (Version API Version 2016-01-01)

Using a SAP ASE Database as a Target for AWS Database Migration Service

You can migrate data to SAP Adaptive Server Enterprise (ASE)–formerly known as Sybase–databases using AWS DMS, either from any of the supported database sources.

SAP ASE version 15.7 and later are supported.

Prerequisites for Using a SAP ASE Database as a Target for AWS Database Migration Service

Before you begin to work with a SAP ASE database as a target for AWS DMS, make sure that you have the following prerequisites:

  • You must provide SAP ASE account access to the AWS DMS user. This user must have read/write privileges in the SAP ASE database.

  • When replicating to SAP ASE version 15.7 installed on a Windows EC2 instance configured with a non-Latin language (for example, Chinese), AWS DMS requires SAP ASE 15.7 SP121 to be installed on the target SAP ASE machine.

Extra Connection Attributes When Using SAP ASE as a Target for AWS DMS

You can use extra connection attributes to configure your SAP ASE target. You specify these settings when you create the target endpoint. The following table shows the extra connection attributes available when using SAP ASE as a target:

Name Description

enableReplication

Set to Y to automatically enable SAP ASE replication. This is only required if SAP ASE replication has not been enabled already.

additionalConnectionProperties

Any additional ODBC connection parameters that you want to specify.

Note

If the user name or password specified in the connection string contains non-Latin characters (for example, Chinese), the following property is required: charset=gb18030