11 replies
That question is like asking how does one breath? It appears very simple on the surface but it is actually a very complex process.
What is it that you want to integrate? A new interface? Different data access methods? A new analysis tool?
Are you going to make a "plug-in" or an "instead of" tool?
Each of the ERP products you mention has their own method of adding third party software into the interface. Data access of course depends more on which database software is in use. (Some ERP sysems can run on top of a variety of DB products, i.e. MS SQL Server, Oracle, DB2, etc. Others include their own DB software.)
If you want to produce a specific product you'll need to decide WHERE it plugs in...at the database or the interface.Then you'll need to decide which ERPs or DBs you'll support. Forget trying to hit them all--can't be done. They're too different. (They do that to make sure their clients can't easily jump ship to another vender.)
Good Luck,
Al Franco, II
APF Creations
Pamplona, Spain
by thams99
by ramkis
First establish a roadmap that needs to be
followed to ensure complete success.
(1)Application Communication
(2)Application Servers and Web Servers
(3)Enterprise Application Integration (EAI)
(4)Process Management and Workflow
(5)B2B Integration
(6)e-Business Services (application
functionality)
(7)Systems Management and Operations.
(8)Product Migration activities
(9)Post Integration Issues.
(10)Globalization / Localization Issues.
As far as the messaging area is concerned we
would have to use 'Asynchronous Messaging'.
Once the Messaging technology is decided on
then we can look at other issues like Cost,Security etc.
(Contd in next message).
by thams99
by ramkis
Functionality of Apps Servers and Web Servers
---------------------------------------------
(1)e-business functionality enabled unlike
legacy systems.
(2)Connectivity to the web using the
following : (a)IE-any version (b)Netscape
(c)any other browser from the client side OR
acting as a front-end.
The best of the browsers which i felt is
IE.5.x.
Qs. What are the Run-time services that
these servers provide?.
Ans. (i) Load Balancing
(ii) Failover functionality
(iii)Transaction Management
(iv) Object Management (ORB)
(v) Session Management
(vi) Connection Pooling
(vii)Component integration facility
Ex:Comp written in Com/dcom,ejb,
CORBA-Common Request Broker Architechture etc.
NOTE: Some vendors provide special connectors
which could talk directly to the above mentioned disparate systems.
For all OR most of the above there would be
a common API having a set of rules that
govern the levels ofinteraction.
The actual data that needs to be passed would
be based on the messaging technology.
Contd in next posting.
by thams99
by ramkis
(Contd) from previous message.
Currently the best of open standards is
using XML for passing data (Legacy Data, Transaction Data Or security data).
Earlier generation used EDI and EDIFACT where EDIFACT - Electronic Data Interchange
for Accounting, Communication and Transport.
The interaction would be actually based on
the acknowledgement of message data, security data and transaction data.
NOTE: This must be clearly defined for all
independent business entities.
Ex of entities : Invoices, SO, PO, IDOCS (in
case of ERP), JE's etc. Basically all relevant data that needs to be transported
across to other systems for Updates.
In case of SAP we have a programming Interface called BAPIs OR Business Application programming Interfaces and RFCs
to connect to external systems.
Connectivity to SAP could be using C++ callable objects which can invoked by an interface using Java.
Thus the preliminary templates (XML Templates & DTDs) for most of the above
entities needs to be identified, defined and
the necessary workflow for transporting
data should be very clear, with a provision
to add fields, data types at intervals based
on company/client requirements, since there
could be many fields which would be company/client specific.
NOTE: I have included some technicalities in this so, i hope some people wont mind it.
by thams99
by ramkis
Lastly from a technical angle the following
formats for streamlined outputs can be easily mapped to the ERP or Backend or legacy
systems based on the data structures that can
be received by the target systems.
If the structures are available, mapping and
xml parsing can be done along with good DTD's
and then the necessary action taken.
Another scenario could be based on how many
companies/clients can afford to have ready made connectors which are available off the shelf and priced very high.
Following are some of the products.
1. Acclaim
2. Candle corp
3. Finesse
4. obaon
5. Tibco
6. Webmethods
There are quiet a number of companies who fall in the SME segments OR Small Industry Groups who have disparate systems running on
MS Access, Foxpro,Dbase or Xbase and Mainframes, who may not be able to afford the
above solutions, for whom an inhouse developed solution based on the process that
i have suggested could be adopted.
I would like to know everyones views and sincere opinions in this.
by thams99
by thams99
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending