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

Popular posts from this blog

Electronic Document Storage and Management (EDMS)

EDMS is not just a means of storing computer files. A full EDMS system allows for the process of importing both paper and computer generated documents into a computer system and indexing the files for easy and swift retrieval. In effect you can dispose of your traditional paper filing system. No more gathering letters, invoices and orders into filing groups and no more slotting them into the correct folders. Of course, you only use a paper filing system because you know you may need that document again in the future. Equally, when you do want that document it's invariably missing, either misfiled, or on someone else's desk. With EDMS documents are where you placed them and they are available for you to use where ever you are. All you need is a computer, tablet or smart phone and an Internet connection.As most modern businesses already use the Internet for everyday interaction with banks, Inland Revenue, Companies House, insurance companies, suppliers and customers it no longer ...

Leadership: So you want to be Powerful?

Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions.     In a recent post on LinkedIn a n Influencer wrote that she had been asked the question ' Who is the most powerful person you ever met? '     The question was posed by a 17 year old and the author guessed that the answer being sought was the name of some sort of X-Factor figure, This strikes a cord with me. Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions. This applies to all generations, 'Boomer, X-Gen and Millennial, it applies to individuals of all levels of intelligence, and to individuals at all levels of authority.     The desire for someo ne to appear, like a genie from a lamp, wit h either ' the answer' to a problem , or ' the power' to solve the problem, or...

Law and Order: The Anonymous Text Tip-Off

The following article came out of an interview conducted with Max Doleh - Law enforcement organisations and Crime Stopper programs are turning to technology which enables text tip-off from the public to facilitate a police response. In September 2007 Master Sergeant Charles Phillips of the Oklahoma City Police Department published an item on the Oklahoma City Crime Stoppers web site (http://www.okccrimetips.com/ ) calling for increased resources to bring this technology to OKC. In November 2007 it was announced that Crime Stoppers of Oklahoma City have engaged technology company ProductiveT to develop an SMS system that is radically different to others in use in the country. Max Doleh, ProductiveT president and CEO answers questions – 1 . What makes the Oklahoma City system so different? The ProductiveT technology differs greatly from other offerings. The police department have their own dedicated number for receiving the messages and unlike most systems there is no need for the sender...