ArrowSQL - A new level of business agility
| Businesses in every industry are
making great demands on their business data. As we
invest more heavily in every aspect of IT and the
information we collect our expectations on the quality,
reliability and flexibility of this information is also
rising. |
We need our platforms and
data management tools to be scalable, to integrate with each
other to create great efficiencies, and to be robust...adapting
quickly in a fast-changing environment. ArrowSQL has been built
using Microsoft SQL to deliver on all of these demands,
providing agile enterprises with the tools to manage their
business processes more effectively.
THE SMARTS BEHIND MICROSOFT SQL
SQL stands for Structured Query Language. Microsoft SQL server was developed by Microsoft and adopted
as the industry standard in 1986. Platforms built on SQL enable
business users to pose complex questions and gain valuable
business knowledge from their business data. Microsoft SQL
server is also completely web-enabled, providing core support
for Extensible Markup Language (XML) and Internet queries.
Industry leading performance, reliability and scalability, combined with powerful management tools, have made Microsoft SQL
server the database of choice for building next generation
business applications such as ArrowSQL. Choosing ArrowSQL means
you are gaining a true business intelligence solution - one that
enables businesses of all sizes to harness the power of their
data to deliver to employees at all levels of the business the
information they need to make better decisions. In a Microsoft
SQL server environment, connectivity is a given. As an industry
standard platform, many applications have been built on
Microsoft SQL server or incorporate direct drivers that make it
easy to extract and manipulate data between them. Popular
products such as Crystal Reports and the Microsoft suite
(including Excel) all integrate with the Microsoft SQL server
platform enabling you to tailor information and deliver it
quickly across the business. Release notes
here.
ARROWSQL: DISCOVER THE BENEFITS
Implementing ArrowSQL and creating an SQL data
environment delivers distinct benefits across the
business.
- RELIABILITY:
As a platform, Microsoft SQL server is highly robust
and stable. ArrowSQL uses true Client Server
technology that maintains data integrity to the
highest level and improves dependability for the
user, all with a reduced load on overall network
traffic. Microsoft SQL server also ensures your
applications are secure in any networked
environment, with role-based security plus file and
network encryption.
- INSTANT ACCESS TO DATA:
Microsoft SQL server is your passport to
true data flexibility and access. Many products and
tools on the market today have an in-built ability
to access ArrowSQL - so that you can share data
across applications, extract and manipulate data
with ease, perform new levels of reporting and gain
true business intelligence.
- SPEED: With
ArrowSQL, the speed of access to the Visual Arrow
database from external reporting and data
manipulation tools is substantially enhanced - ODBC
access is no longer required from most mainstream
products. Crystal Reports, for example, has a direct
driver that talks to the ArrowSQL database providing
fast and information-rich reports to match your
business needs.
- EFFICIENCY:
ArrowSQL eliminates the need to re-index data. The
way that records are written to the SQL server means
that indexes cannot get out of sync with the tables
contained within ArrowSQL, translating to less
downtime in the business.
- EASY ADMINISTRATION AND
MAINTENANCE: Microsoft SQL server
provides a number of smarts to help streamline your
operations and data management. For initial set-up,
graphical tools and wizards simplify the process. In
terms of maintenance, many functions such as
scheduling backups, managing restores and copying
data to other databases can be automated through
Microsoft SQL server.
|
EASY-TO-USE BUSINESS INTELLIGENCE (BI) TOOLS: |
With ArrowSQL, you can utilise Microsoft SQL server's
in-built intelligence tools to support you in gathering
high-level knowledge and new customer insights.
- The Query Analyser
feature allows for easy database manipulation so you can
query tables to obtain data that matches clearly
specified criteria - quickly and easily.
- Microsoft Analysis Server
provides the ability to develop and manage wizard driven
multi-dimensional OLAP structures that can be browsed
from Microsoft Excel and other applications to create,
manage and deliver real-time reports (delivered on
request - pull reports, or based on an event - push
reports)
- Notification Services
enable you to generate messages customised to meet a
user's specific needs or criteria. For example, “Notify
me when my customer, Joe Black, reaches his credit limit
for the month” - ArrowSQL can extract the information
automatically, and deliver it via a wide variety of
devices such as a mobile phone or a Pocket PC. So
everyone in the business can be empowered with
information, with no resources required to generate this
intelligence.
- Database triggers
give you the ability set a procedure that automatically
takes effect when the data in a table is altered in any
way. For example, audit trails can be created for any
master field changes or when you make changes to a
debtor it could update the information in your CRM
database.
If you are currently using
Visual Arrow, there are a number of compelling reasons
why the move to ArrowSQL is a sound business decision...
- A simple upgrade path
is guaranteed: There is a current upgrade path available
from Visual Arrow to ArrowSQL. Included in ArrowSQL are
conversion programs to convert data to SQL format -
quickly and easily so there is no disruption to your
operations and no re-keying of data.
- Also ArrowSQL comes
standard with the Extended General Ledger
module so you gain this added functionality at no extra
cost.
- Plus, your staff won't need
retraining. ArrowSQL looks and operates
exactly the same way as Visual Arrow - the move will be
seamless from a user perspective.
|
|
