Data integration between moss and other systems

1 Integration Based on Web Interface
This method is relatively simple. You can directly take the web interface of other systems and place it on the portal page built by Moss, so that users can access other systems on the SharePoint interface.
LimitationsThe page of the Web application to be integrated must be accessed anonymously. If it is not accessed anonymously, single-point logon is also required.
AdvantagesIntegration is relatively simple and interactive operations can be performed.
2. Data source-based integration
If you need to be able to see the data in the system in the portal built by Moss, it may be another form and style. The simple method is to use the data source integration method.
LimitationsIt is not interactive, and requires access to the database of the other system to understand the database structure (data dictionary ).
AdvantagesYou do not need to know how the application system is, how it is done, and what interfaces are. You only need to be able to access its database.
The implementation method is to use some Web parts to directly display the data of one or more tables, or use BDC to display the data to the portal built by moss.
3 point-to-point Integration
If you need to be able to see the data in the system in the portal built by Moss, it may be another form and style, but the database of the other system is not public or has no corresponding data dictionary, point-to-Point integration is required.
Point-to-Point integration refers to a custom web part that accesses a specific interface of the system to be integrated to complete a task in the Web part. This method may be a point-to-point method because it may need to develop a corresponding Web part for every application system or even every function in the application system.
LimitationsThe application system to be integrated must have corresponding interfaces and a detailed description of the corresponding interfaces is required.
AdvantagesIs the most flexible and functional, because as long as other application systems have corresponding interfaces, we can complete any function in the Web part: obtain data from other application systems and interact with other application systems.
3.1 Interface Method
-Web Service
-Class Library and API reference
-Data View