SEE DEMO

May 31, 2022

Forward Networks 22.5 Release adds external sources to provide a powerful data aggregation layer for comprehensive testing and integration.

by Gary Berger

We just released our 22.5 Release to Forward Enterprise and boy what a surprise to have our NQE external data sources finally ready to show the world.

Very simply, this allows you to pull in data from external HTTP sources (currently we support HTTP GET) and automagically model the data in our data model explorer and our integrated development environment.

To enable this you simply need to add the resource endpoints for the HTTP API of the data you are interested in. i.e. /api/dcim/sites, configure the authentication if required and you are ready to collect.

Once you run our collection framework we will pull all of this information into our already extensive data model.

All the data available from the external resource definition is modeled in our platform and can be used to build custom evaluations across external/internal resources and unify multiple data sources into a representation that can be consumed from external systems.

Our import includes a type inference capability to determine if values can be elevated from String, Number to more specific types such as IPAddress.

Once we have added our external resource endpoints. We can run our collection to pull the external data into our platform as a JSON encoded file.

Building out our custom integration layer

Now that we have the data, we compose queries using our rich IDE capabilities. Below you can see our code completion displays all the available collections under the NetBox external source.

Because NQE is an extensible query language we can join two or more collections together by simply binding common fields leveraging the where clause.

The two where clauses in lines 8 and 9 below join the existing Forward Enterprise device collection with the NetBox devices inventory as well as joining the NetBox devices collection with sites collection allowing us to create a composite output of three independent data sources.

The final query below combines data from these three sources allowing us to take the device name, site name and manufacturer from the NetBox devices collection, Site address from the sites collection, and interface IP addresses from Forward Enterprise Data model to produce an aggregate report.

Below is the output from our IDE but you can also export this data to an Excel spreadsheet for offline review.

Hold on to your hat!, Now that we have our query committed in the NQE Library, it automatically becomes available as a custom API endpoint. Now any external systems can make a simple REST call providing just the unique queryId, (think of this like a SQL Stored Procedure) to the /api/nqe endpoint and you get back the data in JSON!

In the below example, we create an Ansible module to call the NQE API interface as a task so it can be combined with additional workflows.

Summary

With about 20 lines of code you can build an API aggregation layer for network information combining external data sources with the rich database of network configuration and state available in the Forward Enterprise platform.

Thanks to Andreas Voellmy and his team for building NQE and continuously adding these great features for our customers to leverage.

Here at Forward Networks our mission is to "Transform networks to be agile, predictable and secure" and now with external data sources we have another arrow in our quiver to accomplish that.

Way more to come.

Come check us out.

Subscribe to our blog!

RELATED FORWARD CONTENT 
June 23, 2022
What’s it Like to work at a Great Place 

Forward Networks just was named a Great Place to Work in the Bay Area by Fortune. We’re excited to be on this list in an area known for setting the bar when it comes to treating employees well. Perks are nice, but perks alone don’t get 100% of employees to say they work at a […]

Read More
June 20, 2022
Forward Networks named one of the Best Workplaces in the Bay Area™ in 2022 by Great Place to Work® and Fortune Magazine

SANTA CLARA, Calif., June 20, 2022 /PRNewswire/ -- Great Place to Work and Fortune magazine have honored Forward Networks as one of this year's Best Workplaces in the Bay Area. This is Forward Networks' first time applying for and being named to this prestigious list. Earning a spot means that Forward Networks is one of the best companies to work […]

Read More
June 7, 2022
Forward Networks Wins 2022 Fortress Cyber Security Award

SANTA CLARA, Calif., June 7, 2022 /PRNewswire/ -- The Business Intelligence Group today announced that Forward Networks has won the 2022 Fortress Cyber Security Awards in the Network Security category. The industry awards program sought to identify and reward the world's leading companies and products that are working to keep our data and electronic assets safe among a growing […]

Read More

Sign up for our newsletter

clockcrossmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram