NoelA
Member
Hi All,
I would like to create a JDE application to access historical data from our old GL. This data has been ported to a separate SQL7.0 database on the JDE database server.
I have created a data source and environment to the database as per instructions in JDE document ott-99-0045 (Table Conversion - preparing a foreign table data source).
I can see the foreign tables in the Table Conversion Input Table tab. So i think that i have set this part up correctly.
From the FDA I still cannot see the tables (or use table I/O) to get at the tables in this DB.
Researching jdelist i see that Sebastian Sajaroff answered this question briefly by saying that: "you have to create this datasource on OneWorld and all its related tables as OW regular objects."
Sebastian, can you or anyone, else elaborate what is meant by the second part of the answer. ie: create related tables.
Do i have to create these tables using the TDA?
The tables already exist in the DB with data, though not in the JDE Object librarian. If so, am i right in thinking that the data in the table will get blown away when i generate the table?
Or am i way off track?
Cheers and thanks in advance,
Noel
B7332 SP11.1 SQL7.0 NT4.0 Fat & Citrix 1.8
Noel Adlington
Financial Systems Admin
Nelson Marlborough District Health Board
New Zealand
I would like to create a JDE application to access historical data from our old GL. This data has been ported to a separate SQL7.0 database on the JDE database server.
I have created a data source and environment to the database as per instructions in JDE document ott-99-0045 (Table Conversion - preparing a foreign table data source).
I can see the foreign tables in the Table Conversion Input Table tab. So i think that i have set this part up correctly.
From the FDA I still cannot see the tables (or use table I/O) to get at the tables in this DB.
Researching jdelist i see that Sebastian Sajaroff answered this question briefly by saying that: "you have to create this datasource on OneWorld and all its related tables as OW regular objects."
Sebastian, can you or anyone, else elaborate what is meant by the second part of the answer. ie: create related tables.
Do i have to create these tables using the TDA?
The tables already exist in the DB with data, though not in the JDE Object librarian. If so, am i right in thinking that the data in the table will get blown away when i generate the table?
Or am i way off track?
Cheers and thanks in advance,
Noel
B7332 SP11.1 SQL7.0 NT4.0 Fat & Citrix 1.8
Noel Adlington
Financial Systems Admin
Nelson Marlborough District Health Board
New Zealand