E8.12 Direct read-only DB access to in-house app

Rauf

Rauf

VIP Member
Is there any issue if I give direct read-only DB access to a non-JDE applications ( developed in Microsoft .NET). These application are developed in-house. Or should I go through the lengthy interoperability procedures.
 
No issues with letting other non-JDE applications read from the JDE DB, we do it all the time. A few caveats. Obviously, depending on the types of queries this could introduce contention in the DB if the queries are poorly designed. You will also have to deal with data conversion for things like dates and implied decimals on numeric data types.
 
Ditto to Brian's post. In addition we also allow some special programs and SQL script to write direct to the DB tables.
 
there are 2 sides to this: Technical and compliance.
Technically you might not have any issue depends on your design and can be resolve within IT technical group. Here issues are mainly related to performance.
On the other hand, compliance issue can be a whole different game. Depending your company SOP related to this it might be a non issue or could be a big issue. IF your company have confidential production data then you might want to check how you can seperate/secured them with your new application connecting your DB.
 
there are 2 sides to this: Technical and compliance.
Technically you might not have any issue depends on your design and can be resolve within IT technical group. Here issues are mainly related to performance.
On the other hand, compliance issue can be a whole different game. Depending your company SOP related to this it might be a non issue or could be a big issue. IF your company have confidential production data then you might want to check how you can seperate/secured them with your new application connecting your DB.
 
So there is no harm if we do proper data conversion :)
One other thing to add. We actually added in two Scalar-Valued Functions directly into the JDE Business Data DBs that can help with the date part of the data conversion. You can also obviously do the conversion at the app level (which we also do) but sometimes its easier to do it right in the query.

JDEJulian2Date - converts JDE date in DB to a SQL date type
Date2JDEJulian - converts a SQL date type to JDE Julian number
 
One other thing to add. We actually added in two Scalar-Valued Functions directly into the JDE Business Data DBs that can help with the date part of the data conversion. You can also obviously do the conversion at the app level (which we also do) but sometimes its easier to do it right in the query.

JDEJulian2Date - converts JDE date in DB to a SQL date type
Date2JDEJulian - converts a SQL date type to JDE Julian number
Absolutely essential and recommended as well.
 
A little summary, 1.Keep in mind jde julian date conversion, be carefully with jde julian dates, it is not a standar julian, it is a propietary jd edwards julian date format.
2.Be carefully with the decimal places. In JDE database does not exist the dot as decimal separator, refer to the jd edwards data dictionary for known precision scales.
3.In native jde tables the datatype varchar, varchar2 and so on varchar types .. does not exist, strings are stored in char datatype.
So, keep in mind the significant left blank spaces in some key fields for example MCU, (The bussines unit field)
and it related MCU's. For this field left hand spaces are significant.

Supose you MCU definition code is "SOMEMCU", JDE store this value in the field MCU in this format " SOMEMCU"

The left first five blank spaces are significant for JDE transactions and queries.

Hope it info can help you.

Regards.
 
@BOster
Great idea. I think it will be good in the DB level.

@M. Rodríguez
If we consider all these conditions, it will be little painful to do the direct db access. But surely, if we are going to connect only few tables, we can go this way.
I'm also checking to write the data to an additional table with all fields formatted for the non-jde app. And the data will not be updated by the non-jde app. It will be used for viewing and printing only. Based on the requirement, the non-jde app can update only non-critical fields ( like status of the record, remarks etc ).
 
Back
Top