Benefits Of Cloud Computing

You’re probably using cloud computing services right now, even if you don’t realize it. If you use an online service to send email, edit documents, watch movies or TV, listen to music, play games, or store pictures and other files, it’s likely that cloud computing is making it all possible behind the scenes.

Cloud computing is a significant shift from the traditional way businesses think about information technology (IT) resources.

Following are some reasons why you should turn to cloud computing services:

  • Cost
  • Global
  • Performance
  • Security
  • Scalable, elastic, and flexible
  • Productivity
  • Reliability

Cost

Cloud computing eliminates the capital expense of buying hardware and software. You no longer need to set up and run on-site datacenters with racks of servers. You no longer need round-the-clock electricity for power and cooling, or the IT experts for managing the infrastructure. The cost adds up fast.

This consumption-based model brings with it many benefits, including:

  • No upfront infrastructure costs.
  • No need to purchase, manage, and maintain costly infrastructure that you may not use to its fullest.
  • Pay for additional resources only when they’re needed.
  • Stop paying for resources that are no longer needed.

Global

The benefits of cloud computing services include the ability to scale elastically. In cloud terms, that means delivering the right amount of IT resources—more or less computing power, storage, or bandwidth—right when they’re needed, and from the right geographic location.

Performance

The biggest cloud computing services run on a worldwide network of secure datacenters. The providers regularly upgrade to the latest generation of fast and efficient computing hardware. This configuration offers several benefits over a single corporate datacenter, including reduced network latency for applications and greater economies of scale.

Security

Many cloud providers offer a broad set of policies, technologies, and controls that strengthen your security posture overall. They protect your data, apps, and infrastructure from potential threats.

You have physical security—who can access the building, who can operate the server racks, and so on. You also have digital security—who can connect to your systems and data over the network.

Scalable, elastic, and flexible

Cloud providers offer cloud computing services self-service and on demand. You can provision vast amounts of computing resources in minutes, typically with just a few mouse clicks. Cloud computing gives your business flexibility and takes the pressure off capacity planning.

Cloud computing supports both vertical and horizontal scaling, depending on your needs:

  • Vertical scaling, also known as scaling up, is the process of adding resources to increase the power of an existing server. Some examples of vertical scaling include adding more CPUs and adding more memory to support increased data collection.
  • Horizontal scaling, also known as scaling out, is the process of adding more servers that function together as one unit. For example, you have more than one server processing incoming requests.

Scaling can be done manually or automatically based on specific triggers, such as CPU use or the number of requests and resources that can be allocated or de-allocated in minutes.

Productivity

On-site datacenters often require a racking and stacking hardware setup, software patching, and other time-consuming IT management chores. Cloud computing removes the need for many of these tasks. Your IT teams can spend time on achieving more important business goals.

Reliability

Cloud computing makes data backup, disaster recovery, and business continuity easier and less expensive because data can be mirrored at multiple redundant sites on the cloud provider’s network.

Source :

https://docs.microsoft.com/en-us/learn/modules/principles-cloud-computing-dynamics-365-deployment/4-benefits-cloud-computing

How to make Absence Attendance mobile apps with feature GPS location in 2 days – Power Apps

There are 2 version languages available for this article.

Indonesia Version :

Ignite 2021 ini, saya tertarik dengan salah satu presentasi dan demo mengenai Power Apps.

Demo dari perusahaan itu dan ide mereka dimana membuat aplikasi-aplikasi kecil dalam membantu digitilasi dan automisasi perusahaan. Pada saat itu mereka juga menjelaskan berapa antusiasnya para user-user mereka menggunakan aplikasi itu dan mulai mengembangkan aplikasi-aplikasi lainnya untuk kebutuhan lainnya.

Dari situ saya berpikir, wah saya juga ingin mencoba membuatnya dan berpikir bahwa aplikasi yang cepat siap saji, cepat dalam development dan implementasi itu akan mempercepat produktifitas perusahaan itu sendiri.

Kebetulan saya juga akan membawakan webinar untuk tanggal 25 Maret 2021 mengenai “Leverage your Work from Home Level Now” maka mencoba membuatkan aplikasi menggunakan Power Apps tersebut, dengan data berita perusahan saya ambil dari internal Sharepoint Online dan penyimpanan data absen itu menggunakan excel file yang di taruh di onedrive microsoft office 365.

Berikut requirementnya:

