Member since
04-05-2016
139
Posts
144
Kudos Received
16
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 50696 | 02-14-2019 02:53 PM |
05-25-2022
01:41 PM
The ListS3 and FetchS3 processors in Apache NiFi are commonly used to retrieve objects from Amazon S3 buckets, but they can be easily configured to retrieve objects from IBM Cloud buckets. Assume, I have an IBM Cloud bucket that contains three CSV files: First, get the following from your IBM Cloud bucket configuration : Bucket Name Private Endpoint Then, from the Service Credentials of your Cloud Object Storage, get: Access Key ID Secret Access Key Note: If you don't have Service Credentials for the storage instance, create a new one with HMAC set to "true" (https://cloud.ibm.com/docs/cloud-object-storage?topic=cloud-object-storage-uhc-hmac-credentials-main) Create or confirm that your IBM Cloud user has the necessary Bucket Access Policy to view and download objects (https://cloud.ibm.com/docs/cloud-object-storage?topic=cloud-object-storage-iam-bucket-permissions) : With this setup information confirmed, add to and connect ListS3 and FetchS3 processors on your NiFi canvas, similar to the following: In the List S3 configuration, enter the Bucket, Access Key ID, Secret Access Key and Endpoint URL: Note: The Region property is ignored when the Endpoint Override URL property is used. Run the ListS3 processor and you will see a FlowFile generated for each of the bucket objects: Looking at the queue details: Now configure the FetchS3 similarly with the Bucket Name, Access Key ID, Secret Access Key and Endpoint Override URL: Run the FetchS3 processor and the three CSV files are retrieved from the IBM Cloud Bucket:
... View more
Labels:
05-04-2020
11:46 AM
Hi @yuvapraveen_k NiFi Registry is not supported on Windows. You can see the system requirements here: https://nifi.apache.org/docs/nifi-registry-docs/html/administration-guide.html#system-requirements
... View more
03-06-2020
01:06 PM
@MarkH Thanks for the comment and especially for the update. Glad to hear the flow is working for you and appreciate the workaround you documented to help others out in the community if they run into the same issue. It had been a while since I had run this flow so I tried it out today and ran a successful test in the latest released NiFi (Version 1.11.3).
... View more
04-09-2019
04:16 PM
convert-xml-to-csv.xml
... View more
03-25-2019
06:29 PM
NiFi doesn't currently support MS SQL, but it appears there is a NiFi contributor who has it in the works: https://github.com/apache/nifi/pull/2231 Not sure if the solutions uses transactional logs or not.
... View more
02-28-2019
09:14 PM
Thanks for the information Nitin. It seems like it would make sense to "clean up" your incoming XML using the TransformXML processor (https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.6.0/org.apache.nifi.processors.standard.TransformXml/) prior to ConvertRecord since there is data there like the header info that you don't care about for the CSV file. Additionally, could change the tag from `p` to its `name` attribute. I haven't used the TransformXML processor before (or worked with XSLT files before). Take a look yourself and see if you think it could be a solution for you. I will try it out myself if I get the opportunity.
... View more
02-27-2019
09:16 PM
Hi @Nitin Damle I'm assuming you got the flow working with the sample data and template I provided. Can you provide an example of the desired csv output you are hoping to achieve from the cm_samples.xml file you provided? That would help me understand your end goal for the flow. Thanks!
... View more
02-25-2019
08:53 PM
1 Kudo
One thing, I wanted to note. For the XMLReader controller service (https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-record-serialization-services-nar/1.9.0/org.apache.nifi.xml.XMLReader/index.html), I needed to set the Expect Records as Array property to "true".
... View more
02-25-2019
08:40 PM
2 Kudos
Hi @Nitin Damle Here is the XML to CSV template: convert-xml-to-csv.xml Here is the sample XML file to use: users.xml If you find these helpful, please "Accept" my original answer from February 14th as this template is the implementation of what I suggested to do.
... View more
02-21-2019
04:35 PM
Hi @Emil Brännström Thanks for your comments. I hope we can get the flow working for you end-to-end. The copy.users table should be automatically created, assuming you are capturing all the ddl events needed for it (the 1 DDL event for the creation of the 'users' table, 1 begin event, X # of insert events for the rows added to the table, and 1 commit event). What are the flowfile contents after CaptureChangeMySQL? It might also be helpful to check some of the troubleshooting tips in the third article, especially the ones regarding clearing state.
... View more