topic Re: Possible to directly query CDW for the Schema Models? in Archived Groups https://community.qlik.com/t5/Archived-Groups/Possible-to-directly-query-CDW-for-the-Schema-Models/m-p/938980#M218 <HTML><HEAD></HEAD><BODY><P>Kudos to Epic on their lightning fast response!</P><P></P><P>Per Kevin Ames, this metadata doesn't just live in the Cogito console but also in the Staging Database. These can be queried as they're standard SQL tables.</P><P></P><P>Stay tuned for something potentially ridiculously cool.</P></BODY></HTML> Thu, 08 Oct 2015 16:05:39 GMT jwbadger3 2015-10-08T16:05:39Z Possible to directly query CDW for the Schema Models? https://community.qlik.com/t5/Archived-Groups/Possible-to-directly-query-CDW-for-the-Schema-Models/m-p/938979#M217 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Hi folks,</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">I'm cross posting this from post on the Epic <A href="https://userweb.epic.com/Thread/44641" target="_blank">UserWeb</A>.</SPAN></P><P>******************************************************************************************************************</P><P style="margin: 10px 0; font-family: 'Segoe UI', sans-serif; color: #333333; font-size: 14.4px;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Good morning,</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">UW Health is in the process of building out several applications in QlikView that directly reference the Epic CDW models (like CHOA has posted in the report repository).</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">We want these models to be comprehensive and self maintaining for each release of CDW. </SPAN></P><P style="margin: 10px 0; font-family: 'Segoe UI', sans-serif; color: #333333; font-size: 14.4px;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">The only way I could think of doing this is to reference the models as they are documented in the CDW console's ER Diagrams.</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Has anyone attempted or figured out a way to connect to this and leverage it as a tool for BI development?</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 10pt;">As some additional background, I manually created the following excel that captures the logical linkings of tables to schemas for CDW 9.</SPAN></P><P></P><P><SPAN style="color: #333333; font-size: 10pt; font-family: arial, helvetica, sans-serif;">I can use this for my current modeling work, but when CDW is updated or new schemas are added, I would need to manually update this excel.</SPAN></P></BODY></HTML> Tue, 22 Jul 2025 14:29:37 GMT https://community.qlik.com/t5/Archived-Groups/Possible-to-directly-query-CDW-for-the-Schema-Models/m-p/938979#M217 jwbadger3 2025-07-22T14:29:37Z Re: Possible to directly query CDW for the Schema Models? https://community.qlik.com/t5/Archived-Groups/Possible-to-directly-query-CDW-for-the-Schema-Models/m-p/938980#M218 <HTML><HEAD></HEAD><BODY><P>Kudos to Epic on their lightning fast response!</P><P></P><P>Per Kevin Ames, this metadata doesn't just live in the Cogito console but also in the Staging Database. These can be queried as they're standard SQL tables.</P><P></P><P>Stay tuned for something potentially ridiculously cool.</P></BODY></HTML> Thu, 08 Oct 2015 16:05:39 GMT https://community.qlik.com/t5/Archived-Groups/Possible-to-directly-query-CDW-for-the-Schema-Models/m-p/938980#M218 jwbadger3 2015-10-08T16:05:39Z