• Version
• Download 6
• File Size 0.00 KB
• File Count 1
• Create Date 11 July 2023
• Last Updated 16 July 2024

Adyen DEXDNB

DEXAdenProd.zip d.d. 16/7/2024

New version with FSCS included.

Installation

Create a backup of schema DEXAnalysis using DEXRS/DEXSetup/software/dist/ExportSQLScript.exe

Rename existing directory DEXAdyenProd

Download and unzip zipfile DEXAdyenProd.zip

Start DEXRS/DEXSetup/software/dist/setConnections.exe

Enter the database credentials and press [Test database connection]

Start DEXRS/DEXSetup/software/dist/ImportSQLScript.exe

Import the scripts in DEXRS/DEXSetup/sqlbackups in this order

1. CreateDEXAnalysis_ps.sql - creates a new version of the mapping tables
2. CreateDEXRS_ps.sql - creates a new schema for loaded souce data
3. CreateDNBRegulatorDB_ps.sql - creates a new version of the taxonomy tables
4. CreateFSCSFact_ps.sql - creates a new schema for storing FSCS tables
5. populateDEXAnalysis_All_tables_Postgres_2024-07-15.sql - populates the mapping tables
6. populateDNBRegulatorDB_All_tables_Postgres_2024-07-15.sql - populates the taxonomy tables
7. upgrade_Adyen_DEXSetup_Postgres_2024-07-04.sql - creates new functions in the DEXSetup tables

The installation is now completed