SQL To JDEdwards Date Conversion1 min read

Once Linked JDEdwards database in our MS-SQL database under the Linked server and when we going to see the data it should be encrypted. Here I am show to how to see data like as MS-SQL.

Actual JDEdwards data

My linked server name is “TESTDTA” (JDEdwards database). Open new query window type the below query & press (F5).

Output

JDE1.png

Convert AS SQL Data

Output

 Jde2.png

Meanwhile we can insert the data to JDEdwards and without convention, it’s shouldn’t effect on JDEdwards table. So before insert data convert like a below query.

Output
jde3.png

Leave a Reply

Your email address will not be published. Required fields are marked *