Using A Function App with a Dedicated Static IP

Using A Function App with a Dedicated Static IP

by | Jul 8, 2021 | Technology

This article is contributed. See the original author and article here.

function-app-vnet-integration-dmz-reference-architectures.png

Create an HTTP Trigger Function



  • Create an HTTP Trigger C# function with a name of your liking.

  • Use an App Service Hosting Plan SKU or Standard or Premium, both support VNET integration. You may use Standard plan for this set up, as it is cheaper.

  • Replace the out of the box code for the HTTP Trigger with the following code.




#r “Newtonsoft.Json”

#r “System.Text.Json”

using System.Net;

using Microsoft.AspNetCore.Mvc;

using Microsoft.Extensions.Primitives;

using Newtonsoft.Json;

using System.Collections.Generic;

using System.Net.Http;

using System.Net.Http.Headers;

using System.Text.Json;

using System.Threading.Tasks;

using System.Globalization;

using System.Text.Json.Serialization;

//using System.Exception;

public class Repository

{

[JsonPropertyName(“name”)]

public string Name { get; set; }

[JsonPropertyName(“description”)]

public string Description { get; set; }

[JsonPropertyName(“html_url”)]

public Uri GitHubHomeUrl { get; set; }

[JsonPropertyName(“homepage”)]

public Uri Homepage { get; set; }

[JsonPropertyName(“watchers”)]

public int Watchers { get; set; }

[JsonPropertyName(“pushed_at”)]

public string JsonDate { get; set; }

public DateTime LastPush =>

DateTime.ParseExact(JsonDate, “yyyy-MM-ddTHH:mm:ssZ”, CultureInfo.InvariantCulture);

}

public static async Task<IActionResult> Run(HttpRequest req, ILogger log)

