#Dynamic mysql query odbc excel driver#

Query1 = SapHana. Once the results were returned, I continued just using the regular power qroup by function to further consolidate the results:Д«uild0 = Text.From(fnGetParameter('Quote')),Д«uild1 = 'Select ''Condition'', ''Item_No'', ''FKDAT'', ''IV01_Formula_Description'', ''ZP01_Formula_Description'', ''ZP03_Formula_Description'', ''ZZP2_Formula_Description'', ''ZZQE_Formula_Description''#(lf)#(lf)FROM ''_SYS_BIC''.''Master_Data/KONV_CONDITIONS_W_OICQ7_FORMULAS'' #(lf)GROUP BY ''Condition'', ''Item_No'', ''FKDAT'', ''IV01_Formula_Description'', ''ZP01_Formula_Description'', ''ZP03_Formula_Description'', ''ZZP2_Formula_Description'', ''ZZQE_Formula_Description''',Д«eginDate = Text.From(fnGetParameter('Begin_Date')),Д®ndDate = Text.From(fnGetParameter('End_Date')),Дbquery1 = Build1&Build2&Build3&Build4&BeginDate&Build5&Build6&Build7&EndDate, The ODBC solution for accessing data led to ODBC database drivers, which are dynamic-link libraries on Windows and shared objects. I segmented the query into a series of build statements and then combined them to form the SQL Query that would hit SAP HANA. To facilitate the need of using multi-quotation marks in the query syntax, I also added a (') Quote symbol to my Excel parameter table: I built a parameter table in Excel with a Begin and End date. KONV is in excess of 50 million records so dynamically filtering a narrow date range on the SAP side was highly preferred performance wise.

#Dynamic mysql query odbc excel driver#

If you are given the option of opening the 32-bit or 64-bit window, open the one that matches the driver you installed and your Excel install. Click OK and you will see the field names from the stored procedure get. Open the ODBC Data Sources Administrator by searching for it in the start menu. Click the Properties button and go to its Definition tab and change its Command Type to 'SQL' and in the Command Text box enter the name of stored procedure we created above and pass the parameters initially using empty quotes for the parameter values as shown below. I had a similar situation hitting very large SAP table Data sources (KONV - Condition Types, and OICQ7 Condition Type Formulas. With MySQL Connector/ODBC installed, you need to configure the data source in Windows so we can use it in Excel.