cancel
Showing results for 
Search instead for 
Did you mean: 

Sql query as Source

Former Member
0 Kudos

i have sql query wich gives me the result set.This query has many tables with joins.

How can i use this query to load the data into destination table in BODS.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member189153
Active Participant
0 Kudos

Hi Samuel,

Use SQL transform, if your query statement having single SELECT statement.

former_member205887
Active Participant
0 Kudos

Use SQL Transform as Source and paste your query in the SQL Text field, select appropriate Database type and Datastore....