Problem

When trying to create an Insert database map (Mysql) in Mapping Services using Wizard, a table having several columns appears, but the wizard only creates a Database BDOC with 1 field of type novalue.

Resolution

Make sure that you are using MS 3.6 UP2023-10

1. In the Mapping Services go to Database Drivers -> Database name property -> add DBNAME
2. Create a new Database Server using the above Database Drivers
3. Create a new project
4. Create a new map

Also check the below documentation: https://docs.axway.com/bundle/MappingServices_36_UsersGuide_DML_allOS_en_HTML5/page/Content/DML_UG/Preferences/connection_remote_database.htm

Axway Documentation Portal