Like many of you, I have some experience with relational DBs, dcoument-based DBs, object-based DBs etc.
I’ve tried looking in the forum and in the help for documents that will help someone who is new to Panorama X get up to speed quickly. The tutorials were a good starting point but they don’t really address some questions I have. For example:
- In a relational database, table joins provide the structure and enforce relational integrity. How is this performed in PanX? Is there an equivalent? What about cascading deletes?
- What is the maximum size of a field?
- Can PanX be accessed using ODBC/xBDC?
I feel PanX has a lot of potential and am already a subscriber, but it’s a competitive field out there and more information is needed to assess why PanX would be a suitable solution. I’m not talking about buzzwords like “64-bit in-memory” which most people wouldn’t be able to appreciate. For example the morphing ability is a clear winner, which as everyone knows, ETL is a major pain for database users. Would really appreciate if there’s a document out there that says “this feature will save you time/money if you’re used to doing X in another database”. Or even being honest like “This feature that you take for granted in X database is not available in PanX, but here’s a workaround” or something to that effect.
Thanks for reading this.