Archive for 'ERP' Category
How To Convert from a .NET Int32 to EBCDIC Signed Integer
Many of us have had to write data exports from our PC based management systems that are in some strange formats. Signed Integers (which smells of COBOL and EBCDIC on a main frame) are no exception. Now I know all you Computer and Mini Computer (mid range) guys out there are like ‘strange format’? YOUR [...]
Utilizing SQL 2005 Linked Server to connect to external systems via OLE DB
You can utilize MS SQL Server 2005′s Linked Servers ability to connect to any OLE DB provider. Here we are connecting to an iSeries (AS/400) DB2 using the IBMDA400 ole db provider Here is the command to add a linked server: EXEC master.dbo.sp_addlinkedserver @server = N’MYSERVER’, @srvproduct=N’IBMDA400′, @provider=N’IBMDA400′, @datasrc=N’MYSERVER’, @provstr=N’Transport Product=Client Access; Force Translate=0; DATA [...]
Quest Collaborate 2006
Quest collaborate 2006 just finished up here in Nashville Tennessee. Some of the highlights: Support for EnterpriseOne XE until 2013 The new tool sets for EnterpriseOne include a web services interface EnterpriseOne 8.12 is now available The first version of Fusion will ship in 2008 side note: The GL Company has a cool tool called, [...]
Querying Data From JDE World or Co-Existance OneWorld XE
Querying or extracting data from JD Edwards World is easier than you think. You can use SQL queries to get that data out and into excel or maybe you want to extract some data to integrate with another system, perhaps with DTS… This is all pretty easy to do, when you have the right tools.
EnterpriseOne SQL Samples
JDE EnterpriseOne SQL Samples for quering various systems … GL, Purchasing, Account Payable, Address Book
Converting Julian Date to .NET DateTime
Want to convert a Julian Date to a .NET DateTime? Heres an easy (C#) way to do that /// /// Will Convert a 7 digit Julian Date to a .NET DateTime. /// 7 digit Julian dates are common in some legacy applications /// such as JDE World, OneWorld, EnterpriseOne. You can easily make this /// [...]
Quest 2005
I just attended Quest 2005 at the Gaylord Texan resort in Grapevine Texas. This is a user conference for JDE OneWorld and World users (now known as EnterpriseOne). There is nothing really new here since PeopleSoft Connect 2004, except that EnterpriseOne 8.11 was released. Oracle extended the support for OneWorld XE until 2007. And Oracle [...]