topic Re: Criação de consulta personalizada banco Oracle in Brasil https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300306#M46724 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #006621; font-family: arial, sans-serif; font-size: 14px;"><A class="jive-link-external-small" href="https://www.youtube.com/watch?v=YUzdBvIDpQA" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=YUzdBvIDpQA</A></SPAN></P><P class="f kv _SWb" style="color: #808080; font-family: arial, sans-serif; font-size: small;"><SPAN style="color: #006621; font-size: 14px;"><A class="jive-link-external-small" href="https://www.youtube.com/watch?v=sJfjLCTXHpk" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=sJfjLCTXHpk</A></SPAN></P><P><SPAN style="color: #006621; font-size: 14px; font-family: arial, sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 19 May 2017 14:41:31 GMT Clever_Anjos 2017-05-19T14:41:31Z Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300297#M46715 <HTML><HEAD></HEAD><BODY><P>Bom dia, sou novo no qlik sense trabalho com Tableau e gostaria de saber como faço para construir uma consulta personalizada em uma conexão Oracle, eis o QSL: </P><P></P><P></P><P>select SRID, WORK_ORDER_ID, ASGRP, GSC_DTMDATAFECHAMENTO, GSC_CIDADEUNIDADE, SITE, woi_JustificativaCancelamento, ASORG, SITE_GROUP, GSC_UFUNIDADE, ASCPY, SUMMARY, STATUS,</P><P>STATUS_REASON, SUBMIT_DATE, ACTUAL_START_DATE,VENDOR_TICKET_NUMBER, ACTUAL_END_DATE, COMPLETED_DATE, PRODUCT_CAT_TIER_3__2_, GSC_CEP </P><P>FROM WOI_WORKORDER Where SUBMIT_DATE &gt;= 1483228800</P></BODY></HTML> Fri, 19 May 2017 12:19:37 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300297#M46715 2017-05-19T12:19:37Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300298#M46716 <HTML><HEAD></HEAD><BODY><P>Danilo</P><P></P><P>Basta você criar uma conexão do Qlikview com o banco de dados e então criar uma tabela com esse SQL.</P></BODY></HTML> Fri, 19 May 2017 13:00:43 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300298#M46716 Marcio_Campestrini 2017-05-19T13:00:43Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300299#M46717 <HTML><HEAD></HEAD><BODY><P>Você precisar usar o Editor de Script de Carga (<A href="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/use-data-load-editor.htm" title="https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/use-data-load-editor.htm">https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/use-data-load-editor.htm</A>)</P><P></P><P>Em linhas gerais é criar a conexão e copiar/colar seu SQL</P></BODY></HTML> Fri, 19 May 2017 13:10:46 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300299#M46717 Clever_Anjos 2017-05-19T13:10:46Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300300#M46718 <HTML><HEAD></HEAD><BODY><P>então, não uso o view e sim o sense, é o mesmo procedimento?</P></BODY></HTML> Fri, 19 May 2017 13:15:14 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300300#M46718 2017-05-19T13:15:14Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300301#M46719 <HTML><HEAD></HEAD><BODY><P><IMG alt="conexão.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164045_conexão.png" style="height: 349px; width: 620px;" /></P><P>Criei a conexão com banco Oracle, e agora?</P></BODY></HTML> Fri, 19 May 2017 13:24:31 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300301#M46719 2017-05-19T13:24:31Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300302#M46720 <HTML><HEAD></HEAD><BODY><P>O mesmo procedimento, o link que te passei é do Sense...</P></BODY></HTML> Fri, 19 May 2017 14:20:13 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300302#M46720 Clever_Anjos 2017-05-19T14:20:13Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300303#M46721 <HTML><HEAD></HEAD><BODY><P>me desculpe ainda não consegui proceder usando o seu link.</P></BODY></HTML> Fri, 19 May 2017 14:22:11 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300303#M46721 2017-05-19T14:22:11Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300304#M46722 <HTML><HEAD></HEAD><BODY><P><IMG alt="c1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164044_c1.PNG" style="height: 386px; width: 620px;" /></P><P><IMG alt="c2.gif" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/164060_c2.gif" style="height: 299px; width: 620px;" /></P></BODY></HTML> Fri, 19 May 2017 14:32:27 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300304#M46722 Clever_Anjos 2017-05-19T14:32:27Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300305#M46723 <HTML><HEAD></HEAD><BODY><P>Muchas Gracias, deu certo.</P></BODY></HTML> Fri, 19 May 2017 14:41:14 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300305#M46723 2017-05-19T14:41:14Z Re: Criação de consulta personalizada banco Oracle https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300306#M46724 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #006621; font-family: arial, sans-serif; font-size: 14px;"><A class="jive-link-external-small" href="https://www.youtube.com/watch?v=YUzdBvIDpQA" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=YUzdBvIDpQA</A></SPAN></P><P class="f kv _SWb" style="color: #808080; font-family: arial, sans-serif; font-size: small;"><SPAN style="color: #006621; font-size: 14px;"><A class="jive-link-external-small" href="https://www.youtube.com/watch?v=sJfjLCTXHpk" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=sJfjLCTXHpk</A></SPAN></P><P><SPAN style="color: #006621; font-size: 14px; font-family: arial, sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 19 May 2017 14:41:31 GMT https://community.qlik.com/t5/Brasil/Cria%C3%A7%C3%A3o-de-consulta-personalizada-banco-Oracle/m-p/1300306#M46724 Clever_Anjos 2017-05-19T14:41:31Z