topic How to optimize connections and loads in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-optimize-connections-and-loads/m-p/1296326#M6605 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>If I have two tables from Oracle DB and multiple tables from SAP, h<SPAN style="font-size: 10pt;">ow can I optimize my loads in my QlikView document?</SPAN></P><P></P><P>Is there an order for loads? I suppose that I need to open just one connection for both loads from Oracle DB and then loads tables from SAP. Do I need to know more?</P><P></P><P>If I can choose to open an OLEDB connection or an ODBC connection, what do I choose? The first one, right?</P><P></P><P>Thanks for your time (and sorry for my english)!</P></BODY></HTML> Fri, 02 Apr 2021 07:54:05 GMT 2021-04-02T07:54:05Z How to optimize connections and loads https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-optimize-connections-and-loads/m-p/1296326#M6605 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P></P><P>If I have two tables from Oracle DB and multiple tables from SAP, h<SPAN style="font-size: 10pt;">ow can I optimize my loads in my QlikView document?</SPAN></P><P></P><P>Is there an order for loads? I suppose that I need to open just one connection for both loads from Oracle DB and then loads tables from SAP. Do I need to know more?</P><P></P><P>If I can choose to open an OLEDB connection or an ODBC connection, what do I choose? The first one, right?</P><P></P><P>Thanks for your time (and sorry for my english)!</P></BODY></HTML> Fri, 02 Apr 2021 07:54:05 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-optimize-connections-and-loads/m-p/1296326#M6605 2021-04-02T07:54:05Z