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.
- BMC Helix Access Management
- Raise VM (VDI) request.
- Entra ID Creation - SQO account for Azure access
- Access to Jira
- Access to Github
- MS Software Installation on VDI
- BMC Helix Access Management - BMC Helix is a cloud based ITSM platform.
Link to raise the request -
- Once you click the link before page will appear
- Click on Request now - Below page will appear, fill the required fields and if you want to add the collaborator.
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.
- Employee - Directly raise VM request using below link https://syensqo-dwp.onbmc.com/dwp/rest/share/OJSXG33VOJRWKVDZOBST2U2CL5IFET2GJFGEKJTUMVXGC3TUJFSD2QKHI5AUISZQGNCDITBRJ5AVGN2JJ43VOUZXJFHTOV2BHBKVEJTSMVZW65LSMNSUSZB5GIYTGNRGMNXW45DFPB2FI6LQMU6UGQKUIFGE6R27JBHU2RI=
- Click on Request now
- Then fill in all the required details
- Type of VM – Persistent VM
- AD Account – Short Name
- Contact Email Address – Your Email ID
- Profile – Windows 11 Full Could Managed – SCO
- VM Type – Performance-ext VM (4vCPU, 16 GB RAM, 250 GB HDD)
- Type of Access – Select both Remote Access only, Local Administrator
- Required Software – Yes
- Application found in list – No
- Additional Information - Share the list of software that needs to be installed like below
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
- If you are Contractor - First raise TPA request, steps mention in the below link, Once this request will get approved by the sponsor of your contracting company you will be allowed to connect to the VDI You can find your company name and sponsor in this file- SCO TPA COMPANIES V2.xlsx - Google Sheets. If your company name is not present you need to get that added into the list. You can connect to tpa.operations@syensqo.com and keep Anup Mule in CC for any issues related to VDI. They will guide you with the next steps.
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:
- 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
- Azure CLI
- SSMS
- WinSCP / Putty
- One Lake Explorer
- Zulu - Java
- Duckdb
Download link : Software
- Python 3.11 (native, not via MS Store):
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:
- Download the Python installer from the provided drive link.
- Run the installer. During installation, select “Add Python to PATH.”
- After installation, open Command Prompt and run python --version to verify.
- If needed, manually add the Python installation directory to the PATH system.
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:
- Download the VSCode installer from the provided drive link.
- Run the installer and complete the setup.
- Launch VSCode to verify installation.
- Install required extensions from the Extensions Marketplace within VSCode.
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:
- Download the Git installer from the provided drive link.
- Run the installer and follow the setup instructions.
- Open Command Prompt and run git --version to verify installation.
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:
- Download the installer from the provided drive link.
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:
- Download the installer from the provided drive link.
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:
- Download the installer from the provided drive link.
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:
- Download the installer from the provided drive link and add path
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:
- Download the installer from the provided drive link.
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:
- Download the installer from the provided drive link.
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:
- Download the installer from the provided drive link.
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:
- Download the Zulu Java installer from the provided drive link.
- Run the installer and complete the setup.
- Set the JAVA_HOME environment variable and add the Java bin directory to the system PATH if required.
- Open Command Prompt and run java -version to verify installation.
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:
- Download the DuckDB installer or package from the provided drive link.
- Run the installer or set up the package as required.
- Verify installation by launching DuckDB or running a test query.
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
- Click on Request now
New page will appear , fill in all details
Type of Request - User Creation
- Please select the application - Jira
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.