Sebagai HRD dan Company

  • Applikasi yang mudah dibuat, tidak perlu ribet development dan implementasi
  • Dapat dengan mudah melakukan rekap Absen karena menggunakan Excel File
  • Bisa sharing kegiatan-kegiatan perusahan yang bisa dibaca oleh Karyawan
  • Aman, hanya bisa diakses oleh karyawan
  • Dapat memberikan Posisi (GPS) dimana karyawan berada. Itu dapat membantu bila ada informasi terkait Covid 19 di wilayah tersebut

Sebagi User / Employee

  • Dapat diakses mudah dan aman
  • UI yang simple dan informatif
  • Karyawan bisa mudah melihat history absen yang sudah di submit.
  • Karyawan bisa mengetahui berita seputar perusahaan.

Okay 🙂 Setelah requirement diatas maka mari kita persiapkan dan buat aplikasinya :

  1. Siapkan data source Events untuk berita-berita perusahan. Disini kita cukup menggunakan list dengan tipe calendar

2. Siapkan data source Excel, yang nantinya data absen akan disimpan kesana

Sheet1

Sheet 2, master data pada drop down menu nantinya.

3. Mari buat dengan Power Apps setelah point 1 dan 2 diatas sudah kita siapkan

Total screen yang akan kita buat adalah 6 (enam), yaitu :

  • Home Screen

Submit Attendance Click ini akan Navigate(EditAttendanceScreen,ScreenTransition.None)

My Attendance List ini akan Navigate(MyAttendanceScreen, ScreenTransition.Fade)

Company News ini akan Navigate(NewsListScreen, ScreenTransition.Fade)

  • NewsListScreen

  • MyAttendanceScreen
  • DetailAttendanceScreen
  • EditAttendanceScreen

Power Apps form sudah selesai, maka siap di publish dan share ke user-user yang di organisasi anda yang akan menggunakan aplikasi ini.

—————————————

English Version :

Past month ago, there was a Microsoft Event Ignite 2021. I was interested with one presentation and demo about the Power Apps.

That demo was about from one of company at Indonesia. They are have briliant idea to build small and simple application – application for their company to help the compay on digitalisation and automitation process. At that presentation, the speaker was also explained how enthusiastic their employee to use the application and began to develop other applications for other needed.

After that presentation i was thought, wow i am also want to try to build the application like that. The application with fast to serve, fast in to development and also implementation it will accelarate the productivity of the company itself.

25 March 2021, i am also have a webinar with title “Leverage your Work from Home Level Now” and i am also as speaker there. For that event, i tried to make an application on top Power Apps. With company news data that I take from internal Sharepoint Online and store the absent data using excel file that is placed on OneDrive Microsoft Office 365.

Here are the requirement detail as follow :

As Human Resources Department and Company

  • The application has to be simple. Easy to development and Implementation
  • Easy to do absense recap, because it using Excel Files.
  • Able to share company events to employee
  • Safe and Secure and only able to access by its employee.
  • Can provide Position (GPS) where employees are located. That can help if there is information related to Covid 19 in the area

As Employee

  • Application it is easy to used and secure
  • User Interface simpel and informatif
  • Employee with ease to see their absence history was submitted
  • Employee can read information about event around company.

Okay 🙂 Regarding the requirement above then we can prepare and start to build the application :

  1. Prepare the Events data source for company news. Here we just need to use a list with a calendar type

2. Prepare the Excel data source, which later the timesheet will be saved there

Sheet 1

Sheet 2

3. Let’s cook it after point 1 and 2 above we have prepared

The total screen that we will create is 6 (six), namely:

  • EditAttendanceScreen

All complete, so it’s ready to publish and share with users in your organization who will use this application.

Happy Sharepoint-ing

MySQL InnoDB Cluster on Ubuntu 20.04 – Infinys Cloud

A few weeks ago, there was request from the our client for about how to implement MySQL InnoDB Cluster on their Virtual Machines at our cloud server Infinys Cloud. For fulfill that POC (purpose of concept), we are prepare some server and the step installation like as below :

ServerIPSoftwareRole
APP Server + MySQL Router117.xxx.xxx.1MySQL RouterClient / APP Server
MYSQL-CL-01117.xxx.xxx.2MySQL Server, MySQL ShellPrimary/Master DB Server
MySQL-CL-02117.xxx.xxx.3MySQL Server, MySQL ShellRead Only DB Server 1
MySQL-CL-03117.xxx.xxx.4MySQL Server, MySQL ShellRead Only DB Server 2

A. Setting up MySQL Innodb Cluster

