Strategies to Create Elliott Database for Read Only Access

Strategies to Create Elliott Database for Read Only Access

Release Date: 02/20/2026
Version: 8.x & up

A user raised the question about setting up an Elliott database for read-only access so their reporting team can access it. The current database, ELI85DATA, does not have security enabled. They are concerned that granting access to this database to the reporting team may be risky due to the lack of security controls.

We offered the following strategies:

1. Create Security for the ELI85DATA Database

It is possible to enable security for the existing ELI85DATA database, even though it currently does not have security control. The following knowledge base articles discuss how to do this: 
While this is definitely doable, the concern is that they have existing third-party tools accessing ELI85DATA. If we turn on security for ELI85DATA, it could cause those third-party tools to break and require adjustments to their connection security settings.

2. Create a Backup Copy of E3P85DATA99 Database

It is possible to create a DATA_99 folder by copying the DATA folder. DATA_99 can then be used as a backup company for reporting users to access. Since it is a backup company, it does not matter if reporting users accidentally update this database. There is no need to enable security for E3P85DATA99.

The naming convention “E3P” stands for Elliott Third Party.

Typically, we schedule the backup from the DATA folder to the DATA_99 folder at night when users are not in the system. The drawback of this approach is that the database is not real-time. 

3. Replicate the Elliott Database

It is possible to replicate the Elliott database to MS SQL using SSIS or other third-party tools. This allows users to access Elliott data through MS SQL.

MS SQL is generally more powerful than Elliott’s PSQL (Zen) database for relational operations. However, the drawback of this approach is that the replicated database is not real-time.

Zoom Meeting Recording

The following is a Zoom meeting recording discussing the second and third strategies:

EMK

    • Related Articles

    • PSQL Download and Installation with Video

      Release Date: 09/12/2023 Version: 7.x & Up Elliott Business Software depends on the PSQL database engine. Our latest version, Elliott 8.6, requires either PSQL 13 or 15. In this article, we are going to show you how to download and install the PSQL ...

    • How to Use EL850DB.EXE Utility to Create PSQL Databases

      Release Date: 12/4/2018 Modified Date: 06/20/2020 Version: Elliott 8.5 Elliott 8.5 includes an EL850DB.EXE utility to make it easy to create PSQL databases. The new utility EL850DB.EXE is included in the Elliott 8.5 release, and you can find it in ...

    • Steps Required to Test ReportWriter in V8.2

      The following steps are required to be able to test Elliott ReportWriter, which is being developed for Elliott v8.3, in Elliott v8.2 Copy the RW directory and all its files and subdirectories from M:\Elliott7 to the target root directory (e.g., ...

    • Receive Schema Mismatch Error When Trying to Create a New Database in Actian Control Center

      Released Date: 02/07/2025 Version: PSQL 15 & Up Q - I tried adding a data source on our new server with PSQL 15. I copied the DDF path and data as it appeared in the old server. But it gives us a “schema mismatch” error and doesn’t work. We don’t ...

    • Feature: Support Larger Page Size for Elliott Database Files

      Release Date: 6/24/2025 Versions: 8.6 and Higher Background This article provides an explanation of how Elliott BTR files' page size may affect the following two factors: The maximum database file size Performance to load a table from disk to memory ...