Rahul Vaneldas
Member
Hi all,
We have a external database (SQL) and JDE E.900 System (SQL).We want a JDE application to inquire/Add/Update external database.Currenly we are planning not to use table conversion as it is very lengthy procedure.
External Database have name like 0-MCU,N-MCU.Client is trying to merge all instance of company into one instance.For that he is using Old-MCU, New -MCU.As they have named it like 0MCU,NMCU we can not directly map this columns to JDE Table as JDE tables have prefix + ALIAS NAME.
Currently we have come with the a solution.For the external database we created a business view with the columns name matching with the JDE Table(For ex.If i have created a JDE Table as ABAN8,ABALPH,ABAT1..Then my external database view will renamed as ABAN8,ABALPH,ABAT1) so my external business view and JDE Table can map to each other.
For this we have created JDE Table and we have not generated it,and created a business view over JDE Table.
Now we want to set up connection between JDE Table and external business view so that we can use JDE application to inquire/add/update external database.
Attached document contain how we created external database view and JDE Table and JDE business view.
I tried to find but could not get any solution.I request all of you to please post on it,we are in urgent need.
Thanks in advance
Rahul vaneldas
E9.00 - Technical consultant.
Database - SQL
We have a external database (SQL) and JDE E.900 System (SQL).We want a JDE application to inquire/Add/Update external database.Currenly we are planning not to use table conversion as it is very lengthy procedure.
External Database have name like 0-MCU,N-MCU.Client is trying to merge all instance of company into one instance.For that he is using Old-MCU, New -MCU.As they have named it like 0MCU,NMCU we can not directly map this columns to JDE Table as JDE tables have prefix + ALIAS NAME.
Currently we have come with the a solution.For the external database we created a business view with the columns name matching with the JDE Table(For ex.If i have created a JDE Table as ABAN8,ABALPH,ABAT1..Then my external database view will renamed as ABAN8,ABALPH,ABAT1) so my external business view and JDE Table can map to each other.
For this we have created JDE Table and we have not generated it,and created a business view over JDE Table.
Now we want to set up connection between JDE Table and external business view so that we can use JDE application to inquire/add/update external database.
Attached document contain how we created external database view and JDE Table and JDE business view.
I tried to find but could not get any solution.I request all of you to please post on it,we are in urgent need.
Thanks in advance
Rahul vaneldas
E9.00 - Technical consultant.
Database - SQL