The Innodb Cluster settings below are carried out on 3 machines, namely MYSQL-CL-01, MySQL-CL-02, and MySQL-CL-03

The steps are as follows:

  1. Update Host
  • Run sudo nano /etc/hosts

Register MYSQL-CL-01, MySQL-CL-02, and MySQL-CL-03 with the IP that has been registered above. For example one of the computer names uses the IP 127.0.0.1 then it must be replaced with the IP of the server instead of 127.0.0.1

2. Install MySQL Server Engine

  • Run sudo apt update
  • Run sudo apt-get install mysql-server
  • sudo systemctl status mysql.
  • Run sudo mysql_secure_installation . Run this and follow all the steps.

After all the steps are done, it means that the MySQL Server installation stage is complete.

3. Create User untuk dipakai di Replikasi System

  • Run, sudo mysql -u root p
  • Execute Query : Select user,host.plugin from mysql.user;
mysql> Select user, host, plugin 
user 
debi an— sys —maint 
mysql . infoschema 
from mysql . user; 
mysql . session 
host 
local host 
local host 
local host 
local host 
local host 
plugin 
caching 
caching 
caching 
caching 
sha2 
sha2 
sha2 
sha2 
password 
password 
password 
pa s s word 
mysql . sys 
100 t 
rows in sec 
auth socket 
(0.00 sec)
  • CREATE USER ‘usr_replication’@’%’ IDENTIFIED WITH mysql_native_password BY ‘XXXXXXX’;

XXXXXXX = Password.

  • GRANT ALL PRIVILEGES ON *.* To ‘usr_replication’ with GRANT OPTION;
  • Flush Privilges;
  • Execute Query : Select user,host.plugin from mysql.user;

4. Install MySQL Shell

  • Run sudo apt-install snapd
  • Run snap install mysql-shell
  • Run sudo apt-get update

B. Configure Group Replication

  1. Create Instance MYSQL-CL-01
  • Login to server MYSQL-CL-01
  • Run mysqlsh MYSQL-CL-01 -u – usr_replication and type the password
  • Run Dba.help (); To see all commands that provided.
ACC IibuCeEIIOI: unkncwn attribute: 
dba . help ( ) 
che ckIns C anceConfi guy a C i on 
dba 
InnoDB cluster and 
repli caseC management functions . 
DESCRIPTION 
Entry point for AdminAPI 
sets. 
InnoDB clusters 
fun cc ions , 
including InnoDB clusters 
and 
repl i ca 
The dba. configure instance function can be used Co configure a MySQL 
instance with the settings required Co use iC in an InnoDB cluster. 
InnoDB clusters can be created with Che 
Once created, InnoDB cluster management 
dba. get cluster() function. 
InnoDB Repli case Cs 
dba. create cluster() function. 
objects can be obtained with Che 
The dba. configure replica sec instance function can be used Co 
configure a MySQL instance with the 
replicaset . 
ReplicaSeCs can be created with Che 
Once created, repli caseC management 
settings required Co use iC in a 
dba. create replica sec() function. 
objects can be obtained with Che 
dba. get replica set O 
S andboxe s 
Utility functions are 
can be used to create 
PROPERTIES 
verb3se 
function . 
provided Co create sandb3X MySQL 
Cest clusters and replicasets . 
instances , 
whi ch 
Cont s debug me s sage 
operations . 
FUNCTIONS 
ve rbos i C y 
for 
s andbox 
re laced dba 
check instance configuration (instance [ , 
options ) 
Validates an instance for MySQL InnoDB Cluster usage . 
configure instance ( [instance] [ , options] ) 
Validates 
usage . 
configure local 
Validates 
usage . 
and configures an instance for MySQL InnoDB Cluster 
instance (instance [ , options] ) 
and configures a local instance for MySQL 
options ) 
for use in an 
InnoDB Cluster 
InnoDB 
configure replica sec instance ( [instance] [ , 
Validates and configures an instance 
ReplicaSet . 
create cluster (name [ , options] ) 
Creates a MySQL InnoDB cluster .
  • Run, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.2’) and type the password
  • Instance server MYSQL-CL-01 completed.

2. Create Instance MYSQL-CL-02

  • Login ke server MYSQL-CL-02
  • Run mysqlsh -u – usr_replication and type in the password.
  • run, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.3’) type in the password
  • Instance server MYSQL-CL-02 completed.

3. Create Instance MYSQL-CL-03

  • Login ke server MYSQL-CL-03
  • Run mysqlsh -u – usr_replication and type in the password.
  • run, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.4’) type in the password
  • Instance server MYSQL-CL-02 completed.

