Joget Development With Existing Data

Confluence User - 10 Jun, 2019

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.  

forms;conversion;table

5


10 Jun, 2019
confluenceUser
confluenceUser

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

10 Jun, 2019
confluenceUser
confluenceUser

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

11 Jun, 2019
confluenceUser
confluenceUser

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 ? 

11 Jun, 2019
confluenceUser
1
confluenceUser

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... 

 

12 Jun, 2019
confluenceUser
confluenceUser

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

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print