Atpresent we are using separate database (MSSQL Server 2008) for each FDM applications, now our databases have increased in numbers due to increase in number of applications.
Now we are searching for any possibility to use a single database for more than one different FDM applications inorder to reduce the new database creation numbers in future.
Any suggestions would be greatly helpful.
Yes. Reduce the number of FDM applications you are creating. You can have multiple target system adapters in a single FDM application (i.e. a single database only required). There is no need to create a new application for each target system.