Also since Timo’s dashboard is using the data source name as MYSQL you might have to change that in case you decide to change the data source name in your dashboard.Assume you are using Timo JS code, just rename the reference of Timo’s INSERT PHP file to HANA one that you created in Step 5.Step 6: Update your MarkSelection JS file to refer to this PHP file created above. While ($row = odbc_fetch_object($result)) $sql = "INSERT INTO CPG.getdataandwriteback (ClusterName,CustomerName,CheckBox,UserInput,SelectedMeasure) VALUES ('".$clusterName."','".$customerName."','".$checkBox."','".$userInput."','".$selectedMeasure."')" Įcho "Error while sending SQL statement to the database server.\n" Do a basic select from DUMMY with is basically a synonym for SYS.DUMMY if you need to test in HANA Try to get a meaningful error if the connection failsĮcho "ODBC error code: ". $conn = odbc_connect("Driver=$driver ServerNode=$host Database=$db_name ", $username, $password, SQL_CUR_USE_ODBC)
Easiest way is use Select ‘A’ from dummy staement or even simple INSERT statment with dummy values into the table you created. Step 5: Inserting records into HANA PHP fileīelow is the code : You can run this PHP from your browser to test if statements are working. Modifaction requires you to just uncomment below two dll libraries which are already in the INI file. Step 4: Follow the same instructions from Timo blog post over copying all the required files of the extensions.īefore testing the HANA insert records PHP file, make sure to modify the ini file under location xampp\php in my case it is under npm. Download the HDB 32 bit HANA driver from SAP market place(SAP made it far more easier now to download the drivers).Execute c:\Windows\SysWOW64\odbcad32.exe in run The code used the 32 bit HDB HANA driver.Step 3: Download and Install required Drivers Note :For autoincrement in HANA for any column you would need to define the column as primary key and make it as IDENTITY You can create a columnar or a row table in HANA according to your needs. Step 2: As mentioned in MYSQL blog post create similar tables in HANA. Make sure the user has a content admin role over the required schema (synonyms/CDS objects if using 2.0).
You can use same XAMPP, however since I already have npm on my machine I was using that as a webserver to host the PHP file which finally writes back the data to SAP HANA.Įxtensions work for both HANA 1.0 and also 2.0(XSA-HDI) Step 1: Create a New User on HANA if you don’t already have one This document assumes you are already using or used Timo’s Extension write back to MYSQL.
0 kommentar(er)
