I am using Helical Insight EE 4.0 RC2. I have already migrated the application database from derby to Postgress. Is it possible for you to share the SQLDump in Postgress format so that I can use and my sample reports can also work fine?
A. First you will have to load the data in postgress and make the connection from postgress. In case if you load it into some other schema other than public schema it will not be visible on the frontend. in that case you might find this link very relevant
B. Create the database connection from the datasources page to postgress
C. Open the metadata in edit mode and change the connection. Derby does not have concept of catalog, but Postgress does have it. So accordingly you will have to make the changes there. After making the changes save the metadata