- Created by user-0d7db, last modified on Apr 16, 2019
Before beginning this procedure, you'll need the URL to an open-source data feed. Illustrations on this page use https://ransomwaretracker.abuse.ch/feeds/csv/ to serve as a representative example.
- Open the open-source data feed.
Identify the column heads and separation symbol.
Column Heads: Separation Symbol:
- In your favorite text-edit application, update spec.xml to contain the column heads you need. Your updated xml file should look similar to this:
Still in your text-edit application, create a sample_data.txt file like this one that contains one or more rows of data from the feed.
- Log in to Lumeta Command Center via your browser interface.
- Navigate to Settings >Tables > Add Table.
- In the Name field, enter a descriptive name for the table you are creating such as ransomware_tracker_feed.
- In the Table Type field, select Managed Primary Table.
- At your option, you can add Tags to help other Lumeta users to find the table and a Description to let others know the purpose of the table.
- Browse to and then select the spec.xml and sample_data.txt files.
- Click Next.
The column headings for your table display, ordered alphabetically. Review the values listed in the Field column to confirm that they match your spec.xml.
- Click the Value Index checkbox for those fields you want to HDFS to index immediately. If you do not check any items in the Value Index column, your table with still be created–just not indexed.
- Click Create Table.
The table structure is created in the Lumeta's HDFS data store.
- of your Lumeta Command Center.
- At the command-line prompt, enter
You now have access to Lumeta's PostgreSQL database.
- Insert the feed details into Lumeta's PostgreSQL database using the Insert command. The labels will remain the same from feed to feed. The values for each label will need to be customizer for your feed. Here's a sample entry:
insert into system.feed(name, shortname, enabled, overwrite, url, key, filename, tablename, pipelinename, pollinterval) values ('ransomware-tracker', 'ransomware', true, true, 'https://ransomwaretracker.abuse.ch', '','/feeds/csv/', 'lumeta.public.ransomware_tracker_feed', 'ransomware',1440);
- Make sure the insertion was received by entering
select * from system.feed where name ='ransomware-tracker';A response similar to this one indicates that Lumeta's database has received the insertion.
- To validate the connection, restart the lumeta-api service by entering:
support service api restartThe feed will begin to populate and records will very soon be available in the Lumeta GUI.
- In the Lumeta GUI, browse to Settings > Tables.
- Select the ransomware_tracker_feed table.
- Check the number of records present to confirm that the database has been populated.
- Click View.
Congratulations! The table displays. Lumeta has ingested an external data feed.
Congratulations! You have caused Lumeta to ingest a feed of external data.
- No labels