| Author |
Message |
Peter
*nix forums Guru
Joined: 01 Mar 2005
Posts: 535
|
 Posted: Sun Mar 13, 2005 7:56 pm Post subject:
Re: Loading data from multiple files
|
|
|
Mike
Thaks for the tip
Will it load data from Pivot tables? |
|
| Back to top |
|
 |
Malcolm Dew-Jones
*nix forums Guru
Joined: 04 Mar 2005
Posts: 418
|
| Posted: Mon Mar 07, 2005 7:22 pm Post subject:
Re: Loading data from multiple files
|
|
|
Peter_Jonson22@yahoo.co.uk wrote:
: Thanks for the suggestions.
: Sorry I did not make it clear I am actually looking for a GUI tool
: which can help me.
: Something which will alow my customer to define mapping between file
: and target table, specify file(s) to process and load data into the
: database.
: Scripting is way too complicated for the customers I am dealing with.
So write a script that shows a menu of options.
The user selects the menu option they want (including for example a file
to load). Your script converts that into a sql loader file that loads the
file. Then it displays the resulting log files in some organized manner.
You can make it as pretty and gui as you wish.
Hardest part is probably to display an easy, controlled, file select. On
Windows use Perl Tk::FileSelect, or visual basic (GetOpenFileName()?), or
there are myriad other options - perhaps really impress them by sending an
outlook mail message with a built in form that drives the load process and
sends any series error conditions back to the help desk...
Even a couple of DOS-ish batch files would probably work in a pinch -
hardest part would be selecting the files in that case.
$0.02
--
This space not for rent. |
|
| Back to top |
|
|
Mike
*nix forums beginner
Joined: 07 Mar 2005
Posts: 1
|
| Posted: Mon Mar 07, 2005 6:48 pm Post subject:
Re: Loading data from multiple files
|
|
|
Looks like we've got a tool you are looking for
VImp loads data from multiple tables or files into Oracle MS Sql Server
or any ODBC compliant Database
http://www.dbsoftlab.com/download.php?view.5
Mike |
|
| Back to top |
|
|
Peter_Jonson22@yahoo.co.u
*nix forums beginner
Joined: 06 Mar 2005
Posts: 3
|
| Posted: Mon Mar 07, 2005 11:56 am Post subject:
Re: Loading data from multiple files
|
|
|
It is windows 2000 and Oracle 9i if it will help
Peter |
|
| Back to top |
|
|
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Mon Mar 07, 2005 10:55 am Post subject:
Re: Loading data from multiple files
|
|
|
Peter_Jonson22@yahoo.co.uk wrote:
| Quote: | Thanks for the suggestions.
Sorry I did not make it clear I am actually looking for a GUI tool
which can help me.
Something which will alow my customer to define mapping between file
and target table, specify file(s) to process and load data into the
database.
Scripting is way too complicated for the customers I am dealing with.
Peter,
U.M.G.I
|
What is your Oracle version and OS that you are working with?
How do you want to load data into the database,
1) Push it into the database using e.g. SQL*Loader?
2) Pull it into the database from flat files using e.g. utl_file
package?
Google does not charge by the number of characters you post... feel
free to provide as much detail as you can.
Regards
/Rauf |
|
| Back to top |
|
|
Shamil ZALYALOV
*nix forums beginner
Joined: 22 Feb 2005
Posts: 2
|
| Posted: Mon Mar 07, 2005 10:54 am Post subject:
Re: Loading data from multiple files
|
|
|
I guess you even know it - it's Oracle Warehouse Builder.
More info at: http://www.oracle.com/technology/products/warehouse/index.html
Cheers,
Shamil
<Peter_Jonson22@yahoo.co.uk> wrote in message
news:1110191801.003272.237100@f14g2000cwb.googlegroups.com...
| Quote: | Thanks for the suggestions.
Sorry I did not make it clear I am actually looking for a GUI tool
which can help me.
Something which will alow my customer to define mapping between file
and target table, specify file(s) to process and load data into the
database.
Scripting is way too complicated for the customers I am dealing with.
Peter,
U.M.G.I
|
|
|
| Back to top |
|
|
Peter_Jonson22@yahoo.co.u
*nix forums beginner
Joined: 06 Mar 2005
Posts: 3
|
| Posted: Mon Mar 07, 2005 9:36 am Post subject:
Re: Loading data from multiple files
|
|
|
Thanks for the suggestions.
Sorry I did not make it clear I am actually looking for a GUI tool
which can help me.
Something which will alow my customer to define mapping between file
and target table, specify file(s) to process and load data into the
database.
Scripting is way too complicated for the customers I am dealing with.
Peter,
U.M.G.I |
|
| Back to top |
|
|
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Mon Mar 07, 2005 8:58 am Post subject:
Re: Loading data from multiple files
|
|
|
Peter_Jonson22@yahoo.co.uk wrote:
| Quote: | Hi.
I have to load data from our order processig system into the
Datawarehouse.
File name format is dataDDMMYYYY.txt for example
data01012005.txt etc.
Is there any way to specify a mask wnen i want to reload data for
specific month or year?
Peter
|
To see e.g. all files for month 012005 do,
C:\> dir /b data*012005.txt
$ ls -b data*012005.txt
You can script it any way you want.
Regards
/Rauf |
|
| Back to top |
|
|
Mark C. Stock
*nix forums Guru
Joined: 05 May 2005
Posts: 730
|
| Posted: Sun Mar 06, 2005 11:23 am Post subject:
Re: Loading data from multiple files
|
|
|
<Peter_Jonson22@yahoo.co.uk> wrote in message
news:1110110331.468485.74240@z14g2000cwz.googlegroups.com...
| Quote: | Hi.
I have to load data from our order processig system into the
Datawarehouse.
File name format is dataDDMMYYYY.txt for example
data01012005.txt etc.
Is there any way to specify a mask wnen i want to reload data for
specific month or year?
Peter
|
SQL Loader?
If OS command line wildcards won't do it for you, try shell scripting or
windows host scripting to generate the load scripts and commands.
++ mcs |
|
| Back to top |
|
|
Peter_Jonson22@yahoo.co.u
*nix forums beginner
Joined: 06 Mar 2005
Posts: 3
|
| Posted: Sun Mar 06, 2005 10:58 am Post subject:
Loading data from multiple files
|
|
|
Hi.
I have to load data from our order processig system into the
Datawarehouse.
File name format is dataDDMMYYYY.txt for example
data01012005.txt etc.
Is there any way to specify a mask wnen i want to reload data for
specific month or year?
Peter |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
