Purpose
This document defines the required access permissions and software installations for onboarding a new team member to a project.
Access Request Requirement
Syra Access - SyRa is an ITSM platform accessible to end users and IT agents. It is used to manage your service requests; reporting IT incidents related to Syensqo IT Services.
Check if you have access to SyRa -https://syensqo-dwp.onbmc.com/dwp/app/#/page/w9ph6wjq
It should be automatically assigned within a week of joining.
Once you have access to SyRa, you are good to go ahead and raise the remaining request which includes.
Link to raise the request -
Requestor - your AD account (automatically appears)
Nature - Select “Add” from drop down.
Copy from profile - mention - amol.ubale@syensqo.com or shubham.gupta1@syensqo.com
Comments - Give proper comments like below -
I am joining Data Platform team hence I need access for BMC Helix for ticket management.
Collaborators (Optional)
The request usually takes 1-2 days for completion.
2.Raise VM request.
Hi Team,
Would you please create the persistent VM for Neha and install below Softwares;
List of SWs;
Python 3.11 (native, not via MS Store!) ,
VSCode with below extensions - Azure tools - Python - Bicep - Github Copilot,
Git ,
Notepad++ with extensions - Json Tools plugin,
Postman Desktop ,
PowerBI Desktop
Az CLI
SSMS
WinSCP
One Lake Explorer
Zulu - Java
Putty
duckdb
https://syensqo-dwp.onbmc.com/dwp/app/#/knowledge/KBA00023401/rkm
Or directly click here - https://syensqo-dwp.onbmc.com/dwp/app/#/catalog/category/1339/SBE/SBE
Click on Third-Party Access (TPA) - User Access Management / Other Request / Software Installation (Software installation option is available for TPA team usage only)
Type of Request - Select TPA - Add/Remove (User)
Type of Action - Add User(s)
Then additional fields will appear, fill all the required fields and add collaborator and submit.
Company name Non-SCO - Check the spreadsheet and specify the same name.
AD Account(s) - Ad account created while registering in Syensqo - short account name.
The Email Address(es) for the User(s): Non Syensqo - Your parent company email id
Additional Comments - This is optional, however mention the team’s name and why you need VM something like below.
“Joining Data Team, hence required new VM for development and Testing.”
Once this is approved and completed. Now you can connect to Anup Mule for the Required software installation:
List Of Software to check after VDI Creation:
Download link : Software
What it is:
A popular programming language used for automation, data analysis, machine learning, and scripting.
Business justification:
Essential for developing and running scripts, data processing, and integrating with various tools and platforms.
Installation guide:
2. VSCode (Visual Studio Code) with Extensions
Azure Tools: For managing and deploying Azure resources directly from the editor.
Python: Adds support for Python development.
Bicep: For authoring and deploying Azure infrastructure as code.
GitHub Copilot: AI-powered code completion and suggestions.
What it is:
A lightweight, powerful code editor with support for multiple languages and extensions.
Business justification:
Enables efficient software development, cloud resource management, and automation, improving productivity and code quality.
Installation guide:
3. Git
What it is:
A version control system for tracking changes in code and collaborating with others.
Business justification:
Facilitates source code management, collaboration, and version tracking, which are critical for team-based development.
Installation guide:
4. Notepad++ with Json Tools Plugin
What it is:
A text editor with syntax highlighting and plugins for editing and validating JSON files.
Business justification:
Useful for quick editing, reviewing, and validating configuration files and scripts, especially JSON data.
Installation guide:
5. Postman Desktop
What it is:
A tool for developing, testing, and documenting APIs.
Business justification:
Streamlines API development and testing, ensuring robust integration between systems and services.
Installation guide:
6. PowerBI Desktop
What it is:
A business analytics tool for creating interactive reports and dashboards.
Business justification:
Empowers users to visualize and analyze data, supporting data-driven decision-making.
Installation guide:
7. Azure CLI
What it is:
A command-line tool for managing Azure resources.
Business justification:
Enables automation and scripting of cloud resource management, improving efficiency and consistency.
Installation guide:
8.SSMS (SQL Server Management Studio)
What it is:
A tool for managing SQL Server databases.
Business justification:
Essential for database administration, development, and troubleshooting.
Installation guide:
9.WinSCP / PuTTY
What it is:
WinSCP: File transfer tool supporting SFTP, SCP, and FTP.
PuTTY: SSH and telnet client for remote server access.
Business justification:
Facilitates secure file transfers and remote server management, supporting IT operations and development.
Installation guide:
10. OneLake Explorer
What it is:
A tool for accessing and managing data in Microsoft OneLake (part of Microsoft Fabric).
Business justification:
Enables efficient data access and management in cloud data lakes, supporting analytics and data engineering.
Installation guide:
11. Zulu - Java
What it is:
A certified build of the OpenJDK (Java Development Kit).
Business justification:
Required for running Java-based applications and tools, ensuring compatibility and security.
Installation guide:
12. DuckDB
What it is:
An in-process SQL OLAP database management system.
Business justification:
Ideal for fast, analytical data processing on local files, supporting data science and analytics workflows.
Installation guide:
General Business Justification
Installing these tools on a VM provides a standardized, secure, and controlled environment for development, testing, data analysis, and cloud management. This setup supports productivity, collaboration, and compliance with IT policies.
Once the VM request is done then we need to raise the request for SQO account.
3. Entra ID Creation - SQ account for Azure access
And click on request now
Entra ID Tenant Name - syensqosa.onmicrosoft.com (syensqo.com Prod)
Action - Creation
Employee Type - Employee/Contractor
Account Validity - Other
Specify Date - next year date
Business Justification - Joining Data Team and going to work on Azure Data Platform. She e would need his SQO account created and also to the Sysight project resources on azure.
Once SQO account is created, please try accessing Azure portal - : portal.azure.com and app.fabric.microsoft.com using SQ account. It might ask to reset the password, please do so.
4. Adding to groups :
EntraID -Technical -> Configuration -> Groups management
GSA_ADMIN_SUB-OTH - SySight - 00-APP-DEVTEAM
GSA_ADMIN_SUB-OTH - SySight - 00-Reader
5. Jira Access
KB - https://syensqo-dwp.onbmc.com/dwp/app/#/knowledge/KBA00015401/rkm
Link - https://syensqo-dwp.onbmc.com/dwp/app/#/itemprofile/1220
New page will appear , fill in all details
Type of Request - User Creation
Business Justification - Joining the Data Team and going to work on Azure Data Platform. Hence require Jira access to access board to create and update task Additional Information
Access Details
1.Why do you need access to Jira?
Answer: Project Management/Task creation and Updating
2. Which Jira product do you need access to?
Answer : Assign me the relevant licence which will fulfil my need.
3 .Access Level Requested:
Answer: Project Contributor
4.Business justification for access?
Answer: Working as a Data engineer in the team, he would need to see the Jira board and update, create and update the task.
5. Is this access temporary?
Answer: No
6. Do you require any special permissions (e.g., create projects, manage workflows)?
Answer: No Special Permission needed, Only I should be able to see and update the task/epic/user story.
Jira Portal Link : https://syensqo.atlassian.net/jira/for-you
Note : If you don't get invited then please follow up with the ticket owner.
6. GitLab
Follow the same process as Jira Request, Write GitLab instead of Jira
Please select the application - GitLab
Please select the application - Github & Github Copilot
Follow this document to raise the request - GitHub access process - Google Docs
If you face any challenges you can drop an email to Derek Yang (Github Service Owner) and Tanish bhola (Devops Engineer) to get this access.
You need access on your normal account to Github, not on SQO.
Once you are able to access the Github you would need access to the Repository for that you can connect to Shubham Gupta or Werner Dahn.
Link for Github : https://github.com/SQO-SySight
Important Links to refer
SYSight - https://wiki.syensqo.com/display/SYS/Data+Platform
SYGPT- https://sygpt.syensqo.com/#/chat/10d8cd13-0d71-419f-a436-56db5dbcf815
TheHub - https://thehub.syensqo.com/en?check_logged_in=1
Replicon - https://login.replicon.com/
WIki - https://wiki.syensqo.com/#all-updates
Jira : https://wiki.syensqo.com/display/AKC/Jira
https://wiki.syensqo.com/display/AKC/Jira+the+Basics
https://wiki.syensqo.com/display/AKC/Best+practices
Note : For any issues please reach out to DataEngineerAzure@syensqo.com.