Hi everyone, We use FME 2015 database edition for writing data from Smallworld to Oracle via SBS plugin. We are planning to replace Oracle with SQL Server or SAP Hana and would like to know if the connection settings would be similar to Oracle ?

@bgogulapati​ The connection parameters will depend on the target database - and whether it's a cloud or on premise database or JDBC. See the documentation for the SQL Server and SAP Hana formats

You don't need to rebuild your workspace.

For FME 2018 and earlier: to switch from the Oracle Writer to, say, SQL Server.

• Add the new writer, SQL Server Spatial say. On the Add Writer dialog, under Table Definition, select None.

• you now have two writers visible in the workbench Navigator panel
• On any Oracle writer Feature Type - open the Feature Type parameters.
• On the Writer parameter, select the SQl Server writer from the list. this will switch all the feature types to the new writer format

For FME 2019 and later - it's a lot easier.

• in the Workbench Navigator, select the Oracle writer and select Update Writer... from the pop-up menu
• In Update Writer dialog, switch the Oracle format to SQL Server. Set-up the connection parameters. Click OK. All the Feature Types will switch to SQL Server.