Hello,
Which database server are you referring to? With XData you can have any server-side logic you want, nothing prevents you from using any component for db access and do whatever you want.
Thank you, if I understand correctly no way to create internal database to store passwords, for example?
What do you mean by "internal database"? You can use SQLite for example to create an SQLite database in a local folder, or even in memory. Is that what you mean?
What I need that create encrypted data storage on the fly using my software only, and replicate this data to clients to allow this clients works offline and commit changes which created offline when clients will be online (connected to the my server part).
You can try to create a SQLite database using FireDac and check if their encryption feature fits your needs: http://docwiki.embarcadero.com/CodeExamples/Tokyo/en/FireDAC.SQLite_Encryption_Sample
That is what I need, thanks. Please what next steps to use TMS with this created database? I'm novice with TMS, now I'm use mORMot.
Have you seen the available material? Documentation, videos, blog posts, etc.? It's hard to answer you without knowing what you know and what you don't know. If you don't know anything at all, I suggest you start with existing documentation.