|
Database Connectivity
Generic Database Connectivity.
Sayula's instant connectivity solutions are not confined to analytics or real-time data. Sayula's Anima distributed platform readily supports the direct (as opposed to ODBC) access to multiple commercial database implementations. And in line with the rest of Sayula's generic data and analytics connectivity, the DB's query output data and operation status information can be transparently accessed in Excel and the Web.
SQL queries and commands are defined and centrally stored via the Anima system administrator's GUI. Once defined, the queries and commands become available to authorized Excel or web users. When used in Excel the results of the queries and commands are deployed via the generic add-in, thus becoming part of a standard Excel spreadsheet that can be saved and reused as normal. Alternatively, the spreadsheet document can be uploaded for its immediate access on the Web.
Command Trees
Anima also supports the definition of SQL statements containing database-modification instructions (creates, inserts, deletes, etc.). In Anima terminology these are referred as command trees. Just like standard queries, command trees are centrally defined and maintained via the system administrator's GUI. Anima command trees can be used to directly implement the uploading of data via a single Excel macro button click.
Existing Format Template Compatibility
In a great number of cases, existing Excel report templates are normally populated from intermediate Excel data-only files which are in turn populated from the output of a number of pre-defined SQL queries. Via Anima, identical data files can be fully populated with the click of an Anima-deployed Excel macro button. The data files can then be saved, reused, and repopulated as any standard Excel file. Thus, full compatibility can be maintained. Since the intermediate Excel file's data are generated by the same existing queries, there is no need to modify the existing report templates.
Ad-hoc Reports
In contrast with the previous 2-step (data file to template file) population mechanism of standard Excel template reports, ad-hoc reports can be instantly generated from the output of new queries. Ad-hoc reports have enough formatting capabilities to make them highly usable for the fast dissemination of data across the enterprise. Figure 2 illustrates the output of an ad-hoc report on Anima's Flash web browser client.
|
April 22, 2011 | Zurich Swiss Private Bank purchases iMonIT and will implement internal market data feed with the Anima Enterprise SDK.. refer to 
February 15, 2011 | Zurich Sayula's iMonIT detects with in 20 seconds data quality issues of London Stock Exchange's Millennium platform implementation. read on...
May 6, 2010 | Zurich Sayula's iMonIT catches the Fat Finger Flash. refer to
January 21, 2010 | Zurich Sayula's Anima supports IDC's CSP PlusFeed. refer to
August 15, 2009 | Zurich Sayula's Anima supports Morningstar's real-time low latency broadcast feed. refer to
March 1, 2009 | Zurich Leading Swiss Private Bank decides for iMonIT for risk compliance reasons.. refer to
September 30, 2008 | Zurich Sayula Group adds new branch in Switzerland: Sayula Engineering AG. details...
July 10, 2007 | Zurich Global tier-1 Swiss bank purchases Sysula's iMonIT, a vendor latency monitor, to support its client web market data services. refer to
November 20, 2006 | London Wilmott and Sayula announce partnership and joint project to develop real-time collaborative spreadsheet analytical models for the Web. read on...
July 24, 2006 | Brussels Sayula and ITG Consulting announce partnership agreement. read on... |
