private

Individual data hub for secret data

How do you back up secret data to individual clients in grown environments?

Example image private / secure

Data that is particularly valuable should also be protected. In order to support our customers in this, anic designed an SQL proxy with a persistent session context for the databases behind it with row and column security. How do you keep flexibility while increasing security requirements? The solution: a .net-based REST web service was implemented, which is addressed via Windows authentication (e.g. Kerberos) and which only accesses the database. The user session is backed up to the database and made available to it. There, data is made available to users individually at the row and column level. This means that unauthorized access to both the database on the intranet and to secure database rows is not possible.

The XML data supplied by the WebService is processed by an Excel VBA script and converted into a suitable Excel recordset with which the user can work as usual. Well-established work processes can still be used by the customer while security has been improved.

Anic advises and supports you! We create ideas and solutions which work

And what can we do for you?

Just give us a call!.

Related articles

Flexible EBR in the regulated pharmaceutical environment

Flexible EBR in the regulated pharmaceutical environment – GxP-compliant and future-proof

The pharmaceutical industry is facing major challenges: Strict regulations (validation, ER/ES, audit trail, data integrity, data consistency, etc.) must be met, while at the same time customers expect innovation, fast delivery times and a broad product range – all while maintaining consistently high, defined quality – What if the first step to solving your challenges could be found in this article…?…

Check out all the benefits if using anicomply

To the article »

Let’s Work together!

Let us help you envision the future of your company.

logo

Leave us a message and we will get back to you as soon as possible.