Page 1 of 1

Load Data from flat file into PSDB

Posted: Wed Feb 02, 2005 7:47 am
by mandyli
HI

I am new to profile stage. already we are created Sorce database connection. I want to load some flat file into PSDB .

please help me.


Thanks
Man

Posted: Wed Feb 02, 2005 4:04 pm
by vmcburney
ProfileStage investigates the data through ODBC drivers. You need to set up an ODBC flat file driver that points to the flat files you are trying to profile. You can then commence the process.

Posted: Thu Feb 03, 2005 12:40 am
by mandyli
Thanks ya ..

Posted: Thu Feb 03, 2005 6:33 am
by mandyli
Hi vmcburney ,


as per Profile stage Install guide i created DSN for SouthBreeze. I have one doubt some one said . i need to create client and server both side DSN with same name.


I create DSN and given database path name following path in the client PC.

E:\Ascential\ProfileStage\Client\Samples\SouthBreeze .


still i can't able to access SouthBreeze DSN.

please help.


Thanks
Man

Posted: Sat Feb 05, 2005 4:12 am
by mdan
Hi mandyli,
1) use Ascential drivers. You may install them from (almost) any Ascential CD.
2) you may want to check if your DSN is working from any ODBC enabled software, even from MS Access (create a linked table, you'll get a series of warnings from ascential driver regarding license that you may ignore it)
3) Check if you have QETXT.INI file in E:\Ascential\ProfileStage\Client\Samples\SouthBreeze folder. If not, check if your DSN is listed in ODBC manager.
4) use system DSN

BR,
Dan
mandyli wrote:Hi vmcburney ,


as per Profile stage Install guide i created DSN for SouthBreeze. I have one doubt some one said . i need to create client and server both side DSN with same name.


I create DSN and given database path name following path in the client PC.

E:\Ascential\ProfileStage\Client\Samples\SouthBreeze .


still i can't able to access SouthBreeze DSN.

please help.


Thanks
Man