4.Create New Cluster and Register Instance to that new Cluster

  • Login ke server MYSQL-CL-01
  • run mysqlsh -u – usr_replication dan masukkan password
  • Run this to create New Cluster : cluster=dba.createCluster(‘clusterName’) ->In this test i use the name ProdCluster
  • cluster.addInstance(‘usr_replication@@117.xxx.xxx.3’)
  • cluster.addInstance(‘usr_replication@@117.xxx.xxx.4’)
  • After all servers have been registered into the cluster, we can find out their status by running dba.status ();

C. Install MySQL Router

MySQL Router recommend to be installed on same server with the application used. So it means that MySQL Router can be installed on more than one server.

  1. MySQL Router Install
  • Run, sudo apt-get mysql-router
  • Run, mysqlrouter –user root –bootstrap usr_replication@MYSQL-CL-01  –directory /tmp/myrouter

2.Verifiying the MySQL Router Works

  • Run mysql -uroot -p -P 6446
  • If you can connect to the database, it means that our MySQL Router installation has been successful


Indonesia Version

Beberapa minggu yang lalu, ada permintaan dari klien kami tentang cara mengimplementasikan MySQL InnoDB Cluster pada Mesin Virtual mereka di server cloud kami Infinys Cloud. Untuk memenuhi POC (tujuan konsep) tersebut, kami menyiapkan beberapa server seperti pada tabel di bawah ini:

ServerIPSoftwareRole
APP Server + MySQL Router117.xxx.xxx.1MySQL RouterClient / APP Server
MYSQL-CL-01117.xxx.xxx.2MySQL Server, MySQL ShellPrimary/Master DB Server
MySQL-CL-02117.xxx.xxx.3MySQL Server, MySQL ShellRead Only DB Server 1
MySQL-CL-03117.xxx.xxx.4MySQL Server, MySQL ShellRead Only DB Server 2

A. Setting up MySQL Innodb Cluster

Setting Innodb Cluster dibawah ini, dilakukan di 3 mesin yaitu MYSQL-CL-01, MySQL-CL-02, dan MySQL-CL-03

Langkah-langkah sebagai berikut :

  1. Update Host
  • Jalankan sudo nano /etc/hosts

Daftarkan MYSQL-CL-01, MySQL-CL-02, dan MySQL-CL-03 dengan IP yang sudah di daftarkan diatas. Bila misalnya salah satu nama komputer itu menggunakan IP 127.0.0.1 maka harus di ganti dengan IP dari server tersebut bukan 127.0.0.1

2. Install MySQL Server Engine

  • Jalankan sudo apt update
  • Jalankan sudo apt-get install mysql-server
  • sudo systemctl status mysql. Untuk mengetahui bahwa installasi sudah berhasil dan mysql harus dalam keadaan active (running)
  • Jalankan sudo mysql_secure_installation . Untuk setup root dan beberapa permission MySQL server lainnya.

Setelah semua langkah dilakukan, artinya tahapan Instalasi MySQL Server sudah selesai.

3. Create User untuk dipakai di Replikasi System

  • Jalankan, sudo mysql -u root p
  • Eksekusi Query : Select user,host.plugin from mysql.user;
mysql> Select user, host, plugin 
user 
debi an— sys —maint 
mysql . infoschema 
from mysql . user; 
mysql . session 
host 
local host 
local host 
local host 
local host 
local host 
plugin 
caching 
caching 
caching 
caching 
sha2 
sha2 
sha2 
sha2 
password 
password 
password 
pa s s word 
mysql . sys 
100 t 
rows in sec 
auth socket 
(0.00 sec)
  • CREATE USER ‘usr_replication’@’%’ IDENTIFIED WITH mysql_native_password BY ‘XXXXXXX’;

XXXXXXX = Password.

  • GRANT ALL PRIVILEGES ON *.* To ‘usr_replication’ with GRANT OPTION;
  • Flush Privilges;
  • Eksekusi Query : Select user,host.plugin from mysql.user;

4. Install MySQL Shell

  • Jalankan sudo apt-install snapd
  • snap install mysql-shell
  • sudo apt-get update

B. Configure Group Replication

  1. Create Instance MYSQL-CL-01
  • Login ke server MYSQL-CL-01
  • Jalankan mysqlsh MYSQL-CL-01 -u – usr_replication dan masukkan password
  • Jalankan Dba.help (); Untuk melihat perintah apa yang bisa kita lakukan.
