I don´t think you can connect Financial Reporting to relational database, you would not be able to query FDM sql data.
Why don´t you use FDM reports?
Thank you, F.Amores
The problem with FDM reports is that I want to insert dinamic pivots there and worry if it's possible. I can't find such reports between standard ones. For example I want to show all accounts horizontally and all locations vertically and total amounts in their crosses. If it's possible I would like to look at examles, else I wonder how to get this round.
You can build custom reports to use custom SQL query.
You could configure one report such as:
Location AccountA AccountB AccountC
Location1 10000 12311 32423
Location2 21311 50000 20000
I would suggest you start with your SQL query (SQL Developer, MSSQL Studio, Toad...) and try to get data in your format.
Then you can create a report and test this query in SQL Preview to see if it is working (sometimes SQL queries have some restrictions when being used in reports)
Once you have your data in the SQL preview you can build your report to show it.