Archive for 'ERP' Category
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 [...]
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 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 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.
JDE EnterpriseOne SQL Samples for quering various systems … GL, Purchasing, Account Payable, Address Book
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 /// [...]
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 [...]