Home » Developer & Programmer » Warehouse Builder » How to load data from excel to OWB....!!! Urgent.
How to load data from excel to OWB....!!! Urgent. [message #186998] Thu, 10 August 2006 08:35 Go to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
The steps I followed was
1) I created DSN for my Excel File as ODBC2XL ( I configure the Excel file which is available in my Desktop.)

2) I created initExcel_SID.ora file in the d:\oracle9i\ora9\hs\admin
such as
HS_FDS_CONNECT_INFO = odbc_excel
HS_AUTOREGISTER = TRUE
HS_DB_NAME = hsodbc

3) I created listener in d:\oracle9i\ora9\NETWORK\ADMIN
such as
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = Excel_SID)
(ORACLE_HOME = d:\oracle9i\ora9)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle9i\ora9)
)
)

4) Then I created an ODBC Source Module and a Database Link
Such as
DB Link Name : EXcel_dblink
Host Name : localhost (I am running at server)
Port Number : 1521
Oracle Service Name : Excel_SID

Enable the Use for Heterogeneous Services

User Name : user
Password : user

If I test this, i got following error.

Testing ....
success..

After mapping is created and at the time of deployment I got 6 warnings
They are

ORA-06550: line 16, column 25:
PL/SQL: ORA-04052: error occurred when looking up remote object <unspecified>.Sheet1$@EXCEL_SID.US.ORACLE.COM@DEST_LOCATION_EXCEL_SOURCE_LOC
ORA-00604: error occurred at recursive SQL level 1
ORA-02019: connection description for remote database not found

Its very urgent for my application....

Thanks and regards
gowtham sen.
Re: How to load data from excel to OWB....!!! Urgent. [message #406453 is a reply to message #186998] Thu, 04 June 2009 01:58 Go to previous messageGo to next message
srigp
Messages: 1
Registered: June 2009
Junior Member
Hi Gowtham,
Did you get the solution for this problem? If yes, could you please explain how you resolved the problem. It is very urgent for me.

Thanks
SriGP
Re: How to load data from excel to OWB....!!! Urgent. [message #411110 is a reply to message #186998] Thu, 02 July 2009 00:24 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

As per my knowledge, you can achieve data from excel to a table using (external files). For this you need to create a folder, and place the file in oracle server.
Previous Topic: Loading flat files from a folder into a single table (CLOB)
Next Topic: Clean data profile?
Goto Forum:
  


Current Time: Sat Dec 10 20:18:24 CST 2016

Total time taken to generate the page: 0.11642 seconds