SQL (Structured Query Language) is a database computer language designed for managing data and is the most widely used for relational databases. The entrée.SE module allows you to easily and quickly export your NECS data tables into the SQL format. This is ideal for applications such as custom report generation or any other custom requirement where you need to gain access to your NECS data in this standard format.
entrée.SE features:
Exports all NECS entrée
data into SQL Server 2005/2008 and Express versions
Configuration wizard makes configuring the SQL Server
database easy and fast
Bulk inserts provide blazing fast imports
Ability to export All Files, Current Files, History
Files or a custom selection of data tables
Command line switches allow
for the export to be linked into Windows Scheduler.
This can trigger “middle
of the night” exports
or multiple exports throughout the day
Users do not have to be
out of NECS entrée
when exporting
For NECS customers with more than one operation,
multi-company data is exported into a single SQL database
using schemas, providing the ability to easily query
data across two or more NECS company databases
Requires SQL Server 2005/2008
or Express versions of SQL to be installed on a server
other than the main NECS entrée data server