Segovia offers a desktop edition of the software to act as an ad-hoc reporting tool that connect directly to a single Admod database. The standard edition supports the following features:
|Multiple Data Sources|
|Multi-Sheet Data Sources|
|Q-Mark Email Security|
|Field Level Security|
The Segovia Web Portal is an easy to use application that can be accessed anywhere at anytime. The system minimizes the dependency on sophisticated proprietary interfaces and maintains clean and sleek forms to templates to search and sort reports. The user only needs to have a web browser and a copy of Microsoft Excel or Open Office Calc to use the system.
The Desktop Edition also offers an additional markup tags to enable cross-tabbing within the report template. This allows template designers to pre-define the logic for cross-tabbing. Since the system is utilizing a markup language, this allows a greater amount of flexibility to derive a variety of different cross-tab options than the pre-defined functions embedded within Excel for standard pivots. This expands on the possible layouts, pivoted values, and complex calculations that can potentially enable users to integrate a multi-purpose view (i.e. product cost, allocation, and profit margin) within a single cross-tabbed report.
Admod is an editable database that was created within Microsoft Excel. The user can utilize Admod like any other database within Segovia. Our software is able to connect to the Admod database and extract values from it for report generation. However, Admod is a unique database because the user can make changes to the data set freely. Each worksheet within an Excel workbook represents a separate data table. The Desktop Edition allows for only one Admod database to be connected to Segovia. The user is limited to run one query within the Admod database.
Multiple Data Sources
The user can connect to multiple data sources within Segovia to create queries and generate reports. Segovia can connect to various ERP or legacy systems so that all the data can be obtained through one application.
Segovia is able to connect to non-relational databases such as MongoDB, Hadoop, and CouchDB to extract data out of the systems for reporting purposes.
The Desktop Edition also creates and maintains barcodes as a data type. Segovia will convert a value into a Code 128 barcode for shipping and packaging of products. The barcode is displayed on the final output report.
Segovia is also able to extract images as a data type from a data table. The image is pulled from the Binary Image Location and displayed in the output report.