Originally posted by: Bhupendra2087

Hello All,

I am very new to WTX, as my project demands to work on wtx. SO learning and doing some small POCs.

So I wanted to fetch details from a DB Table ( contains Name, id, Salary and Address) and wanted to Transform to XML( Input as db file and Output as xml).

I have created .mtt( type tree for db and xml-xsd). and also created Map. but when I am running the map, it says "Source not Available".

I have used database interface Designer to create .mtt as Input, but I believe I need give Input file in Input Card( in other option I have give .mdq file which contains an simple Select Query).

Please guide me what I have missed so I am getting "Source Not available" Error. I am using DB2 as database.-Attached the screenshot and files.

Appreciate your help !!

Thanks

Originally posted by: PaulBrett

You have a query specified in the card, where the database connection details need to be.  An example 'command':

-DBTYPE db2 -SOURCE sample  -USER pbrett -PASSWORD password -T

....and the query is stored in the MDQ, which is read at compile time, and compiled into the map.

Alternatively you could use:

-MDQ Database_QueryFile1.mdq -DBNAME bd2admin -QUERY select

....to have the query read from the MDQ file at runtime.

Thank you.

Paul

Follow me on Twitter