Forum Discussion

benice25's avatar
benice25
Occasional Contributor
4 years ago

Zephyr Scale + PowerBI

Hi SmartBear Community,   I'm looking for the supporting database documentation for Zephyr Scale so I can start pulling some tables into our datahub for PowerBI reporting, does anyone know if that ...
  • luziamendes's avatar
    luziamendes
    4 years ago

    Hi,

    Scale does not have public DB ER models. One tip we can give is that you can locate all Zephyr Scale tables in the database by looking at tables prefixed by AO_4D28DD_ . All of our tables will have the same prefix.

benice25's avatar
benice25
Occasional Contributor
4 years ago

Bump, just looking for any information anyone might have. 🙂

  • luziamendes's avatar
    luziamendes
    Staff
    4 years ago

    Hi,

    Scale does not have public DB ER models. One tip we can give is that you can locate all Zephyr Scale tables in the database by looking at tables prefixed by AO_4D28DD_ . All of our tables will have the same prefix.

    • benice25's avatar
      benice25
      Occasional Contributor
      4 years ago

      Awesome, thanks for that, luziamendes. I was able to locate them late last week, but this helps as a confirmation. One more quick question you might be able to help with, I see those tables in our DEV environment, but our TEST environment also had test cases, plans, cycles, etc. but I do not see the same tables in TEST. Is there a minimum limit before those tables are created?