topic Oracle as the main source for data extraction instead of using excel!! in QlikView https://community.qlik.com/t5/QlikView/Oracle-as-the-main-source-for-data-extraction-instead-of-using/m-p/621979#M228965 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Tahoma','sans-serif';">Hey Guys,</SPAN></P><P><SPAN style="font-family: 'Tahoma','sans-serif';">I had a quick question?</SPAN></P><P> </P><P><SPAN style="font-family: 'Tahoma','sans-serif';">Informatica will be used as the ETL tool to facilitate incremental data extract from Veeva(CANADA AND US DATA) into the Staging database. Oracle will serve as the Staging database to which SAP BI will connect to extract the Veeva data on a daily basis. </SPAN></P><P> </P><P><SPAN style="font-family: 'Tahoma','sans-serif';">Initially we used excel files to extract data. </SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">Oracle views are created on top of the data tables in both the Staging schemas which will be referred by SAP BI to extract data into their system to be used for reporting.</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">I need some quick comments on this.</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">What changes need to be incorporated to use Oracle now as the main source to extract data? Will i face any problems???</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">Thanks for the help!!!!!</SPAN></P><P> </P><P> </P></BODY></HTML> Fri, 07 Feb 2014 15:43:12 GMT 2014-02-07T15:43:12Z Oracle as the main source for data extraction instead of using excel!! https://community.qlik.com/t5/QlikView/Oracle-as-the-main-source-for-data-extraction-instead-of-using/m-p/621979#M228965 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Tahoma','sans-serif';">Hey Guys,</SPAN></P><P><SPAN style="font-family: 'Tahoma','sans-serif';">I had a quick question?</SPAN></P><P> </P><P><SPAN style="font-family: 'Tahoma','sans-serif';">Informatica will be used as the ETL tool to facilitate incremental data extract from Veeva(CANADA AND US DATA) into the Staging database. Oracle will serve as the Staging database to which SAP BI will connect to extract the Veeva data on a daily basis. </SPAN></P><P> </P><P><SPAN style="font-family: 'Tahoma','sans-serif';">Initially we used excel files to extract data. </SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">Oracle views are created on top of the data tables in both the Staging schemas which will be referred by SAP BI to extract data into their system to be used for reporting.</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">I need some quick comments on this.</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">What changes need to be incorporated to use Oracle now as the main source to extract data? Will i face any problems???</SPAN></P><P> </P><P><SPAN style="font-size: 11pt; font-family: 'Tahoma','sans-serif';">Thanks for the help!!!!!</SPAN></P><P> </P><P> </P></BODY></HTML> Fri, 07 Feb 2014 15:43:12 GMT https://community.qlik.com/t5/QlikView/Oracle-as-the-main-source-for-data-extraction-instead-of-using/m-p/621979#M228965 2014-02-07T15:43:12Z