Workbook can't switch data connection type

We are starting a project to move all of our data from SQL server to HANA. We have about 600 workbooks that will need to be modified. Is there a way to change the Workflow connection to a different 'type'? When I try to change the SQL connection, the only choices are other SQL connections.

Currently, it's possible to switch connections between connections of the same type.

Unfortunately, there isn't an “easy” way for migrating .twb files from one connection type to another - it would indeed require recreating all files with the new connection.