ACC IibuCeEIIOI: unkncwn attribute: 
dba . help ( ) 
che ckIns C anceConfi guy a C i on 
dba 
InnoDB cluster and 
repli caseC management functions . 
DESCRIPTION 
Entry point for AdminAPI 
sets. 
InnoDB clusters 
fun cc ions , 
including InnoDB clusters 
and 
repl i ca 
The dba. configure instance function can be used Co configure a MySQL 
instance with the settings required Co use iC in an InnoDB cluster. 
InnoDB clusters can be created with Che 
Once created, InnoDB cluster management 
dba. get cluster() function. 
InnoDB Repli case Cs 
dba. create cluster() function. 
objects can be obtained with Che 
The dba. configure replica sec instance function can be used Co 
configure a MySQL instance with the 
replicaset . 
ReplicaSeCs can be created with Che 
Once created, repli caseC management 
settings required Co use iC in a 
dba. create replica sec() function. 
objects can be obtained with Che 
dba. get replica set O 
S andboxe s 
Utility functions are 
can be used to create 
PROPERTIES 
verb3se 
function . 
provided Co create sandb3X MySQL 
Cest clusters and replicasets . 
instances , 
whi ch 
Cont s debug me s sage 
operations . 
FUNCTIONS 
ve rbos i C y 
for 
s andbox 
re laced dba 
check instance configuration (instance [ , 
options ) 
Validates an instance for MySQL InnoDB Cluster usage . 
configure instance ( [instance] [ , options] ) 
Validates 
usage . 
configure local 
Validates 
usage . 
and configures an instance for MySQL InnoDB Cluster 
instance (instance [ , options] ) 
and configures a local instance for MySQL 
options ) 
for use in an 
InnoDB Cluster 
InnoDB 
configure replica sec instance ( [instance] [ , 
Validates and configures an instance 
ReplicaSet . 
create cluster (name [ , options] ) 
Creates a MySQL InnoDB cluster .
  • Jalankan, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.2’) dan masukkan password
  • Instance server MYSQL-CL-01 selesai.

2. Create Instance MYSQL-CL-02

  • Login ke server MYSQL-CL-02
  • Jalankan mysqlsh -u – usr_replication dan masukkan password
  • Jalankan, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.3’) dan masukkan password
  • Instance server MYSQL-CL-02 selesai.

3. Create Instance MYSQL-CL-03

  • Login ke server MYSQL-CL-03
  • Jalankan mysqlsh -u – usr_replication dan masukkan password
  • Jalankan, dba.configure_local_instance(‘usr_replication@117.xxx.xxx.4’) dan masukkan password
  • Instance server MYSQL-CL-03 selesai.

4.Create New Cluster and Register Instance to that new Cluster

  • Login ke server MYSQL-CL-01
  • Jalankan mysqlsh MYSQL-CL-01 -u – usr_replication dan masukkan password
  • Jalankan cluster=dba.createCluster(‘clusterName’) -> didalam test ini saya menggunakan nama ProdCluster
  • cluster.addInstance(‘usr_replication@@117.xxx.xxx.3’)
  • cluster.addInstance(‘usr_replication@@117.xxx.xxx.4’)
  • Setelah semua server sudah di daftarkan kedalam Cluster tersebut, maka kita bisa mengetahu statusnya dengan menjalankan dba.status();

C. Install MySQL Router

MySQL Router sebaiknya di install satu server dengan aplikasi yang digunakan. Jadi MySQL Router bisa diinstall lebih dari satu server.

  1. MySQL Router Install
  • Jalankan , sudo apt-get mysql-router
  • Jalankan, mysqlrouter –user root –bootstrap usr_replication@MYSQL-CL-01  –directory /tmp/myrouter

2.Verifiying the MySQL Router Works

  • Login dengan mysql -uroot -p -P 6446
  • Bila bisa connect artinya instalasi MySQL Router sudah berhasil/.

Other References :

The Lord’s Prayer

