If you have new entities available from your source DB, but they do not show up in your modeler. It is because you are using an old version of EFP/pcFinancials.
Here is the step how to add new entites into your SQL:
- You do not need to do anything from Modeler.
- Go to the ETL database from SQL server -> Tables -> dbo.Entity, right click on it -> you need to manually add those new entities(companies) here.
Please run the night job: SQL Server Agent -> Jobs -> right click on pcDATA_E9_Load -> Start Job at Step. This will take some time.