Re: Mapping to/from Access and/or Excel

[Mark T. Kennedy]

Anthony, EDITALK consists of four applications: 1) Maintenance application, which is the user interface to maintain any business rules used by EDITALK; 2) Message processing application, which is a server application that performs the message processing based on the business rules registered by the user/administrator; 3) EDITALK Console, which is an interface for manual start of message processing, and finally the EDITALK Report module, which includes standard EDI reports as well as a tailor made reports. Running this you will be prompted for input parameters, and notified of the result. The Message processing application can also be called from other applications, using a defined parameter set.  The maintenance application and the Online console would normally be installed on a network client or a file server so the EDI-administrator could run it, while the message processing application would normally run on a server as a non-visual program. In addition EDITALK uses a meta-database to store all business rules. This database has to be installed on a server accessible to both the maintenance application and message processing application. EDITALK is a true client/server application. EDITALK is two year old technology and really is data flow software having X12 and EDIFACT translator capabilities that the user can define his own business rules/logic within the software. Regards, Mark Kennedy   Anthony Beecher wrote: What is EDITALK?I know that Gentran NT and St. Paul do not support ODBC, PaperFree does ODBC, EDITalk does ODBC,Mercator supports ODBC and MS SQL Server /Oracle/DB2 native connections.When I met with St. Paul, they said it was better to use a flat file and a bulk load rather than ODBC. Can anyone speak to this statement? Anthony Beecher -----Original Message----- From: Mark T. Kennedy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 01, 2000 2:06 PM To: Subject: Re: Mapping to/from Access and/or Excel   Dan is correct here. Products having ODBC and/or native drivers to access database applications directly allows seamless message implementations. Eliminating all flat file integration. EDITALK has this functionality also a simplified "drag and drop" mapping tool. Mark Kennedy Dan Kazzaz wrote: I saw the original posting and did not have time to answer it.  It certainly is possible to map to Access or Excel.However, it is product dependent.If the mapping tool you are using has ODBC capability you can do it.Without ODBC capability, it is difficult. Some mapping tools have ODBC capability by generating source code, others achieve it in more efficient methods. If your software vendor cannot support this capability, then you will need to write additional programs to parse the EDI message and post it into your database.There are several products on the market (including PaperFree's) that do not require this additional programming effort. Dan Kazzaz PaperFree Systems, Inc. -----Original Message----- From: Jasper Abeyta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 01, 2000 3:14 PM To: [EMAIL PROTECTED] Subject: Mapping to/from Access and/or Excel Greetings, Several weeks someone asked the group if were possible to map to/from either Access or Excel.  I suspect that most responses were sent directly to the individual since very few were posted for the groups benefit.  I know how to do this with SPS, but is it possible to do this with Sterling's Gentran: Integrator?  I called Tech Support and was told that I could not.  In SPS when defining the flat file you can define it as a variable length.  How would I do this with Gentran?  Any and all suggestions would be appreciated. Thanks Jasper

begin:vcard
n:Kennedy;Mark
tel;fax:208-361-5350
tel;work:919-657-1427
x-mozilla-html:FALSE
version:2.1
email;internet:[EMAIL PROTECTED]
adr;quoted-printable:;;201 Shannon Oaks Circle=0D=0A;Cary;N.C.;27511;USA
fn:Mark T. Kennedy
end:vcard