{

log.LogInformation(“C# HTTP trigger function processed a request.”);

string name = req.Query[“name”];

string requestBody = await new StreamReader(req.Body).ReadToEndAsync();

dynamic data = JsonConvert.DeserializeObject(requestBody);

name = name ?? data?.name;

string responseMessage = string.IsNullOrEmpty(name)

? “This HTTP triggered function executed successfully. Pass a name in the query string or in the request body for a personalized response.”

: $“Hello, {name}. This HTTP triggered function executed successfully.”;

// Testing this…disregard for demo

// ReadTextFile();

log.LogInformation(“Performing ProcessRepositories code section…”);

var repositories = await ProcessRepositories();

foreach (var repo in repositories)

{

if (repo == null)

{

continue;

}

log.LogInformation($“Repo Name: {repo.Name}”);

log.LogInformation($“Repo Description: {repo.Description}”);

}

return new OkObjectResult(responseMessage);

}

// Ref URL: https://github.com/dotnet/samples/blob/master/csharp/getting–started/console–webapiclient/Program.cs

private static async Task<List<Repository>> ProcessRepositories()

{

var client = new HttpClient();

client.DefaultRequestHeaders.Accept.Clear();

client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue(“application/vnd.github.v3+json”) );

client.DefaultRequestHeaders.Add(“User-Agent”, “.NET Foundation Repository Reporter”);

var streamTask = client.GetStreamAsync(“https://api.github.com/orgs/dotnet/repos”);

var repositories = await System.Text.Json.JsonSerializer.DeserializeAsync<List<Repository>>(await streamTask);

return repositories;

}

// Ref URL – https://docs.microsoft.com/en–us/dotnet/csharp/programming–guide/file–system/how–to–read–from–a–text–file

private void ReadTextFile(ILogger log)

{

try

{

// Example #1

// Read the file as one string.

string text = System.IO.File.ReadAllText(@“10.10.2.5testtestfile.txt”);

// Display the file contents to the console. Variable text is a string.

log.LogInformation(“Contents of WriteText.txt = {0}”, text);

}

catch(Exception ex)

{

log.LogInformation(“Exception = {0}”, ex.Message);

}

}


Run the HTTP Trigger and see the Function run successfully


 


Configure Function’s Application Setting



  • Create a Config Variable WEBSITE_VNET_ROUTE_ALL in Application settings for the function and set the value to 1.


Set-website-vnet-route-all-to-1-function-app-configuration.png


 


Create a VNET and required subnets


VNET-with-AzureFirewallSubnet.png

Subnet-for-VNET-integration-resized.png

VNET-integrationsubnet-delegate-subnet-to-server-farmpng-resized.png


  • Ensure a subnet AzureFirewallSubnet is created, dedicated for the Azure Firewall.

  • In the subnet for VNET integration, set the Delegate subnet to a service to Microsoft.Web/serverFarms


Create Simple NSG



  • Create an out of the box NSG rule and associate that to the VNET Integration Subnet


InboundNSG-resized.png


OutboundNSG-resized.png


 


Create an Azure Firewall



  • Using the AzureFirewallSubnet subnet, create an Azure Firewall. Once provisioned, note down the Firewall private IP


Create-AzureFirewall-resized.png


  • Click on the public IP name listed under Firewall public IP and note down the Firewall public IP, in this case 52.252.28.12. The name is provided during Azure Firewall creation.


Azurefirewall-public-ip-configuration-resized.png


  • Click on Rules under Settings for the Firewall. Navigate to Application Rules and create an application rule collection as below. Note: to test the scenario, rule Action will be set to Deny or Allow.


Edit-Firewall-Rule-Deny-resized.png


  • Set the values as shown above

  • Set the target FQDN to api.github.com

  • Protocol:Port Https:443

  • Set the source to the CIDR of the subnet for VNET integration, this is the easiest way. Alternatively, you may set the source to the IP assigned by the VNET integration subnet to the function app. This can be done by enabling the logs and seeing the details for the logs for AzureFirewall, the assigned IP address is listed.


Create Route Table



Create-route-table-resized.png




  • Create a route such that the next hop is for the private IP of the virtual appliance, in this case the private IP of the Azure Firewall



Set-route-for-route-table-resized.png


Test the scenario





  • Set the application rule to Deny, and run the Azure Function. You will see the Function will respond with an error in the output window. This is because the Firewall is blocking the traffic via the outbound public static IP.




  • Now set the Application Rule in the Azurefirewall to Allow and run the Azure Function. The call is now successful, retrieving the GitHub repositories per the logic in the HTTP Trigger function, this is viewable in the output window.




  • The public static outbound IP address is Firewall public IP, in this case 52.252.28.12. This is the IP to be shared with the Vendors or 3rd Party Software providers such that it can be whitelisted and calls can be made to the function via this public static IP.



Take your security to the next level with professional security services

Take your security to the next level with professional security services

by | Jul 8, 2021 | Technology

This article is contributed. See the original author and article here.

Not every organization has the capacity nor the expertise to have a dedicated security operations team. Others may need a second set of eyes to review alerts in their network or simply want to ensure that they keep up with the latest techniques being used by adversaries. Some may want an additional assessment of their security posture or just need some evaluation of possible vulnerabilities in their network, while others need immediate help on ongoing breach.


Microsoft security services, together with a vast network of partners help address these challenges across global regions for public companies, private industries, and government entities to help protect against the most sophisticated adversaries. Joining forces with our extensive ecosystem of leading services partners that provide offerings such as managed threat hunting and managed detection and response, enables us to offer the best security solutions from Microsoft with the services your organization needs to secure your business.


To help you discover the range of security services offerings available to you, we’re excited to announce a new professional services catalog now available in Microsoft 365 Defender. At the moment, you can find it under Endpoints > Partners & APIs > Professional Services at security.microsoft.com. While it’s in the Endpoints section for the time being, you’ll find partners that support and build on many of our security products.


 


We’ve organized both first and third-party services along the following categories:



  • Educate and maintain your internal team’s security capabilities to prevent, detect, contain, and remediate threats.

  • Evolve your organization’s security posture through improved processes and technologies that modernize threat detection, containment, and remediation capabilities.

  • Protect your organization by proactively evaluate your organization’s ability to effectively prevent, detect, and respond to cyber threats before they disrupt your business.

  • Respond to security incidents quickly, effectively and at scale with complete incident response including investigation, containment, remediation, and crisis management.

  • Managed security services that assist organizations to detect threats early and help minimize the impact of a breach.


 


blogpic1.png


Figure 1: Image of Professional services catalog


 


Within each of the categories, you’ll see both Microsoft and third-party services that align to it along with a short description.


Click View to open up a fly-out screen on the right with additional details about the service, a typical engagement duration, a description of outcomes, and a link directly to the partner page about the service.


 


prof_servicesBlog.gif


Figure 2: Professional services catalog experience


 


Microsoft professional services are here to help
Microsoft has a range of security services that are offered to customers, including:



  • Microsoft Threat Experts – Microsoft Threat Experts – Targeted Attack Notifications is a managed threat hunting service. Once you apply and get accepted, you’ll receive targeted attack notifications from Microsoft threat experts, so you won’t miss critical threats to your environment. These notifications will help you protect your organization’s endpoints, email, and identities. Microsoft Threat Experts – Experts on Demand lets you get expert advice about threats your organization is facing. It’s available as a subscription service.

  • Microsoft Managed Desktop – If you are looking for someone to manage your desktop security, Microsoft Managed Desktop is a unique ITaaS solution that combines endpoint management and security monitoring and response in a way that gives users a secure and productive device experience that IT pros can trust.

  • Microsoft Detection and Response Team (DART) – If you have experienced a breach, the Microsoft Detection and Response Team will help your organization establish visibility of attacker activity, instantly start remediation, limit financial impact, get you back to business faster, and help you become cyber-resilient.

  • Microsoft Consulting Services – Microsoft Consulting Services help you prepare for the future, identify risks, and upgrade your environment by applying enterprise technology to business problems and guiding digital transformation. Through a rich set of Security solutions, Microsoft Consulting Services can help you modernize your Security posture by applying Zero Trust principles and modernize your Security Operations.

  • Compromise Recovery Security Practice (CRSP) – Part of Microsoft Consulting Services, the CRSP team can help you recover your environment post-security breach or ransomware attack.


 


Designed to deliver best-of-breed security, Microsoft offers partners opportunities to extend their existing security offerings on top of our open framework and a rich and complete set of APIs, allowing them to build extensions and integrations to Microsoft’s security platform. Security vendors interested in becoming our partners can use this page to get started.


As always, we welcome your feedback and would be glad to keep in touch.


Already a partner? Want to be in the catalog?
Please contact us at M365D_Prof_Serv_Cata@microsoft.com with your offering information and we will be happy to discuss your nomination for the catalog.


 





 


 

How-to find out the SQL MI Service Tier basic details with T-SQL

How-to find out the SQL MI Service Tier basic details with T-SQL

by | Jul 8, 2021 | Technology

This article is contributed. See the original author and article here.

We are starting a series of blog posts on how to find out the necessary information about Azure SQL Managed Instance (SQL MI) for your automation scripts and tools. We hope it will help you to build some extraordinary applications on the product that we love building.


There are already known ways to determine these properties through the Azure Portal or through your favorite script language (Powershell, Azure CLI or any other), we just wanted to provide some useful information on the good, old, original and ever-useful T-SQL.



Even though Azure SQL Managed Instance in its origin is the same as SQL Server, there are some specifics about SQL MI that cannot be found on the on-premises or Infrastructure as a Service (IaaS) offerings of SQL Server. Those differences start with the Service Tier that is a part of the Platform as a Service (PaaS) offering. 
So here are some of the basic how-tos: 


 


How-to ensure that Managed Instance is your engine


This information and recommendation have been public since the launch of the Azure SQL Managed Instance – the value that the SERVERPROPERTY function returns, specific to the SQL MI has a value of 8.


 

IF( SERVERPROPERTY('EngineEdition') = 8 ) 
BEGIN
    PRINT 'This is an Azure SQL Managed Instance.';
END
ELSE
BEGIN
	PRINT 'This is NOT an Azure SQL Managed Instance.';
END

 


Check the SQL MI.PNG


On the image provided, you can see the output, if you are running your code on Azure SQL Managed Instance.


 


 


How-to find out the Service Tier of your Managed Instance


Right now there are 2 offerings – GP (General Purpose) & BC (Business Critical), each one focusing on the specific type of the workloads with specific requirements, but there is no guarantee that one day it might not suffer changes, and any of the alternative ways of finding it out are risky, and so here is the official way of find out through the sys.server_resource_stats DMV, that provides a good amount of useful  and important information, regarding the Managed Instance service tier.

The Azure SQL MI Platform as a Service (PaaS) offering is a very dynamic and potentially a tier can be changed by the user at almost any moment with just a couple of clicks or a single T-SQL batch, making it quite different to a regular SQL Server installation, where things are less likely to change with the same ease, typically.


In order to obtain the value of the current SQL MI Service Tier, please get the latest available value for the SKU from the above mentioned sys.server_resource_stats view:


 

SELECT TOP 1 sku as ServiceTier
	FROM [sys].[server_resource_stats]
	ORDER BY end_time DESC;

 


ServiceTier.PNGIn my case, I have executed this query on the Generic Purpose instance, as you ca see in the results pane. You can easily save this value into a variable or use it directly in an IF statement to build some logic around your code.


 


 


How-to find out used Hardware Generation


It is important to know the generation of the hardware that is being used on your Azure SQL Managed Instance. Besides knowing wether you are running the latest and the greatest generation of hardware available, some of the constraints (such as RAM limits) have been connected to it, and understanding and checking this information might be important for troubleshooting and/or optimization.


Currently, only Generation 5 (Gen 5) is available for your SQL MI, but at the launch of SQL MI, a couple of years ago, we had 2 different generations available – including now obsolete Generation 4 (Gen 4), and one day in the future, there might be others. 


 


To check this information, we shall be using the sys.server_resource_stats DMV again, this time selecting the [hardware_generation] column as the result:


 


 

SELECT TOP 1 hardware_generation as HardwareGeneration
	FROM [sys].[server_resource_stats]
	ORDER BY end_time DESC;

 


Hardware Generation.PNG


 


In this blog post we have provided you with just a couple of T-SQL scripts that will allow your better discovery of the SQL MI environment with the help of T-SQL. Stay tuned for even more insight that we are looking to bring to you.

Azure Marketplace new offers – Volume 152

Azure Marketplace new offers – Volume 152

by | Jul 8, 2021 | Technology

This article is contributed. See the original author and article here.











We continue to expand the Azure Marketplace ecosystem. For this volume, 99 new offers successfully met the onboarding criteria and went live. See details of the new offers below:























































































































































































































































































































































































































Applications
A10 Training - Virtual Lab (Japan).png

A10 Training – Virtual Lab (Japan): This virtual lab for A10 Networks’ Cloud Access Proxy and SSL Insight solutions allows users to customize the lab environment for troubleshooting, operational checks, and proofs of concept. This offer is available only in Japanese.
Augury Machine Health.png

Augury Machine Health: Augury’s Halo Machine Health combines advanced sensors with powerful AI-based diagnostics and collaboration tools to help teams understand when machines are at risk and how to intervene.
Azure DevOps to Zendesk connector.png

Azure DevOps to Zendesk connector: This connector from IntegrateCloud integrates Microsoft Azure DevOps with Zendesk, allowing support agents to create Azure DevOps work items from Zendesk ticket forms.
BHC3 AI Suite.png

BHC3 AI Suite: BakerHughesC3.ai brings together the energy technology expertise of Baker Hughes with C3.ai’s AI software for digital transformation in the oil and gas industry. The core of BHC3 AI Suite is an extensible, model-driven abstraction layer that dramatically enhances data scientist and application developer productivity.
Carebook Digital Pharmacy Platform.png

Carebook Digital Pharmacy Platform: Carebook is an all-in-one, customer-facing digital pharmacy solution. Engage your customers, easily connect with patients, provide online prescription refills, and seamlessly integrate with third-party e-commerce and loyalty systems.
Certis Smart Integrated Transport Hub.png

Certis Smart Integrated Transport Hub: Smart Transport Hub from Certis delivers a platform capable of transforming traditional transportation frameworks into intelligent, proactive networks. Support effective project development and asset management while securing the long-term viability of your transportation system.
Circit - Audit Confiirmations.png

Circit – Audit Confirmations: Circit, an open banking and audit platform, connects audit firms to banks and other evidence providers to facilitate more efficient and higher-quality audits. Circit automates the audit confirmation process using platform tools and open banking connectivity.
Cloud-Native CMS_DXP for Drupal.png

Cloud-Native CMS/DXP for Drupal: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Drupal 9.1.2, Apache 2.4.46, MySQL 5.7.34, PHP 7.3.28, phpMyAdmin 5.1.0, and Docker 20.10.6 on CentOS 7.9.
Cloud-Native Database for PostgreSQL.png

Cloud-Native Database for PostgreSQL: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides PostgreSQL 9.4, 9.6, 10, or 11, along with pgAdmin 5.2 and Docker 20.10.6 on CentOS or Ubuntu.
Cloud-Native Database for RethinkDB.png

Cloud-Native Database for RethinkDB: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides RethinkDB 2.4.1 and NGINX 1.20.0 on Ubuntu 20.04. RethinkDB is a NoSQL database that stores schema-less JSON documents.
Cloud-Native In-memory Database for Redis.png

Cloud-Native In-memory Database for Redis: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Redis 3.0, 3.2, 4.0, 5.0, or 6.0, along with NGINX 1.20.0 and RedisInsight on CentOS or Ubuntu.
Cloud-Native MQ for Apache ActiveMQ Power by VMLab.png

Cloud-Native MQ for Apache ActiveMQ: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Apache ActiveMQ 5.16.1 and OpenJDK 1.8.0 on CentOS or Ubuntu. Apache ActiveMQ is a popular and powerful open-source messaging and integration patterns server.
Collabspace ARCHIVE- Content Protection and Search.png

Collabspace ARCHIVE: Content Protection and Search: Collabspace ARCHIVE features versioning, email thread archiving, and file preview, along with data encryption and Write-Once-Read-Many (WORM) storage to prevent tampering or deletion. 
Compose Low-Code Platform on Azure.png

Compose Low-Code Platform on Azure: Governments and businesses alike can use Compose to achieve their digitization and productivity goals. The low-code application development platform is well-suited for data gathering, process automation, and case management.
Content Collaboration Platform based on ownCloud.png

Content Collaboration Platform based on ownCloud: This image offered by VMLab provides version 10.7 of ownCloud on CentOS 7.9. ownCloud is client–server software for creating file-hosting services. Also included are Apache 2.4.46, PHP 7.4.19, MySQL 5.7.34, Redis 5.0.9, ONLYOFFICE Docs Community 6.1.1, phpMyAdmin 5.1.0, and Docker 20.10.6.
Creative Work Subscription and Publishing Platform.png

Creative Work Subscription and Publishing Platform: This image offered by VMLab provides Ghost 4.5.0 on CentOS 7.9. Ghost is a headless Node.js content management system for professional publishing. Also included are NGINX 1.20.0, MySQL 5.7.34, Node.js 14.17, Docker 20.10.6, and phpMyAdmin 5.1.0.
Data Exploration and Visualization for Superset.png

Data Exploration and Visualization for Superset: This preconfigured image offered by VMLab provides Apache Superset 1.0, NGINX 1.20.0, PostgreSQL 10.16, Docker 20.10.6, Redis 3.2.12, and PgAdmin 5.2 on Ubuntu 20.04. Apache Superset is an open-source app for data exploration and data visualization.
DeepVu Aluminum Price Forecasting.png

DeepVu Aluminum Price Forecasting: DeepVu offers machine learning models to predict the price of a futures contract of a commodity that is traded on the Chicago Mercantile Exchange or the Shanghai Futures Exchange.
DevOps Automation Server for Jenkins.png

DevOps Automation Server for Jenkins: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Jenkins 2.277.4, OpenJDK 1.8.0, and NGINX 1.20.0 on CentOS or Ubuntu. Jenkins is an automation server with a plug-in ecosystem for supporting delivery pipelines.
EDB Enterprise Plan - PostgreSQL.png

EDB Enterprise Plan – PostgreSQL: The EDB Enterprise Plan features tools, support, and a PostgreSQL database extended by EDB’s enterprise-class software. This provides compatibility with Oracle Database, so you can migrate quickly to EDB on Microsoft Azure.
EY OpsChain Traceability.png

EY OpsChain Traceability: EY OpsChain Traceability brings trust via transparency into any supply chain. The solution is part of the EY OpsChain product suite, built on the EY Blockchain SaaS platform, which is hosted on Microsoft Azure.
Fortpress Starter.png

Fortpress Starter: Fortpress is an all-in-one application management system for developing blogs, web apps, websites, APIs, and more. Fortpress provides an integrated code editor for HTML, JavaScript, and CSS.
Hardened Windows Server 2019.png

Hardened Windows Server 2019: This image of Windows Server 2019 is preconfigured by The Center for Internet Security (CIS) to the recommendations in the associated CIS Benchmark and the U.S. Department of Defense’s Security Technical Implementation Guide (STIG).
HealthEC Population Health Management Platform.png

HealthEC Population Health Management Platform: HealthEC’s population health management solution aggregates claims and clinical data to deliver key insights into cost drivers and evaluate quality measures that impact performance-based reimbursements while enabling the care team to be a change agent.
Hólos - Fluxos.png

Hólos – Fluxos: Hólos from MPS Informática provides the resources necessary for the development and implementation of business process management and electronic document management. This app is available only in Portuguese.
Horizon Protection Engine.png

Horizon Protection Engine: Horizon Protection Engine integrates with cloud, hybrid-cloud, and on-premises architectures and allows users to utilize Microsoft Azure Information Protection to secure their business applications. This app is available only in Italian.
Incorta Intelligent Ingest for Microsoft Azure Synapse.png

Incorta Intelligent Ingest for Microsoft Azure Synapse: With Incorta Intelligent Ingest, you can seamlessly integrate your Oracle application/ERP data into Microsoft Azure for rapid analytics in Azure Synapse. Incorta fast-tracks the process for preparing data by automating the data modeling and staging steps. 
IN-D Aadhaar Number Masking.png

IN-D Aadhaar Number Masking: Aadhaar is a random 12-digit number issued to residents of India. Banks, hotels, and many other companies store Aadhaar images of their customers. IN-D Aadhaar Number Masking can verify and mask these images at the click of a button, helping companies maintain regulatory compliance.
Joshua Tree.png

Joshua Tree: Joshua Tree is an eco-design tool for clothing makers that collects and consolidates internal data as well as audit data carried out with suppliers, with a focus on environmental and social performance. This app is currently available only in French.
LEA365.png

LEA365: LEA is a chatbot included in Aurera’s MyCoach 365 change management solution. LEA integrates with Microsoft Teams to assist users and optimize their experience. This app is available in French.
MAESTRO.png

MAESTRO: Maestro is an IoT platform developed on Microsoft Azure components that provides end-to-end integration across operational, strategic, and tactical data flows. Sensors and machines can be managed and monitored remotely, alarms and notifications can be generated, and there is a dashboard for users.
Magento Server.png

Magento Server: This server image offered by Cloud Infrastructure Services provides Magento Open Source, Apache Web Server, MySQL Server, ElasticSearch, and all the required PHP modules on Ubuntu Server 20.04. Magento Open Source is a free e-commerce platform.
Mingdao APaaS and Zero-Code Platform.png

Mingdao APaaS and Zero-Code Platform: This preconfigured image offered by VMLab provides Mingdao On-Premise 2.4.1 and Docker 20.10.6 on CentOS 7.9. Mingdao is a rapid design and development tool for enterprise software. This app is available in English, Simplified Chinese, and Traditional Chinese.
Motif Discovery.png

Motif Discovery Application: Improve productivity and learn more about your machine data with Motif Discovery Application, a tool that automatically processes time series data and creates training data for machine learning models. Discovered patterns are clustered based on similarity.
Web App Runtime for Node.js.png

Node.js Runtime for Web App: This image offered by VMLab provides Node.js 10, 12, or 13 on CentOS 7.9. Node.js is a JavaScript runtime. Also included are NGINX 1.20.0, MySQL 5.7, Redis 5.0.9, Docker 20.10.6, phpMyAdmin 5.1.0, adminMongo 0.0.23, PM2 4.5.6, Express 4.16.1, and your choice of several versions of MongoDB.
Numerator Consumer Data Capture Link.png

Numerator Consumer Data Capture Link: Historically, consumer purchase data has been controlled by retailers, leaving brands with limited access. Numerator Link from Market Track democratizes data access (purchase or viewership), and brands can access consumer data from permissioned user accounts.
Open-Source Agile and Scrum Project Management.png

Open-Source Agile and Scrum Project Management: This preconfigured image offered by VMLab provides Zentao 12.4.3 on CentOS 7.9. Zentao is open-source project management software. Also included are Apache 2.4.46, PHP 7.2.34, MySQL 5.6.51, Redis 5.0.9, phpMyAdmin 5.1.0, and Docker 20.10.6.
Open-Source Cloud-Native ERP and CRM.png

Open-Source Cloud-Native ERP and CRM: This preconfigured image offered by VMLab provides Odoo Community Edition 12, 13, or 14 on Ubuntu 20.04. Odoo is a suite of open-source business apps. Also included in the image are NGINX 1.20.0, PostgreSQL 11.11, PgAdmin 5.2, and Docker 20.10.6.
Open-Source Collaboration Platform for Developers.png

Open-Source Collaboration Platform for Developers: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Mattermost Team Edition 5.34.0, an open-source messaging platform, on Ubuntu 18.04. Also included are NGINX 1.20.0, MySQL 5.7.34, Docker 20.10.6, and phpMyAdmin 5.1.0.
Open-Source IT Monitor Platform.png

Open-Source IT Monitor Platform: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Zabbix 5.2 on Ubuntu 20.04. Zabbix is an open-source distributed monitoring solution. Also included in the image are NGINX 1.20.0, MySQL 8.0.25, phpMyAdmin 5.1.0, and Docker 20.10.6.
petranna.db.MySQL managed service.png

petranna.db.MySQL managed service: The petranna.db.MySQL service allows an unlimited number of tenants on the same RDBMS instance, leading to a significant reduction in costs and faster time-to-market for SaaS applications.
Web App Runtime for PHP (LAMP).png

PHP Runtime for Web App (LAMP): This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides PHP 5.6, 7.0, 7.2, or 7.4, along with Apache 2.4.46, Redis 5.0.9, phpMyAdmin 5.1.0, and Docker 20.10.6 on CentOS 7.9. Also included is MySQL 5.7 or 8.0.
Web App Runtime for PHP (LEMP).png PHP Runtime for Web App (LEMP): This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides PHP 5.6, 7.0, 7.2, or 7.4, along with NGINX 1.20, Redis 5.0.9, phpMyAdmin 5.1.0, and Docker 20.10.6 on CentOS 7.9. Also included is MySQL 5.7 or 8.0.
Pobuca Customer Voice.png

Pobuca Customer Voice: Pobuca Customer Voice helps you know your customers by collecting and processing their feedback. Analyze all customer communications in natural language from voice recordings, emails, chats, and social media, and extract customer experience alerts and insights.
Pobuca Knowledge.png

Pobuca Knowledge: Pobuca Knowledge leverages AI to analyze conversations from all customer touchpoints and extract Q&As, which you can use for your knowledge base and to engage your customer service agents.
Redmine Open-Source Project Management.png

Redmine Open-Source Project Management: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides Redmine 4.2.1, NGINX 1.20.0, MySQL 5.7.34, phpMyAdmin 5.1.0, and Docker 20.10.6 on Ubuntu 20.04. Redmine is a project management web app that uses the Ruby on Rails framework.
Sail Indoor Positioning.png

Sail Indoor Positioning: Sail is an indoor positioning platform that enables mobile app developers to create indoor navigation, location analytics, and personalization services. Sail uses machine learning to continually reconfigure the system, removing the need for any fingerprinting or calibration.
SailPoint Access Risk Management Solution.png

SailPoint Access Risk Management Solution: SailPoint Access Risk Management automates real-time access risk analysis, simplifies GRC (governance, risk, and compliance) processes, and identifies a potential user’s risks before access is granted.
SDx Transact - Smart Cloud.png

SDx Transact – Smart Cloud: HxGN SDx provides a central digital platform to optimize the design, engineering, construction, operation, and maintenance of industrial assets. Ensure safe and efficient operations in your facility.
Seatti Desk Booking & Team Collaboration.png

Seatti Desk Booking & Team Collaboration: Whether you’re working on-site, at home, on a business trip, or in a café, Seatti lets you plan your workspace locations and collaborate with your team. Stay connected in a hybrid, distributed workplace.
Secure Store.png

Secure Store: The prescriptive analytics of Secure Store Version 5.4, built with artificial intelligence, allows retailers to make informed decisions to improve profitability, reduce shrink, and achieve rapid return on investment.
Senserva for Azure.png

Senserva for Azure: Senserva, a cloud security posture management solution, produces priority-based risk assessments for all the Microsoft Azure objects that Senserva manages, enabling customers to perform optimal discovery and remediation.
Soft-ex Unified Analytics for Microsoft Teams.png

Soft-ex Unified Analytics for Microsoft Teams: The latest release of Soft-ex’s unified communication analytics solution offers a new user interface with a widget-driven dashboard. The configurable solution integrates with Microsoft Teams to deliver granular visibility.
TACHYUS. Production Optimization for Oil & Gas.png

TACHYUS. Production Optimization for Oil & Gas: The Tachyus platform and its Data Physics technology empower oil producers to make data-driven decisions that maximize asset value. Data Physics combines reservoir physics and machine learning to rapidly integrate data sources and identify optimal injection and drilling plans.
Teamviewer IoT Edge.png

TeamViewer IoT Edge: TeamViewer IoT lets you remotely control edge devices. To process events, such as machine failure or anomalies, TeamViewer IoT includes data processing on the edge as well as cloud-based predictive maintenance solutions.
TelluCare Digital Supervision.png

TelluCare Digital Supervision: Digital Supervision from Tellu allows healthcare personnel to use cameras to watch over patients in nursing homes or home-care environments. Camera images can also be anonymized for privacy reasons.
Verita Research Partner (VRP) Isolation Service.png

Verita Research Partner (VRP) Isolation Service: The VRP Isolation Service uses novel AC electrokinetics-based microarrays to capture DNA fragments greater than 300 bp, which are primarily derived from cell necrosis or extracellular vesicles carrying proteins and RNA. After isolation, these biomarkers can be investigated using standard lab techniques.
Visual Machine Learning Stack for TensorFlow.png

Visual Machine Learning Stack for TensorFlow: This preconfigured image offered by VMLab, an authorized reseller for Websoft9, provides TensorFlow 2.5.0, TensorBoard, NGINX 1.20.0, and Python 3.8.5 on Ubuntu 20.04. TensorFlow is an end-to-end open-source platform for machine learning.
VMware Tanzu Standard.png

VMware Tanzu Standard: VMware Tanzu Standard Edition simplifies the operation of Kubernetes for multi-cloud and hybrid-cloud deployments, centralizing management and governance for many clusters and teams across Microsoft Azure and edge or on-premises environments.
Windows Server 2019 with SQL Express.png

Windows Server 2019 with SQL Express: This image offered by Belinda CZ s.r.o. provides Windows Server 2019 with SQL Express. Also included is SQL Server Management Studio, an integrated environment to manage SQL bases.
WordPress.png

WordPress: This image offered by Niles Partners provides WordPress 5.7.1, a popular publishing platform for blogs and websites. WordPress offers customization through themes, extensions, and plug-ins.

Consulting services
4-Week Data Science Proof of Concept.png

4-Week Data Science Proof of Concept:  Hitachi Solutions experts will work with your team to identify data and deliver a robust modeling environment designed to accelerate your cloud journey using Hitachi Solutions Advanced Analytics DataLab and Microsoft Azure.
App Modernization- 10-Day Assessment.png

App Modernization: 10-Day Assessment: Cloud Temple will help your modernization project into the Microsoft Azure cloud by defining stakes, realizing a target architecture, and building scenarios using services such as Azure Migrate. This offer is available only in France.
Azure Backup- 1-Hour Briefing.png

Azure Backup: 1-Hour Briefing: Learn how Chunghwa Telecom can provide your enterprise with remote monitoring and management, restoration exercises, and disaster recovery execution to meet all your Microsoft Azure cloud backup needs. This offer is available only in Chinese.
Azure Check-up.png

Azure Check-up: The Azure Check-up from Unica ICT Solutions is a quick and easy way to map the status of your Microsoft Azure environment based on criteria such as security, continuity, performance, and cost. This offer is available only in Dutch. 
Azure Datacenter Foundation - Implementation.png

Azure Datacenter Foundation – Implementation: This one-week implementation by timengo includes a roadmap report with recommendations and configurations for a Microsoft Azure foundation based on timengo’s reference architecture. This offer is available only in Danish.
Azure Quick Start- 4-Day Implementation Service.png

Azure Quick Start: 4-Day Implementation Service: Bytes Software Services will explain Microsoft Azure capabilities and how they relate to your strategic adoption of the cloud platform, giving you an understanding of the requirements and blockers for implementation.
Azure Virtual Desktop- 2-Week Implementation.png

Azure Virtual Desktop: 2-Week Implementation: This implementation by Cloud Services provides your organization with assessment, configuration, cost estimates, testing, and fine-tuning to set up and manage compliant and fully secured virtualized desktop environments.
Azure Virtual Desktop- 3-Day Assessment.png

Azure Virtual Desktop: 3-Day Assessment: This assessment by +Aliance provides a cost estimate for transitioning to Azure Virtual Desktop, allowing you to enable remote work, reduce office costs, and combine offices in one infrastructure. This offer is available only in Russian.
Azure Virtual Desktop- 5-Day Proof of Concept.png

Azure Virtual Desktop: 5-Day Proof of Concept: This offer from Cisilion provides everything you need (demo, design, deployment, configuration, testing, and handover) to understand and prove the value of Azure Virtual Desktop across key stakeholders within your organization.
Azure VMware Solutions- 4-Week Implementation.png

Azure VMware Solutions: 4-Week Implementation: The Logicalis Azure VMware Solution (AVS) combines best-in-class technologies with a proven methodology so you can innovate, optimize your business, and achieve your transformation vision without a hassle.
Celonis Proof of Value (1 Week).png

Celonis Proof of Value (1 Week): This offer from diconium digital solutions proves the value of Celonis big data technology process mining, helping you visualize your business processes like never before and turn them into extraordinary experiences. This offer is available only in German.
Cloud Readiness-Check- 4-Hour Assessment.png

Cloud Readiness-Check: 4-Hour Assessment: Experts from redIT will examine your infrastructure and apps, then show you how to optimally move local IT to the cloud with a combination of Microsoft Azure, Microsoft 365, and Dynamics 365. This offer is available only in German.
Cloud Security- 1-Week Assessment.png

Cloud Security: 1-Week Assessment: This Ironstone offer provides a thorough analysis of, and useful insights into, your cloud security setup. Get a clear report assessing cloud security risks, recommendations, and actions so your organization can take a proactive approach.
Cogmation- 2-Week Implementation.png

Cogmation: 2-Week Implementation: This offer from L&T Technology Services provides end-to-end test automation for multipurpose applications and embedded devices via Cogmation on Azure Virtual Machines, a highly customizable and easily deployable test automation solution.
Confidential Compute 10-Week Assessment.png

Confidential Compute 10-Week Assessment: Does your data require conclusive assurances of security and fall under specific regulatory demands? This offer from PwC can help you exercise full control over your data in the cloud and utilize it to further enable your business. 
Corrosion Detection Using Azure 8-Week Proof of Concept.png

Corrosion Detection Using Azure 8-Week Proof of Concept: This consulting offer from Affine shows how Microsoft Azure deep learning can detect and classify corrosion via imagery. The solution uses Azure IoT Hub, Azure Machine Learning, Azure Synapse Analytics, and more.
Data Analytics on Azure- 2-Week Implementation.png

Data Analytics on Azure: 2-Week Implementation: Turn raw data into insights that drive decision-making and revenue with Navisite services and Microsoft Azure. Navisite data experts will help you define, design, and build a transformative analytics-driven organization.
DIP Capital Markets- 4-Week Proof of Concept.png

DIP Capital Markets: 4-Week Proof of Concept: Neudesic experts will help you deliver next-level insights across private equity assets by using its Document Intelligence Platform, knowledge mining framework, and preconfigured architectures to quickly deploy AI and use cases.
DynTek Managed Security Services.png

DynTek Managed Security Services: Using the power of Azure Sentinel, DynTek will actively monitor your environment to help you sort through the noise of false positives in order to hunt for security threats and turn alerts into actionable intelligence. 
Easy Cloud and Applications- 3-Weeks Briefing.png

Easy Cloud and Applications: 3-Weeks Briefing: Over the course of this three-week consulting engagement, the experts at RCR will help you create and build sustainable, scalable, and cost-efficient cloud applications using all the power that Microsoft Azure has to offer.
EPAM Azure Security- 6-Weeks Assessment.png

EPAM Azure Security: 6-Weeks Assessment: EPAM’s security assessment uses a combination of industry best practices and frameworks to understand the current security posture, critical gaps, and future state of your enterprise Microsoft Azure cloud environment.
ETL Conversion to ADF- 2-Day Assessment.png

ETL Conversion to ADF: 2-Day Assessment: Bitwise will provide a high-level time and cost estimate to migrate your on-premises data integration jobs to Microsoft Azure Data Factory using automated extract-transform-load (ETL) conversion.
Evolution ASEINFO- Implementation in 4 Weeks.png

Evolution ASEINFO: Implementation in 4 Weeks: Simplify your organization’s personnel records management, payroll, recruitment, evaluation, training, and more with this offer from Asesores en Informática, available only in Spanish, to implement Evolution ASEINFO on Microsoft Azure.
F&R Starter Kit Proof of Concept- 4-Hour Proof of Concept.png

F&R Starter Kit Proof of Concept: 4-Hour Proof of Concept: This proof of concept from Bardess Group delivers dynamic finance, accounting, and reporting charts to compare results to prior period, budget, and/or forecast without all the traditional manual work required. 
FAR Accelerator - A 1-Day Project Scope Workshop.png

FAR Accelerator – A 1-Day Project Scope Workshop: Learn how you can benefit from Bardess Group’s finance, accounting, and reporting accelerator on Microsoft Azure to pull data from various sources for presentation in browser-based applications that are accessible anywhere.
Image Analytics- 2-Week Proof of Concept.png

Image Analytics: 2-Week Proof of Concept: The experts from Cognilytic Technologies will work with you to build cutting-edge facial recognition or object detection scenarios to extract specific information using Microsoft Azure Cognitive Services pretrained models. 
Innovation Factory- 6-Week Implementation.png

Innovation Factory: 6-Week Implementation: Create cloud-native applications running on Microsoft Azure with Devoteam Alegri’s Innovation Factory. The dedicated packages of this offer will help you understand, explore, and realize your business case.
Managed IT Services.png

Managed IT Services: Big Idea Technology provides complete outsourced IT management services (virtual CIO, network monitoring, backup and disaster recovery, and more) to small to midsized businesses, and performs project-based engagements in most IT disciplines.
CentriLogic.png

Managed Services for Azure from CentriLogic: CentriLogic’s certified experts will work with you to design, deploy, and continuously support a right-sized environment on Microsoft Azure that is suited to your organization’s workloads and applications.
Microsoft 365 Cloud Security- 1-Day Assessment.png

Microsoft 365 Cloud Security: 1-Day Assessment: Direkt Gruppe experts will provide concrete recommendations for your organization to deploy specific security features (Azure Information Protection, Advanced Threat Protection, and more) in your Microsoft 365 environment.
Modern Data Platform Pilot- 8-Week Implementation.png

Modern Data Platform Pilot: 8-Week Implementation: Digia’s fast-track implementation of a modern data platform on Microsoft Azure and Microsoft Power BI empowers a future of data-driven decision-making through dashboards and key performance indicators (KPIs).
NNIT Managed Azure Virtual Desktop Service.png

NNIT Managed Azure Virtual Desktop Service: NNIT provides a coherent approach to optimize your virtual desktop solution, focusing on operational value and consistent processes. NNIT can also handle round-the-clock day-to-day operations and required governance processes.
Promotions Optimization Using Azure- 6-Week Proof of Concept.png

Promotions Optimization Using Azure: 6-Week Proof of Concept: Affine offers robust marketing campaign design and management to consumer and retail-sector firms with this solution that uses Microsoft Azure services such as Azure Data Factory and Azure Functions.
Satisnet Cyber Security Gap Analysis Assessment.png

Satisnet Cyber Security Gap Analysis Assessment: Satisnet provides a complete cybersecurity gap analysis to highlight where your organization should focus. Deliverables include a report on how to use the Microsoft security stack, namely Azure Defender and Microsoft 365 Defender.
Smart SAP on Azure- 4-Week Implementation.png

Smart SAP on Azure: 4-Week Implementation: Streamline your transformation to SAP HANA with Microsoft Azure via myCloudDoor, which has implemented hundreds of SAP on Azure solutions and earned the SAP on Azure advanced specialization designation from Microsoft.
Threat Management Assessment.png

Threat Management Assessment: IBM’s three-day assessment identifies gaps in your Microsoft Azure hybrid-cloud security program and provides directional recommendations to improve security operations, incident response, compliance, and governance.
Web Application Modernization- 1-Day Assessment.png

Web Application Modernization: 1-Day Assessment: In this session, Sela’s experts will use tools and discussions to assess your web application’s readiness for modernization to Microsoft Azure Web Apps, which can greatly improve scalability and availability. 
Windows Server and SQL Migration- 1-Hour Assessment.png

Windows Server and SQL Migration: 1-Hour Assessment: Zones offers services to enhance your security posture and extend the life of your Windows Server 2008 and SQL 2008 family of products by assessing, designing, and implementing their migration to Microsoft Azure.

Five Practical Tips to Limitless Data Integration Using Azure Data Factory | Data Exposed

by | Jul 8, 2021 | Technology

This article is contributed. See the original author and article here.

Azure Data Factory (ADF) is a fully managed, easy-to-use, serverless data integration solution to ingest all your on-premises, hybrid, and multi-cloud data In this episode with Wee Hyong Tok, you will learn about the latest product updates to ADF, and how ADF is integrated with Azure Synapse Analytics and Azure Purview.


 


Watch on Data Exposed



Resources: