We currently have lab assay LIMS data stored in SAP.
We started bringing this data to AF via a query into HANA, but it is clunky and the performance is poor.
What is a better option for bringing this data into AF? Or even to PI tags?
what is the original data source? Which LIMS system? Does it use a relational database? For lab data, we have customers who use OPC DA and some that use the RDBMS Interface. Those might work in your case but I would have to know about the original source.
If your data resides in SAP HANA, you can use the RDBMS interface (with the SAP HANA ODBC driver) to store the events in PI Points.
Retrieving data ...