Enterprise Software Development

Archive for 'ERP' Category

Utilizing SQL 2005 Linked Server to connect to external systems via OLE DB

10 March 2007

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 SOURCE=MYSERVER;
    USER ID=MYUSERID;
    PASSWORD=MYPASSWORD;
    Connect Timeout=30;'
You’ll notice the Force Translate is set [...]

Quest Collaborate 2006

26 April 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, oddly enough, GL Inquiry… this [...]

Querying Data From JDE World or Co-Existance OneWorld XE

5 April 2006

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

23 March 2006

JDE EnterpriseOne SQL Samples for quering various systems … GL, Purchasing, Account Payable, Address Book

Converting Julian Date to .NET DateTime

18 February 2006

Want to convert a Julian Date to a .NET DateTime? Heres an easy (C#) way to do that
///<summary>
/// 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
/// convert 8 digit julians (more [...]

Quest 2005

19 June 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 [...]