How to join application database and Framework databases tables in same data adapter query

Hi Chand,

you may actually query both app and framework db using a single SQL query against the application db.

E.g. in the example below we are joining journal headers with usernames info. Please note the syntax left join [schemaName].[defaultUser].[tableName] (e.g. OneStream_Framework.dbo.SecUser).

Please note: this approach works if both app and framework db are hosted on the same db server. Furthermore, you may have to use another db schema if the framework db is named differently (you could check this in System tab > Environment). 

select
t.UniqueID
,t.Name As JournalName
,t.Description
,u.Name As PostedUserName
,u.Description As PostedUserDesc
,t.PostedTimeStamp

from JournalHeader t
left join OneStream_Framework.dbo.SecUser u on u.UniqueID=t.PostedUserID