To be fair, you don't need mv.NET or mv.SSIS to move data between
jBase and Oracle, but those products can be used to help in some
applications. As a happy reseller for those products I'd like to see
new sites using them too, but as a technician I also think it's
important that this forum be used to provide all possible options so
that users can make better decisions.
mv.NET would need to extract your T24 data or query, pull that into a
middle-tier Windows server, connect to Oracle for the transaction,
then send the results back to T24. That's fine but if both T24 and
Oracle are in *nix systems, or on the system system, then you may not
want to use the Windows middle-tier.
One simple way to exchange data between jBase/T24 and any RDBMS is to
build and execute PL/SQL CRUD queries. jBASIC is great for string
processing and that's all a SQL query is, a long string of characters
that gets executed. So consider this contrived example (doesn't use
real banking schema):
acct = "AB1234"
value = 12345.67
* use backslashes below to avoid confusion with single quotes
cmd = \INSERT INTO oracle_trans\
cmd := \ (accountId, amount)\
cmd := \ VALUES ('\ : acct: \', \ : value : \);\
That builds a command that looks like this:
INSERT INTO oracle_trans (accountId, amount)
VALUES ('AB1234', 12345.67);
You would need to do something like that no matter what tools you're
using.
Now, executing that statement depends on where the Oracle system is,
what kind of connectivity you're using, and some other factors. You
could write that into a local file called query.sql and then create
another command to execute it. For example:
myuser = "foo"
mypsw = "bar"
mydb = "baz"
exec = \sqlplus \ : myuser : \/\ : mypsw : \@\ : mydb : \
@"/tmp/query.sql"\
execute "!":exec capturing out
In Windows you can avoid writing the query and do something like this:
exec2 = \sqlplus \ : myuser : \/\ : mypsw : \@\ : mydb : \ < \ : cmd
Use < for redirection.
Or in Windows that could be done something like this to echo the
result of the command:
exec3 = \sqlplus \ : myuser : \/\ : mypsw : \@\ : mydb
echo = \@echo \ : cmd : \ | \ : exec3
execute "!":echo capturing out
In *nix:
cmd2 = exec2 : \ <<EOF\
cmd2<-1> = cmd
cmd2<-1> = \EXIT;\ ; * required?
cmd2<-1> = \EOF\
execute "!":cmd2 capturing out
A much more rigorous wrapper can be placed around the sqlplus command
within a shell script so that you can essentially do this:
execute "!oracle INSERT INTO .."
In this case "oracle" is just an alias for something like
"./oracle.sh" or similar.
Those commands assume you have the sqlplus command on the same system
as jBase/T24, and that you have your environment variables set to
access Oracle via SQL*Plus. If not then you need to use some kind of
remote connectivity.
Final notes:
- The above is not checked for syntactical accuracy. It's scribbled to
serve as a basic example.
- If you're dealing with bank data, you need to be VERY careful about
security. The above mechanisms are NOT secure, from writing into the
file system to executing a command in a shelled process.
- mv.NET is no more or less secure. Whatever solution you use, you
need to adequately protect the data at each point of transit.
HTH
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
http://Nebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms
From: Mike Street
Manuel,
If you wish to continue using T24 but with Oracle as the data store,
then you need to talk to Temenos about this.
If you just wish to migrate the data to Oracle, then you should be
looking at mv.NET/mv.SSIS to help you migrate the data. Check the
BlueFinity web site for details of the products and obtaining
evaluations.
Mike
From: Manuel Chau
Sorry i didn't clarified my use case.
Yes it is involved T24 aplication, to be especific I have T24, using
jbase with Database and I need to migrate jbase for oracle.
2013/3/1 Mike Street
If T24 is involved here, it is possible to store data in Oracle or SQL
Server.
Otherwise, it is also possible to use the jBASE jEDI to accomplish
this.
If you want to move the data permanently or for reporting purposes,
you could make use of mv.NET/mv.SSIS.
Further information on all of this technology is available from the
jBASE and BlueFinity web sites.
Mike
From: Tony Gravagno
From the simple question below, there are too many unknowns for a
good answer. Please provide some clarifications and context.
The subject says "Eclipse". Should that be "Oracle"?
When you say "convert", please clarify:
- Has a site said they want to migrate entirely to Oracle? Including
the business rules?
- Is this a one-time conversion of all data, or is it going to be an
ongoing export from a system that will remain live?
- Do they want to run jBase BASIC rules against Oracle data?
- Does the site plan to migrate data only, without the rules?
From: Manuel Chau
How can I convert jbase databese to Oracle database.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