Father in Heaven
Holy is Your Name
Your kingdom come
Your will be done on earth
As it is in Heaven
Our Father in Heaven
Lead us not into temptation
God deliver us from the enemyYours is the kingdom
And the power
And the glory
ForeverGive us each moment
All that we need
Forgive us our sins
As we forgive the ones
Who have sinned against us
Our Father in HeavenLead us not into temptation
God deliver us from the enemyYours is the kingdom
And the power
And the glory
ForeverYours is the kingdom
And the power
And the glory
ForeverOur Father have Your way
On the earth
Your will be doneOur Father have Your way
On the earth
Your will be doneOur Father have Your way
On the earth
Your will be doneOur Father have Your way
On the earth
Your will be doneYours is the kingdom
And the power
And the glory
ForeverYours is the kingdom
And the power
And the glory
ForeverYours is the kingdom
And the power
And the glory
ForeverYours is the kingdom
And the power
And the glory
ForeverYours is the kingdom
And the power
And the glory
Forever
And ever more
Amen

By Hilsong

Setup Power Apps Integration with Sharepoint Server On-Premise (Infopath replacement)

InfoPath as we know it will no longer be used in next version of Sharepoint Server. In fact, since several years ago, Microsoft has announced this. But until now in version of Sharepoint 2019, Infopath service is still remain but with no longer any improvement features at all in Infopath.

Infopath itself is one of the best tools from Microsoft Sharepoint that has long been used by Sharepoint Developers to be able to make applications easier, faster and very user friendly in an interface.

Now Microsoft offers a new Technology that is Power Apps. Similar with Infopath, Power Apps also help users to design their application easily, quickly and user friendly. But it is not limited to Sharepoint or SQL Server data sources only, but can access other data sources as well like One Drive, Google Drive, Drop Box, and many more

Power Apps is a Cloud Centrix Application, where the application is in Microsoft Cloud, and until this article was published Power Apps cannot be installed on On Premises Environment.

Powers Apps can also intergrated with our Microsoft Sharepoint On Premises atau SQL Server On Premises.

Here are the steps for integrating Microsoft Sharepoint 2019 On Premise with Power Apps.

  1. Register an Power Apps account at https://make.powerapps.com
  2. Download Power Apps Studio and Power Apps On-Premises Data gateway
This image has an empty alt attribute; its file name is image-4.png

3. Install On-Premises Data Gateway on our Server Sharepoint 2019 On Premise

The steps are as follows:

  • Type your email addrress that you was registered at Power Apps portal.
  • Register a new gateway on this computer
  • Type Gateway Name, and Recovery Key
  • The gateway result configration we can see on Power Apps Portal.

3. Create a new SharePoint Connector and Connect to Gateway that we have been created.

  • Choose Connect Using on-premises data gateway dan type Username and Password is needed,
x 
SharePoint 
Microsoft 
SharePoint helps organizations share and collaborate with colleagues, partners, 
and customers. You can connect to SharePoint Online or to an on-premises 
SharePoint 2013 or 2016 farm using the On-Premises Data Gateway to manage 
documents and list items. 
How do you want to connect to your data? 
C) Connect directly (cloud-services) 
@Connect using on-premises data gateway O 
Authentication Type 
Windows 
Username 
Cancel 
Create
SharePoint 
Microsoft 
Windows 
Username 
Password * 
Choose a gateway 
Agusto 
If you don't see a gateway, or want a new one, you can install one 
*hic lic. 
Cancel 
x 
CD

4. Installation are done!!! 🙂 yippe. Now we able to use it on Power Apps to create our application

In Indonesia Version

InfoPath seperti yang kita ketahui tidak akan digunakan lagi di versi Sharepoint Server berikutnya.

Padahal, sejak beberapa tahun lalu, Microsoft sudah menyinggung hal ini. Namun hingga saat ini di versi Sharepoint 2019, layanan Infopath masih tetap ada namun tidak ada lagi peningkatan/pembaharuan fitur sama sekali di Infopath.

Infopath itu sendiri adalah salah satu tools terbaik dari Microsoft Sharepoint yang sudah lama dipakai oleh para Developer Sharepoint untuk bisa membuat aplikasi lebih mudah, cepat dan sangat user friendly secara interface.

Sekarang Microsoft menawarkan technology baru yaitu Power Apps. Sama dengan Infopath, Power Apps juga membantu user untuk mendesign aplikasi mereka dengan mudah, cepat dan user friendly. Tetapi tidak dibatasi hanya dengan data sources Sharepoint atau SQL Server saja, tetapi bisa mengakses datasource lainnya seperti One Drive, Google Drive, Drop Box, dll.

Power Apps ini juga adalah bagian dari Power Platform yang pernah saya jelaskan di article saya sebelumnya https://agustox21.wordpress.com/2021/01/20/microsoft-power-platform

Power Apps ini adalah aplikasi Cloud Centrix, dimana aplikasi ada di Microsoft Cloud dan sampai saat artikel ini dibuat Power Apps tidak bisa diinstall di On Premise Environment.

