Hey all,
When developing a data warehouse one of the most time consuming tasks is which tables contains which data and how are the tables hooked up to each other. luckily, most databases nowadays have there PK and FK metadata set up correctly. In the BU of TimeXtender it is possible to ‘Add sugessted constraints’. Which will put PK's and FK on the tables. With some creative work it is possible to see which tables have a relation with what tables and it's easy to create you're model. Except, you have to load the tables first before you can do this. In the new version with the ODX server I believe this possibility is somewhat gone.
My suggestion is: Within the ODX server => would it be possible to have a ‘Source ERD’ option. Where you Sync the source, you get this data and then create the ERD overview. Would be really cool to have an extra function when you select a table it would highlight the tables it has a relation with and then with a simple selection you can add it to the tables you want to load.
When working with Qlik Compose I saw a functionality like this. Very helpful. Maybe take a look there.
ps. If there is software out there that already does this and I've clearly missed this: Please let me know
Thank you
= Daniel
