Can DataStage be used w/out lan

sweetleaf · Post by **sweetleaf** » Fri Jan 24, 2003 3:30 pm

Hi there,

I will have no network/internet connection.
I have DataStage installed on my pc, and a local oracle db installation.
I'd like to have DataStage "read" a csv on my pc into a local oracle table.

Is this possible?

Thanks

vmcburney · Post by **vmcburney** » Fri Jan 24, 2003 4:11 pm

DataStage will run on a stand alone NT machine. Since your source and destination are also on that machine you should not have a problem.

regards
Vincent

ray.wurlod · Post by **ray.wurlod** » Fri Jan 24, 2003 9:33 pm

You will need some kind of connection, for example TCP/IP loopback (use address 127.0.0.1). You will also need to have your Oracle client correctly configured, particularly the environment variables such as ORACLE_HOME.
But, yes, it works quite happily; I've had such a configuration on various laptops over the years and run demonstrations and even some classes on the combination.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

sweetleaf · Post by **sweetleaf** » Sat Jan 25, 2003 1:02 pm

Hi guys,

Thanks so much for your responses!
I forgot to mention that I have DataStage Client installed on my machine.
Basically whats happened is that I've been requested to import data into our existing oracle db(but i want to practice doing this on my own local db before i do anything on the network db).
A consultant installed the client software on my laptop. Currently, when i open up DataStage and am prompted to connect to the host system, I enter a network IP and a username and password. That IP is a solaris box.
Instead, I'd like to be able to log into DataStage on my own laptop - is this even possible?
If so what do enter for an IP, and what username and password do I use?

Thanks again!

ray.wurlod · Post by **ray.wurlod** » Sat Jan 25, 2003 3:59 pm

Alas, to achive this you will need to spend more $$$$ to get a copy of DataStage server for Windows (and your machine will need to be running an appropriate O/S - that is WinNT, Win2K or (and I have some doubt about this) WinXP.

vmcburney · Post by **vmcburney** » Sat Jan 25, 2003 5:31 pm

Or you could buy your own Sun Solaris server!

ray.wurlod · Post by **ray.wurlod** » Sun Jan 26, 2003 1:01 am

Either way, you have to spend $$$$ for second machine license.
[B)]