1
0
-1

hi, we consider to migrate our legacy system (oracle form/report 6i) to joget workflow. database has been migrated from oracle to MySQL. is it possible to manipulate existing data directly in joget form/data list ? or any other method to call external table ? based on my knowledge, joget will create table field directly as we're designing forms. handling relationship with existing table quite challenging. starting from scratch is not an option.

Suggestions or tips are welcome.  

    CommentAdd your comment...

    5 answers

    1.  
      3
      2
      1

      Hi - are you looking to import the data into the default database or using your current db? if you are looking to import into joget, I would recommend you let the app create the table... afterwards, you run a data load from your current database... keep in mind the primary key and other dates the application populates when the form save runs.

      if you are keeping your current database, the jdbc would make regular query calls or run a store procedure... 

       

        CommentAdd your comment...
      1.  
        2
        1
        0

        for earlier versions than V6, you need to download the plugins. 

          CommentAdd your comment...
        1.  
          2
          1
          0

          Hi - take a look at the jobc binder for the from binding. You can create forms and list that are bound to the external database.

          Tony

            CommentAdd your comment...
          1.  
            1
            0
            -1

            tq for help Tony. Is there any differences by using Import Tools and manual data load ? 

              CommentAdd your comment...
            1.  
              1
              0
              -1

              From docs, In a Joget database, your actual table name is prefix with "app_fd_" and column name prefix with "c_".


              can i design table first using prefix as documented and populating data using joget form without jdbc bind plugin ? 

                CommentAdd your comment...