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
- CreateDEXAnalysis_ps.sql – creates a new version of the mapping tables
- CreateDEXRS_ps.sql – creates a new schema for loaded souce data
- CreateDNBRegulatorDB_ps.sql – creates a new version of the taxonomy tables
- CreateFSCSFact_ps.sql – creates a new schema for storing FSCS tables
- populateDEXAnalysis_All_tables_Postgres_2024-07-15.sql – populates the mapping tables
- populateDNBRegulatorDB_All_tables_Postgres_2024-07-15.sql – populates the taxonomy tables
- upgrade_Adyen_DEXSetup_Postgres_2024-07-04.sql – creates new functions in the DEXSetup tables
The installation is now completed