Adyen DEXDNB

[featured_image]
Download is available until [expire_date]
  • Version
  • Download 7
  • 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