Migrating database files to JSON files

Use Database Export Utility to export your existing data sources and Client Item variables from your database to JSON files.

1. Navigate to the Database Export Utility installation directory. For example:
   Linux Unix

   opt/IBM/ACMfg-13.0.n.0/runtime/amd64_linux_2\setup\ACMfg_Database_Export

   Windows

   C:\Program Files\IBM\ACMfg\13.0.n.0\runtime\amd64_nt_4\setup\ACMfg_Database_Export

   The ACMfg_Database_Export folder contains the following files:

   • lib

     The lib folder contains the Jackson JAR files.

   • DatabaseExportUtility.jar
   • DB-config.properties
   • DB-export-linux.sh
   • DB-export-windows.bat
   • readme.txt
2. Add the following mandatory database parameters and their values into the DB-config.properties file.

   Properties	Description
   URL	The URL of the database connection.
   USERNAME	The username to connect to the specified database.
   PASSWORD	The password for the specified username.
   DRIVER_NAME	The driver name of the specified database.
   DRIVER_JAR_PATH	The driver JAR path in string format. For example: "<location_of_the_jar_file>\<jar-name-version>.jar"

3. Run the following file to load the Database Export Utility window. For example:
   Linux Unix

   1. Run the following command:

      /DB-export-linux.sh

   2. Enter 'y' to continue the migration process. Upon completion, the JSON files are migrated to the specified JSON directory path.

   Windows

   • Double click on DB-export-windows.bat file.