BC Excel Server 2008 Enterprise-Complete 8.3

BC Excel Server 2008 Enterprise-Complete 8.3 is a platform and EAI (Enterprise Application Integration) based on the spreadsheet Excel that enables people to manage their data by building their own MIS (Management Information System) such as ERP, OA, CRM. Hence, there is no strict definition about Excel Server. It seems to be like a develop tool but it is also able to deal with the spreadsheet and visually manage the system develop by itself.

Excel Server delivers a rich set of integrated combo that enable the users to do more with their data such as query, search, synchronize, report, and analyze in the MIS they had made.  To conclusion, BC Excel Server might be consider as a frame of the house that has integrated the laying brick where its inner system will support and maintain the house running as well.

With all of the service BC Excel Server provide, it is easy to load a proposal to the people by BC that everyone is able to be an software engineer

 How does BC Excel Server work? The BC Excel Server aims to establish a “DIY(Do It Yourself)” relation with the terminal user. With his strong feature of information management, it is also called “ make by you and use by you”. Hence, there is a cycle relationship during your development and use.

Normally, A software development process is a structure imposed on the development of a software product. There is a concept that BC Excel Server is a development platform as well as an information management system. To explain the work process, the pure Waterfall processes model has been employed. In the pure Waterfall processes of software development, there are five basic processes: requirements, design, implementation, evaluation, maintenance. The Excel Server is actually the platform that play the role of implementation, evaluation, maintenance. However, there is no any code need to build in the implementation process. Meanwhile, the system, which is built via Excel Server will run on itself as well. The Excel Server has provide a managing server interface to supervise the system for the administrator. Therefore, it is a integrated systematic structure for user to get their own MIS once they successfully made.

With the independent structure of using both inner system and outer system, Excel Server could might meet the requirement of creditable system reliability, availability, and serviceability. The three items are enhanced by features that include auto-development model and repeatable experiment model.

System reliability. There is a normal concept of a reliable system provides the foundation for both external reporting and internal operations. The increased reliance on third-party service providers has made the definition and assessment of a reliable system increasingly important to users. A system cannot be deemed reliable if it is not secure, so the concepts of security and reliability are intrinsically linked. To compare with the other develop system or environment, the reliability is in the double working standard.

System Availability. Refers to the ability of the user community to access the system, whether to submit new work, update or alter existing work, or collect the results of previous work. If a user cannot access the system, it is said to be unavailable. Usually, system Availability is calculated by modeling the system as an interconnection of parts in series and parallel.

Who is suitable for using Excel Server? The BC Excel Server aims to establish a “DIY(Do It Yourself)” relation with the terminal user. Thereby The BC Excel Server is for those people who want to be seized of their own MIS which is able to build by themselves. It is also suitable for those who want to make the prompt development and get the independent application.

Major Functions:

1. Automatically create  B/S system (Web format). People can logon the system by IE 
2. SMS information centre ( fill, query, modify the report by mobile message ) 
3. Email information centre ( email remind)
4. Automatically create reports by setting date and time
5. Offline filling report
6. Notes management and report notes 
7. Supporting Excel（Excel2000/XP/2003/2007）as a client
8. Work flow
9. Providing external data import interface
10. Cross table
11. Supporting LDAP logon
12. Massive initializing data
13. Backup and restore database interface 
14. Faster query (not via Excel )
15. Input Criteria
16. Reduplicate print
17. Data fetch 
18. Connect to VBA

Major Features:

1. Templates Template is the key feature for the user to develop system in BC Excel Server. Per template can be a logic module or a simple form that connect with the other logic.
2. Work flow  A workflow is a depiction of a sequence of operations, declared as work of a person, work of a simple or complex mechanism, work of a group of persons. Workflow may be seen as any abstraction of real work, segregated in work share, work split or whatever types of ordering. Excel Server enable users to define their own work flow that is suitable for their system logic. It is a bright point in Excel Server
3. External data import to put the external data to the figure out Excel Server provide the interface to import the external data, the compatible database would be SQL Server, Oracle, Sybase, Access. It is convenient for user to connect their existent works to Excel Server.
4. LDAP logon LDAP ( Lightweight Directory Access Protocol ) is an an application protocol for querying and modifying directory services running over TCP/IP.  Excel Server is also provided a common interface to connect with the LDAP service.
5. Data fetch Data fetcher refers to a set of sequential query rules, it can qualified data or records from variously joined data tables. It world returen the results to the corresponded table cells according to default or customized filling criteria. It is able to make Excel Server templateds to use any report data or records freely within the information system.
6. B/S and C/S model In enterprise edition of Excel Server, there are B/s both C/S model for user to build their remote management system. An Internet Explore would be the similar function that roll in a ducth fram of the client
7. Input Criteria In the Intermediate Business Modeling or Advanced Business Modeling user profile,user can group inputs to form a set of inputs known as an input criterion. Each input criterion defines a particular combination of inputs that can start a process, task, or other element. There are five types of input criteria which has been defined in Excel server, however, the Excel Server is due to give the hand to the users to define it therisleves.
8. Backup and restore database The backing up and restoring databases and transaction logs is a way that Excel Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if the media failure occurs or if the database is somehow damaged.
9. SMS information centre To support the “message to operate report”, Excel Server provide the function so called “SMS information centre” for user to make the contact when of their absence etc.
10. Email information centre Excel Server is not just the inner system to any orgnisation. Indeed, it would be load down the reaching the contact among the users who is far away from the target virtual machine. Hence, without any question, Excel Server enable to establish the email manage system to users
11. Task plan Excel server is a flexible monser that simple enable user to achieve the concept of their puncher. To simplize the the auto-work, the key point in Excel Server is to define the task by user own, where would be leisure.
12.  Offline Report  offline is successfully meeting the physics needs of the organization. It is also be in the comp of saving space and time effect. The normal reaction in Excel Server would be download the template and upload it.
13. In BC's Excel Server, there is a slight kit difference between enterprise edition and standard edition. User is set to pick up the function that is load to their inner management. For the system, which is base on the LAN or WAN would be the key excuse to empoly the edition of Excel Server. The table for match each part of the contents is below

Enhancements:

1. Support query via mobile phone;
2. Access control enhancements;
3. new data types

Requirements:

1.  IIS,
2. .NET Framework,
3. Excel,
4. SQL Server

WareSeeker Editor