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:

  1. You do not need to do anything from Modeler. 
  2. 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.

  3. Please run the night job: SQL Server Agent -> Jobs -> right click on pcDATA_E9_Load -> Start Job at Step. This will take some time.