Power Apps juga bisa diintergrasikan dengan Microsoft Sharepoint 2019 On Premise atau SQL Server On Premise kita.

Berikut adalah langkah-langkah mengintergrasikan Microsoft Sharepoint 2019 On Premise dengan Power Apps.

  1. Membuat Akun Power Apps di https://make.powerapps.com/
  2. Download Power Apps Studio dan Power Apps On-Premises Data gateway

3. Install On-Premises Data Gateway di Server Mesin Sharepoint 2019 On Premise

Langkah-langkah sebagai berikut :

  • Masukkan alamat email Akun Power Apps / Azure yang ada
  • Register a new gateway on this computer
  • Masukkan Gateway Name, dan Key
  • Hasil gateway tersebut bisa kita lihat di Power Apps Portal

3. Buat Connector SharePoint dan Connect ke Gateway yang sudah kita buat

  • Plih Connect Using on-premises data gateway dan masukkan Username dan Password yang dibutuhkan
x 
SharePoint 
Microsoft 
SharePoint helps organizations share and collaborate with colleagues, partners, 
and customers. You can connect to SharePoint Online or to an on-premises 
SharePoint 2013 or 2016 farm using the On-Premises Data Gateway to manage 
documents and list items. 
How do you want to connect to your data? 
C) Connect directly (cloud-services) 
@Connect using on-premises data gateway O 
Authentication Type 
Windows 
Username 
Cancel 
Create
SharePoint 
Microsoft 
Windows 
Username 
Password * 
Choose a gateway 
Agusto 
If you don't see a gateway, or want a new one, you can install one 
*hic lic. 
Cancel 
x 
CD

4. Installasi sudah selesai dan kita sudah bisa menggunkan Power Apps untuk aplikasi yang kita inginkan.

Happy Sharepoint-Ing

How to enabled ICMP (Ping) on Azure VM

Azure by default denies and blocks all public inbound traffic to an Azure virtual machine, and also includes ICMP traffic. This is a good thing since it improves security by reducing the attack surface.

