Archive for 'ERP' Category
Utilizing SQL 2005 Linked Server to connect to external systems via OLE DB
10 March 2007You 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 2006Quest 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 2006Querying 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 2006JDE EnterpriseOne SQL Samples for quering various systems … GL, Purchasing, Account Payable, Address Book
Converting Julian Date to .NET DateTime
18 February 2006Want 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 2005I 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 [...]
