@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.