Search found 44 matches

by closch
20 Oct 2020, 13:02
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Thanks very much for the help, I can report success with the basic connection! Loading the PowerBI template generates a very large number of errors which I'm assuming is down to the limited data population of my environment, however, the one specific thing I would like to check on though is that a ...
by closch
16 Oct 2020, 15:35
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Hi, still no joy I'm afraid, I've followed the steps a number of times and within PowerBI first get asked hot to connect, i then go to edit credentials which shows the connector with anonymous, then it tries to connect and I get an error saying it cant connect with the credentials provided. I've te...
by closch
14 Oct 2020, 14:04
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Hi, I'm a new Essential Cloud user and haven't been a developer for many years, so struggling to work through why I can't get this to work. I'm getting a credentials error when running the connector query. I'm assuming the username is the full email address to log-in to the platform, or have I miss...
by closch
13 Oct 2020, 16:29
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Looks like v6.11 release may have broken the connector (at least it's stopped working for me) - I'll get it working again my end, and then we can troubleshoot if still an issue.
by closch
04 Sep 2020, 11:29
Forum: General
Topic: Essential University User Group
Replies: 6
Views: 19334

Re: Essential University User Group

I don't know if they'll be minuting their discussions in any fashion, but i wonder if some of the discussion would be of benefit across to users from other industries. Could you find out what they might be willing to share?
by closch
05 Aug 2020, 09:35
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

FYI - Latest Power BI update looks like some incredibly useful features that can be taken advantage of Full update Info here : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2020-feature-summary/ Q&A Field synonyms for Q&A - good when multiple terms are used to mean the same ...
by closch
28 Jul 2020, 11:29
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Hi Chris, for those of us unable to use powerbi, would it be possible for you to post some screenshots demonstrating the kind of reports you defined through the connector ? Either here or on github ? Thanks, Jean-Marie. I've also included a gif showing the ease with which these can be pulled togeth...
by closch
27 Jul 2020, 17:37
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Also, (as I forgot this earlier) You can bring in Visio visuals, but they are a little more limiting/complicated (depends on sharepoint/visio web services) In this simple example, visio block elements use data in PowerBI from EAS to colour-code and place text about lifecycle status EA_9.png You can ...
by closch
27 Jul 2020, 16:20
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

How you bring all these bits and pieces onto a single page/dashboard will depend on the "message" or "story" that page is designed to tell... Which is where my hope lies, by sharing this proof of concept, we all can build on it and share "this worked for me with my <insert u...
by closch
27 Jul 2020, 16:15
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Trying out other visuals to show Technical Debt
EA_8.png
Another Overview Dashboard
EA_4.png
A view of the latest Data Model (bits of Metamodel from EAS that i've brought into PowerBI)
EAS_Screenshot_4.png
by closch
27 Jul 2020, 16:14
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Basic GIS View
EA_7.png
Calendar visuals
EA_6.png
Basic Dashboards
EA_5.png
by closch
27 Jul 2020, 16:13
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Hi Chris, for those of us unable to use powerbi, would it be possible for you to post some screenshots demonstrating the kind of reports you defined through the connector ? Either here or on github ? Thanks, Jean-Marie. Sure, I'll probably get around to posting in GitHub in due course! Firstly, we ...
by closch
20 Jul 2020, 13:32
Forum: Community Contributions
Topic: PowerBI PoC Template v2
Replies: 0
Views: 20949

PowerBI PoC Template v2

v2.0 of the PowerBI Dashboard is now released, Until such time it's merged with Master it can be found under the Pull request https://github.com/essentialproject/essential-contributions/pull/3/files You should find all the necessary PowerBI concepts and ideas to produce what you need (there's exampl...
by closch
16 Jul 2020, 15:46
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

v2.0 of the PowerBI Dashboard is now released, Until such time it's merged with Master it can be found under the pull request https://github.com/essentialproject/essential-contributions/pull/3/files You should find all the necessary PowerBI concepts and ideas to produce what you need (there's exampl...
by closch
16 Jul 2020, 14:12
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Hi Chris, We're a new user of EA cloud. This will no doubt be extremely useful. My plan is eventually to allow our analytics team to own the design and build of the dashboards so the pain doesn't sit with IT to build new EA viewer views, however, I suspect it will be a mix. On that note, do you hav...
by closch
01 Jul 2020, 15:25
Forum: Essential Modelling and Viewer
Topic: How do we map Regulatory Bodies in the Model
Replies: 2
Views: 11922

Re: How do we map Regulatory Bodies in the Model

Thx Jason, I'll give that a go, let you know how it works out.
by closch
30 Jun 2020, 08:50
Forum: Essential Modelling and Viewer
Topic: How do we map Regulatory Bodies in the Model
Replies: 2
Views: 11922

How do we map Regulatory Bodies in the Model

Is anyone modelling regulatory bodies and how they map to the business model (which business units/regions they apply to, regulated applications etc.) I'm thinking things like mapping PCI-DSS impacting our Customer Account Management system, across all regions etc. If so, could you explain how you'v...
by closch
22 Jun 2020, 15:12
Forum: Community Contributions
Topic: PowerBI Desktop and Custom Connector
Replies: 0
Views: 19916

PowerBI Desktop and Custom Connector

FYI - in case you missed it in the other subforum : https://www.enterprise-architecture.org ... =23&t=2399
by closch
22 Jun 2020, 13:25
Forum: Essential Modelling and Viewer
Topic: Value streams
Replies: 5
Views: 19120

Re: Value streams

@Jason

Sounds good -

Will 6.11 also update the value stream view so that the capabaility name(s) will show appropriately ?

Chris
by closch
22 Jun 2020, 09:43
Forum: General
Topic: forum posting with code xsl - cloudfare blocks saying security issue
Replies: 1
Views: 8963

Re: forum posting with code xsl - cloudfare blocks saying security issue

I believe I read that you need to zip the xsl files and then attach the zip.
by closch
22 Jun 2020, 09:27
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

This work has a new home https://github.com/essentialproject/ess ... tributions

The old repo will be retired.

Thanks @NeilWalsh for setting this up
by closch
19 Jun 2020, 13:01
Forum: Essential Modelling and Viewer
Topic: List of Application by Organisation
Replies: 10
Views: 27317

Re: List of Application by Organisation

Hoping this might also help : Have at the Power BI report i published to the community (More info on it here : https://www.enterprise-architecture.org/forums/viewtopic.php?f=23&t=2399) Here's an example of the type of report you're asking about done in PowerBI (takes <5 mins to construct - and h...
by closch
17 Jun 2020, 12:05
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

I've updated Revision of the PowerBI template to make it TenantID agnostic (you'll be prompted for tenantID) and also make it "user friendly" by hiding and renaming fields/classes to something more understandable by those less familiar with the metamodel. Feedback welcomed - also, let me k...
by closch
16 Jun 2020, 15:49
Forum: Essential Project Suggestions
Topic: Placing essential project opensource related contributions
Replies: 5
Views: 18422

Re: Placing essential project opensource related contributions

Neil, I'm not an expert in Git/Open Source contribution concepts, but for some time i've felt a shortfall for the community to be able to rapidly share ideas/views/customisations, so I've spawned <removed> - edit: new vendor provided location https://github.com/essentialproject/essential-contributio...
by closch
16 Jun 2020, 15:32
Forum: Essential Cloud
Topic: Integrations?
Replies: 5
Views: 17434

Re: Integrations?

Cheers John, I'll have a look see if i can wrap my head around it (as an amateur in the systems integration/dev world)

It'd be great if the Utility API Docs/Postman examples were up alongside the core-api https://api.enterprise-architecture.org/?version=latest - but I've got the PDF for now
by closch
16 Jun 2020, 14:59
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

The above Repo now includes PowerBI template https://github.com/essentialproject/ess ... rs/PowerBI

edit: new location
by closch
16 Jun 2020, 13:51
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

So i've created a Community source code Repo here https://github.com/essentialproject/ess ... tributions You can find the Custom Connector Source Code here : https://github.com/essentialproject/essential-contributions/tree/master/connectors/PowerBI I'll post the PowerBI Template up there too a bit l...
by closch
11 Jun 2020, 08:47
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

Re: PowerBI Desktop (and Custom EAS OAuth2 Connector)

Update

So I've written a Custom Connector which works with the OAuth2 (bearer token etc.) - whilst functional, it may not be the most elegant way but as a PoC its fine. Those interested can reach out and i'll share.

Chris
by closch
08 Jun 2020, 16:12
Forum: Essential Cloud
Topic: PowerBI Desktop (and Custom EAS OAuth2 Connector)
Replies: 31
Views: 90843

PowerBI Desktop (and Custom EAS OAuth2 Connector)

Thought I'd ask around - I've a PowerBI Dashboard, currently linking key parts of the MetaModel around to aid with more dynamic creation of reports. Couple of questions 1. Is anyone else using Power BI and wants to compare notes on what they're using it for - as well as any example reports? Current ...
by closch
21 May 2020, 08:49
Forum: Essential Project Suggestions
Topic: Essential Cloud - viewer editors
Replies: 1
Views: 10855

Re: Essential Cloud - viewer editors

Hi, the editors are a great addition. Would be great to be able to capture in the project editor the Change Activities planned changes. +1, I agree - we can use https://essentialviewer.com/demo/report?XML=reportXML.xml&XSL=enterprise/core_el_strategy_planner.xsl&LABEL=Strategy%20Planner&...
by closch
21 May 2020, 08:47
Forum: Essential Cloud
Topic: Integrations?
Replies: 5
Views: 17434

Re: Integrations?

Firstly it'd be great if there were some pre-baked integrations, where you just enter the credentials/keys and select the data you want and direction as many other SaaS packages now offer (maybe something for the future) However, we've performed integrations using Talend Open Studio (free) as the in...
by closch
04 Feb 2020, 15:12
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

Hi Colin,

Understood, I can appreciate that may be no small undertaking - any effort is appreciated.

@EAS - We could really do with a custom view sharing repo where we can build on eachohers views.

Chris
by closch
29 Jan 2020, 10:44
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

Hey Colin,

Sounds very interesting, are you able to provide a copy of the customisations?

Chris
by closch
17 Jan 2020, 16:20
Forum: Essential Cloud
Topic: Managing Approval Status for Applications and Technologies
Replies: 4
Views: 16072

Re: Managing Approval Status for Applications and Technologies

Ah! Found it, cheers! (wasn't looking there)

Be good to add this on the Application Editor also, it'd be useful to enable ease of maintaining the APM Application Reference Model
Untitled.png
by closch
15 Jan 2020, 10:33
Forum: Essential Cloud
Topic: Managing Approval Status for Applications and Technologies
Replies: 4
Views: 16072

Re: Managing Approval Status for Applications and Technologies

However, the Technology Product Editor and Technology Type Editor, available to Essential Cloud users from the Essential Viewer, allows for the scoping of Technology Product Standard Specifications to specific Organisations as shown in the screenshot below. Hmmm, on our Essential Cloud I don't get ...
by closch
13 Jan 2020, 11:27
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

More feedback

To get a match on wildcard version
Screenshot_1.png
had to put * value in the Technology Provider Version slot - rather than a numerical value
Screenshot_2.png
expectation: numerical versions would match any numerical version (as appropriate
by closch
09 Jan 2020, 12:57
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

Performance is much improved (it's working now :) and quicker than 10 secs ) There's definitely something different about how we use Tech Product and Tech Product family that we'll need to adapt - just having a think about what that means for us - might be too granular for our needs to map every ver...
by closch
08 Jan 2020, 10:53
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

Hi John, Thanks for posting the update. Running this updated view with https://nvd.nist.gov/feeds/json/cve/1.1/nvdcve-1.1-2019.json.zip as cvedata.json causes the webbrowser to hit 100% cpu and hang for... well it's not come back in 5 mins, so i'm going to say forever. using it with https://nvd.nist...
by closch
02 Jan 2020, 15:02
Forum: Essential Modelling and Viewer
Topic: How to use the new view "Tech Security Vulnerability Analysis"
Replies: 27
Views: 67268

Re: How to use the new view "Tech Security Vulnerability Analysis"

Having the same problem, though i grabbed https://nvd.nist.gov/feeds/json/cve/1.1/nvdcve-1.1-2020.json.zip from https://nvd.nist.gov/vuln/data-feeds uploaded the above as data.json (unzipped of course) in the view I only get the option in 'Vendor' of .All Testing this against a Tech product of "...
by closch
11 Feb 2019, 11:27
Forum: Essential Modelling and Viewer
Topic: Granularity of Classes
Replies: 2
Views: 12504

Re: Granularity of Classes

ta
by closch
22 Jan 2019, 11:16
Forum: Essential Modelling and Viewer
Topic: Granularity of Classes
Replies: 2
Views: 12504

Granularity of Classes

Hi All, As we start to model our business in the tool, running into some areas that require a bit of thought, perhaps two questions with a similar theme, which is "How granular should we be?". 1. Application Services As we map out the application estate, we run into the situation where an ...