DSXchange

I am new to datastage TX . I have Installed only Client of 8.0 Datastage TX on windows machine.

My goal is to create flat file file from data in table of oracle database.
My Source is DB and target is File (Pipe delimeter)

I have created Input Card and output Card in Map designer.

Steps which I did
1> In database interface designer , I was able to connect to db through database interface designer and created Database_QueryFile1.mtt

2> In TX Designer Studio I used Type Tree -- > Database_QueryFile1.mtt
Input Card - Get --> Source --> DATABASE
Get-->Source-->Command --> Tried various combination
of "-DBTYPE ORACLE " and other commands ..without luck.

I can compile the map ..When I try to run it It gives me Source Not available error.

Help me in resolving this error or please list steps How should I develop this map.
Are their any tutorials available ?

Thank You,

Using 8.0, 8.1 or 8.2?

Before executing the map you need to check Db conncetion with you Mechine by creating ODBC , In oDBC driver you can chek connceted DB succssfully or Not , on the other way Make sure that you have Oracle clinet install in your mechine.Good luck

sjanai wrote:I am new to datastage TX . I have Installed only Client of 8.0 Datastage TX on windows machine.

My goal is to create flat file file from data in table of oracle database.
My Source is DB and target is File (Pipe delimeter)

I have created Input Card and output Card in Map designer.

Steps which I did
1> In database interface designer , I was able to connect to db through database interface designer and created Database_QueryFile1.mtt

2> In TX Designer Studio I used Type Tree -- > Database_QueryFile1.mtt
Input Card - Get --> Source --> DATABASE
Get-->Source-->Command --> Tried various combination
of "-DBTYPE ORACLE " and other commands ..without luck.

I can compile the map ..When I try to run it It gives me Source Not available error.

Help me in resolving this error or please list steps How should I develop this map.
Are their any tutorials available ?

Thank You,

"In TX Designer Studio I used Type Tree -- > Database_QueryFile1.mtt
Input Card - Get --> Source --> DATABASE
Get-->Source-->Command --> Tried various combination
of "-DBTYPE ORACLE " and other commands ..without luck. "

Try "-t' in command
point to mdq file, database and query in the databasequery option.

trace file will help you debug.

What client are you using?

Make sure all the DB values like username ,host adress and pwd are correct .

Hi,
You can find some sample solutions on you machine ,when you install the software on your machine , try to find out these solutions on you machine
at location "C:\Ascential\DataStageTX_8.0\tutorial\solution",try to extract
these and go one by one,some of those solutions provide way of transferring data from database to flat files.

Database Query File options - File, Database, Table. Have you ensured these values have been entered. After you enter file, Database is a dropdown.
Alos post the map trace and the *dbl file that got created after turning db trace on.