Member since
09-25-2015
37
Posts
45
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5776 | 07-06-2017 08:46 PM | |
1540 | 10-03-2016 08:51 PM | |
2038 | 06-23-2016 02:24 PM | |
2292 | 05-25-2016 10:04 PM |
04-15-2021
03:58 PM
Thanks @wsalazar for the insights. I know it is an older article, but it is worth revisiting. For real time data need what would approach would you take to connect from NiFi?
... View more
05-08-2020
12:11 PM
@Griggsy I'd strongly encourage you to start a new question rather then asking for help on an existing question with an already accepted solution. You'll get better traction and visibility that way. Matt
... View more
05-04-2020
09:00 AM
The whole OPC UA package is now in .net standard - can some one share any articles on how to build a .nar file from the open source GIT repo ?
... View more
01-23-2020
06:23 AM
@alexmc As this thread is a couple of years old, you would be better served by creating a new thread.
... View more
10-18-2018
04:21 PM
Hi @wsalazar , Thanks for the nice explanation. I was wondering how you do it with composite keys ? We have spent sometime exploring phoenix encoder. Using this, data insertion is good but while reading and doing the range scan it somehow is very slow. Seems only the first part of the composite key is used for filter and rest of the key is not taken into account.
... View more
01-15-2019
10:44 AM
@Louis Allen Just to confirm: Is the server where SQL runs kerberized, and have you set up a relaton of trust?
... View more
04-26-2017
12:26 PM
7 Kudos
Accessing data from industrial control devices can be made easier and safer by utilizing an OPC Server. OPC Servers provide protocol proxy services by translating requests for data from a standardized protocol like OPC to the native protocol of the industrial control device. Since the typical OPC Server can proxy many requests into many different protocols each for a different family of data sources they also make ideal aggregation points for control system data. Centralized data access also has advantages in security that should not be overlooked. The OPC Sever and Nifi can work together to provide certificate based authentication and role based data access to devices in process control networks. Nifi's unique pedigree is capable of complying with the stringent network ingress and regress rules. Get started fast with Kepware and Apache Nifi Out of the box tools available in KepServer Ex can make data available via HTTP and MQTT. ----|Kepware|---HTTP REST API-----|NIFI| or ----|Kepware|-----------MQTT-----------|NIFI| Data can also be acquired via OPC UA but this requires you to build the Nifi processor available at https://github.com/wadesalazar/NIFI-OPCUA First Get Kepware Download and install a copy of Kepware's Kepserver on a Windows VM host. You can download the application at at https://my.kepware.com/download/demo/ex/ The installation is straightforward but be sure to install select the optional IoT Gateway Plug-in. Start KepServer Configuration from the Windows Start menu. After being started a unlicensed demo will run for 2 hours before “timing out”. Restarting the server will restore it. Open the KepServerEX Configuration tool and select IoT Gateway Right click on the default agent and select New IoT Item Select Sin1 from the simulation functions and apply this tag. Selecting a scan rate and ok applies this tag configuration to this agent. From here you can export a CSV file that can be used for batch imports of IoT Item configurations Again right click on the Agent but select Properties this time. On the Endpoint tab of the dialogue box you will find the port configuration and option to enable HTTPS. Here you can also find a test link for the server which will bring you to a docs page that explains the available queries and JSON response format Now the data has been exposed over HTTP you may make REST requests to KepServer for data. Configure Get HTTP processor The URL is something of the form: http://YOUR.KEPSERVER.ADDRESS:39320/iotgateway/read?ids=Simulation%20Examples.Functions.Sine1 Review the acquired data in the data providence section of Nifi FYI the default JSON from Kepware puts [] around the inner document like this: {"readResults":[{"id":"Simulation Examples.Functions.Sine1","s":true,"r":"","v":33.705616,"t":1462251936055}]} Using MQTT or OPC UA is a very similar process requiring only changes in the Nifi processors used. Enjoy!
... View more
Labels:
12-05-2016
11:49 PM
2 Kudos
To post random data to Azure Event hubs using HTTP, use a generate flowfile processor to first generate the random data. Connect this to an UpdateAttribute processor to add your SAS (Share Access Signature) as a new attribute called "Authorization" to the flow file's attributes. Finally use PostHTTP to submit the data to Event Hubs Place the following processors on the pallet and set the run schedule of the generate flowfile processor to something reasonable like 10 seconds. Configure Update Attribute, adding the "Authorized" property with a SAS token. For more information on creating a SAS token see https://community.hortonworks.com/articles/69823/creating-shared-access-signature-sas-for-posting-d.html Configure the PostHTTP to post the URL https://eventhub-nifi.servicebus.windows.net/hub-nifi/messages Note: I set the content type to text/plain you should set this to suit your use case. Only the truststore needs to be configured for this example as we only need to trust the server certificates presented to us by the Azure servers. For simplicity I use Java's default keystore. See this post for finding and configuring the SSL service to use this keystore. Otherwise you will need to import trust certificates into your keystore manually Start all processors and verify successful submissions to the Event Hub Service in the Azure Portal Background on the security mechanisms of Event Hubs https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-shared-access-signature-authentication Background on Shard Access Signatures and how to generate them https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-sas-overview
... View more
Labels:
04-13-2017
05:58 PM
Thanks for sharing. There are a few inaccuracies: the example URL https://eventhub-nifi.servicebus.windows.net/hub-nifi differs from what you actually use in the example what is even more confusing, it that the URL you encode and hash is http; this however does not work, the hashed URL should be https the text says (or at least suggest) that the string contain of the URL with the "\n" and date append, must be URL-encoded, but this wont work: first the URL must be encoded and after that, the "\n" and date must be appended.
... View more
11-10-2016
06:25 PM
Nice writeup @wsalazar. I think you can simplify your classpath setup by only including the /usr/hdp/current/phoenix-client/phoenix-client.jar and the XML configuration files (core-site, hdfs-site, hbase-site). The phoenix-client.jar will contain all of the classes necessary to connect to HBase using the Phoenix (thick) JDBC driver.
... View more