If we still need to enable the ICMP (ping) on your Azure VM, here are the step as below :

  1. Login to your portal Azure site (https://portal.azure.com)
  2. Configure Network Security Group (NSG) to allow ICMP traffic
    • Click on add a new inbound port rule for the Azure network security group (NSG).
    • Change the protocol to ICMP
    • Set Priority, and Set Name for this rule
    • Click Add to add this rule.

In here, you already successfully allowed on basic azure firewall to able accept Protocol ICMP

3. Enable Firewall on VM to answer to Ping/ICMP echo request

This screenshot below is VM using Windows Server OS. If you are using VM with linux, we need also need allow that protocol.


—————————————————————————————————————————————————

Indonesia Version :

Azure secara default menolak dan memblokir semua lalu lintas masuk publik ke mesin virtual Azure, dan juga termasuk lalu lintas ICMP. Ini adalah hal yang baik karena meningkatkan keamanan dengan memngurangi sedikit serangan terhadap VM mesin yang kita miliki.

Jika kami masih perlu mengaktifkan ICMP (ping) pada Azure VM Anda, berikut adalah langkah-langkahnya seperti di bawah ini:

  1. Login ke Portal Azure Site (https://portal.azure.com)
  2. Konfigurasikan Grup Keamanan Jaringan (NSG) untuk mengizinkan ICMP Protocol
    • Klik tombol “add a new inbound port rule” to membuat rule baru di Azure network security group (NSG).
    • Ganti pilihan protocol to ICMP
    • Masukkan Nilai Prioritas dan Nama dari rule yang kita akan buat ini
    • Klik tombol Add untuk menambahkan rule.

Di sini, Anda sudah berhasil mengizinkan firewall azure untuk dapat untuk dapat menerima Protokol ICMP

3. Aktifkan Firewall di VM untuk menjawab permintaan Ping / ICMP

Gambar dibawah ini menggunakan WIndow Server sebagai OS-nya, untuk OS Linux juga sama kita perlu mengizinkan protokol ICMP juga.

This image has an empty alt attribute; its file name is image-3.png

Microsoft Power Platform

What is Power Platform actually ?

Power Platform is a low code platform offering provided from Microsoft which spans Office 365, Azure, Dynamics 365 and standalone applications.

So if you see the text above about low code, then that means a lot of features are offered on this Power Platform and we don’t have to struggle with code like regular custom code and of course it’s fast to build, deploy and also delivery to our end user / customer. That is seem promising right ? hehehe 🙂

Currently Power Platform is comprised of 4 (four) key products and we can see on this diagram as below :

The 4 (Four) key products are :

  1. Power Apps
    Focusing on provides a rapid low code development for building apps for business needs. If you have an experience with Infopath on Sharepoint Platform before. Power Apps also give us the easiest development like Infopath dan simple interface so that very busines user / pro developer can build custom apps.
    Power Apps also have a lot connector to many source, so it will bring a lot of idea to build a application on top of that.
  2. Power Automate
    If Power Apps focus on Apps or front end area, so Power Automate it will more focus on the back end automation like Workflow beetween application and services. It helps automate repetitive business processes such as communication, data collections, and decision approvals.
    Same like Power Apps, Power Automate provides have a lot connector to many source, so it will bring a lot thing to us to create connection to all environtment that we had.
  3. Power BI (Business Intelligence)
    is a business analytics service that delivers insights for analyzing data. It can share those insights through data visualizations which make up reports and dashboards to enable fast, informed decisions. Power BI scales across an organization, and it has built-in governance and security allowing businesses to focus on using data more than managing it.
  4. Power Virtual Agents
    Enables anyone to create powerful chatbots using a guided, no-code graphical interface, without the need for data scientists or developers. Power Virtual Agents enables anyone to create powerful chatbots using a guided, no-code graphical interface, without the need for data scientists or developers

Among the programs listed above, there are cross cutting features which enable the Power Platform to be leveraged to its full potential. Some of these are:

  1. Connector
    There are more than 275 connectors for the Power Platform, enabling all of your data and actions to connect cohesively. Examples of popular connectors include Salesforce, Office 365, Twitter, Dropbox, Google services,we also can connect to our API that we can call it as custom connector, and more.
  2. Common Data Service (CDS) that now renamed as Microsoft Dataverse
    is a scalable data service and app platform which lets users securely store and manage data from multiple sources and integrate that data in business applications using a common data model to ensure ease and consistency to users
  3. AI Builder
    Allows us easily add intelligence to your workflows and apps and predict outcomes to help improve business performance without writing code

Before this article, i did some articles already posted about features of Power Platform. Here a below the links and hope can bring you the idea what you can gonna do this for your customers / your end users.

https://agustox21.wordpress.com/2020/06/01/room-booking-reservation-integration-with-sharepoint-365-power-apps-power-automate-and-ics-file/

https://agustox21.wordpress.com/2020/07/07/how-to-get-count-length-on-filter-array-function-when-query-into-sharepoint-list-items-using-ms-automate/

https://agustox21.wordpress.com/2020/07/07/how-to-get-count-length-on-filter-array-function-when-query-into-sharepoint-list-items-using-ms-automate/

Cannot Manage Desktop Server : XXX The server must be added to the server pool.

This afternoon, I got a message from a client that we preinstalled their server with the Remote Desktop Server feature or we can call it RDS.

All the service running well both on the RDS Gateway server and RDS Licensing server. But when we go menu Server Manager on RDS Gateway > then Click Remote Desktop server. We found this error as below :

One of the servers is mentioned there (see on the text that i hide), and the server is asked to be added to the server pool.

To resolve I added the server back into the server pool with the following steps.

  1. Open Server Manager

On the Windows desktop, start Server Manager by clicking the Server Manager icon on the Windows taskbar.

2. Then on the Manage menu, click Add Servers.

3. Then do either of the following.

  • On the Active Directory tab, select servers that are in the current domain. Press Ctrl while selecting to select multiple servers. Click the right-arrow button to move selected servers to the Selected list.
  • On the DNS tab, enter the host name or IP address, and then press Enter or click Search. Select the servers that you want to add.

4. When you are finished adding servers, click OK

The terminal server has exceeded maximum number of allowed connection, mstsc

Problem

The user is attempting to log on to a Terminal Server in Remote Administration mode, but the server has reached its connection limit. Terminal Servers in Remote Administration mode allow a maximum of 2 concurrent sessions, active or disconnected

Solution

You can start a control session to the server and logoff your other connections. Please always use “LogOff” when you leave remote desktop.

  1. Open Command Prompt.
  2. Type: “mstsc /admin”.
  3. Remote Desktop Connection will start. Type the computer name or IP address of the computer you want to connect to in the Computer box.
  4. Configure any other desired options, and then click Connect.

Example

mstsc /v:IP_SERVER /admin /f