Is there a native mode for this like in FD/TD/ADDM?
I assume the next best (recommended) option would be export from Tideway in CSV and use AIE to import?
Yes...there is a native mapping set that uses mapping files that integrate using the API directly. You don't need to use CSV and AIE.