Access Token
http://man.hubwiz.com/docset/ms_sql.docset/Contents/Resources/Documents/statements/create-database-scoped-credential-transact-sql.html https://connect2id.com/learn/oauth-2
Solution Architecture
Lean Architecture (PHP, Python)
Lean Architecture is the ongoing process of rethinking and improving architectural methodology. It is the pursuit of better work by applying Lean principles to every aspect of practice. It is about smarter information flow and understanding how we perceive and process information in order to be better communicators amongst ourselves and to the users of … Read more
Draw.io
diagrams.net (previously draw.io[2][3]) is a free and open source cross-platform graph drawing software developed in HTML5 and JavaScript.[4] Its interface can be used to create diagrams such as flowcharts, wireframes, UML diagrams, organizational charts, and network diagrams.[5] diagrams.net is available as online as cross-browser web app, and as offline desktop application for Linux, macOS, and Windows.[5] Its offline application is built using the Electron framework. The web app does not require online login or registration and can open … Read more
Power BI
7 reasons to use Power BI How do you know whether Microsoft Power BI is right for your organization? Here are seven reasons to choose Power BI — and one reason you may want to choose something else: A quick start. You’ll be able to get insights quickly with an uncomplicated setup, no required training, … Read more
Azure Data Services
Microsoft Azure offers services for a wide variety of data-related needs, including ones you would expect like file storage and relational databases, but also more specialized services, such as for text searching and time-series data. Azure Data Services support a range of needs Azure Data Services are built for efficiency Maintainability is at the core … Read more
Solution Architecture
Solution architecture is the practice of designing, describing, and managing solution engineering to match it with specific business problems. A solution architect is in charge of leading the practice and introducing the overall technical vision for a particular solution.
Solution Flow for myPinstone
index.html
Flow diagram
index.html
create_extDataSource
Overview The stored procedure dbo.[create_extDataSource] procedure manages the creation of credentials for the management of Access Tokens in SQL Whilst the solution imports data from the Azure Blob as json formatted files into the SQL import Tables, a connection has to be made between the SQL Database and the Blob Storage This connection is made … Read more