Skip to main content

Business System Interfacing with O365



We all use business systems, these are the software items we employ, like payroll software, accounting software and industry specific applications that make sure we run our businesses within a framework of rules.

We can't do without them in many cases as the software vendor spends megabucks ensuring that the checks and balances within the software keep us on the legal and moral straight and narrow. This means licencing particular users within the organisation to use and maintain them and this in turn sometimes leads to situations where a few users, or sometimes one user, becomes 'keeper of the key', holding business vital data that only they can access or disseminate.

Most business systems offer reporting functions where selected business essential data can be extracted and distributed to none licenced operatives for use outside the system. Such data is often extracted in some form of textual flat file, such as Comma-Separated-Value, XML, or just plain text. In some cases the business system allows direct queries to be made on a core database.

The data extracted is sometimes used for analysis, but is often ported into other business systems on the same network.

O365 offers a huge range of functionality to import data, convert or transform data and export data. But, additional to this an O365 collection can also be configured as a full workflow system, triggereing tasks for individual operatives or groups, notifying that data is available for analysis and tracking the action taken in a task list for supervisor oversight or later audit.

While there is nothing new about business system interfacing. Extracting data from one business system and importing it into another in a conventional computer network does require a considerable amount of IT knowhow. Even today I often come across business processes where such data is printed out and re-typed in to another system as the interfacing expertise is not available, or is deemed too expensive.

Within O365 there lies the means to import data, filter data, extract partial strings of data, build new strings of data and export the result in a form that is consumable by another business application. Additionally, this does not require extensive IT expertise, or large chunks of administrative effort to achieve.

An on-line demonstration will demonstrate how this can be harnessed to improve your business - email authoring@ffox.biz and please start the subject line with the word Interface. 


Comments

Post a Comment

Popular posts from this blog

Microsoft Teams

Microsoft Teams – Not only but also... What is Teams? Chat, Meetings, Calling, Collaboration | Microsoft Teams That’s the legend that Microsoft uses to head their Google listing. And it does those things really well. But -  There’s more . Teams also delivers a gateway to the fabulous world of SharePoint file storage, SharePoint and Office 365 index and search and Office 365 file security. All without the need for technical knowledge or extensive configuration. All well and good... What exactly does that mean? When you create a new team, simply click the ‘Join or Create a Team’ box at the lower left of the teams window, you launch a new team that has all the necessary attributes. This includes a mailbox, chat, call and video meeting area and a SharePoint file space with a basic library. Move shared documents, of any type, into the library and they are shared with other team members (the share facility is configurable to exclude individuals in the team who do not have sufficient righ...
Post a Comment
Read more

O365: SharePoint List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more