Hi all,

I have an SQL Server machine, if I have a specific
table, or tables, can I create some type of DTS script
that replicates or appends all data to JDE at a certain
hour during the day? Our JDE runs on AS/400.

Thanks

Yes. We have World running on the AS400 and One World on SQL Server. We do
feeds hourly between the two using IBM's Client Access drivers.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Manat K." <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

Really, that's very interesting, thanks for the reply!!
Would you be able to tell me a little more about it's
architecture, if you have any links for installing
OneWorld on SQL Server, and also which IBM client access
drivers you are using. I would appreciate any info you
can provide.

Thanks
MK

We use the Client Access driver 5.00.08.00. W use DTS to pick up records
from the AS400 and we then load to the SQL Server. We also do it the other
way around as some parts of our financial system are still on the AS400.
Don't know why but the business likes it like that ?????

No special config really on the driver.

Add you relevant libraries
For performance you can tweak the data size
We have Translate CCSID 65535 set to true

It can be a bit slow waking up the driver but once it gets going it's fine.
There is a client Express driver as well which is more recent I believe but
we use the one I mentioned.

When JDE One World is installed it comes with an awful lot of indexes on a
lot of tables. I would alalyse their usage in your environment and remove
unnecessary ones.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Manat K." <anonymous (AT) discussions (DOT) microsoft.com> wrote