Multiple data source definitions on the On-premises data gateway for same data source

Gateway management until recently, supported only one data source definition per data source on an on-premises data gateway. This posed limitations for gateway admins as they couldn’t create multiple data sources to the same data source each with different credentials based on the required security context for each one. The workaround would be to spin up a new gateway for every new data source.

Note: The data source name still needs to be unique for every data source definition.

Below you can see that a gateway admin has created two data source definitions for the same database AdventureWorks2017 on the same server.

Once you publish a Power BI report, in the Dataset settings, you will be able to see the list of data sources you have access to as below. You can now select one of these data sources.

If you are a gateway admin, you could also additionally choose to add a new data source (as shown below) and that would take you to the Manage Gateways page to create a new data source.


If you have access to only one data source, you must explicitly select that data source.


Once all required data sources have been set up and selected, click on apply to bind this dataset to the selected data source on the gateway.


Note: This feature is currently available only for datasets. We plan to release the same feature for dataflows soon. Currently in dataflows, until this change is rolled out, the first available data source would be automatically selected. 

Resource Credit | Power BI

AppSource hat trick: 3 visual scheduling apps in one quarter

For a while, our Marketing claim is the same. We are the company with the most complete stack of visual scheduling software for Microsoft Dynamics 365 Business Central and NAV. The finished second calendar quarter underlines this claim. We achieved the hat trick and published three visual scheduling apps on Microsoft’s AppSource. With this, the second generation of our Visual Scheduling Suite is taking shape.

Partners and customers from now on can achieve seamless visual scheduling of production orders, jobs, and resources. Also, they can get a comprehensive resource Gantt chart. The latter shows allocations from jobs, service orders, assembly orders, and absences. The Q2 hat trick brought three apps to AppSource. Visual Production Scheduler (VPS), Visual Jobs Scheduler (VJS), and Visual Resource Viewer (VRV). 

Operational agility with visual scheduling

Our mission is to empower every SMB organization to gain operational agility with visual scheduling. Operational agility is the key for companies to operate and grow in unpredictable environments. It makes them robust, responsive, and flexible. Visual scheduling is a key enabler of operational agility. It achieves transparency faster. This allows faster and better decision making when it comes to timing and resource-sensitive planning issues. Faster and better decisions – e.g. on delivery times – turn into happier customers. This fuels growth. At the same time, companies use resources in a more effective way.

The Visual Scheduling Suite

We are on the mission of empowering every SMB to gain operational agility with visual scheduling. This drives our commitment to Microsoft Dynamics 365 Business Central. We regard Business Central as an effective SMB business management solution. Yet, Dynamics 365 Business Central lacks any kind of visual scheduling functionality. This is the gap we are closing with the Visual Scheduling Suite.

The principles of the Visual Scheduling Suite have been the same for the past few years:

  • We provide a visual drag and drop front-end to Dynamics 365 Business Central (before: NAV).
  • We directly integrate with the Business Central database. We read from the standard tables and we write into the standard tables.
  • We do not change the Business Central standard tables.
  • That means: you can achieve with our visual scheduling apps what you can also achieve with Business Central. But, the visual scheduling apps help more transparent, faster and thorough scheduling.
  • That means: installation is hassle-free. We speak about a few hours, rather than many days.

Thanks to the Q2 hat trick, the Visual Scheduling Suite for Dynamics 365 Business Central consists of the following three apps: 

  • Visual Production Scheduler
  • Visual Jobs Scheduler
  • Visual Resource Viewer

1. Visual Production Scheduler

The Visual Production Scheduler is an app for small manufacturers working with the standard Business Central manufacturing module. It provides visual drag and drops front-end to production orders, routings, work centers, machine centers, and capacity utilization. It comes with both a production plan Gantt chart and a resource Gantt chart (for work and machine centers). Customers can use the VPS to quickly reschedule production orders – both time and resource-wise.

visual scheduling

2. Visual Jobs Scheduler

The Visual Jobs Scheduler is an app for any company working with the standard Business Central jobs and resource planning modules. It provides visual drag and drops front-end to jobs, job tasks, job planning lines, and resource allocations. It comes with both a project plan Gantt chart and a resource Gantt chart. Customers can use the VJS to quickly reschedule entire jobs and job tasks as well as job planning lines – both time and resource-wise.

visual scheduling

3. Visual Resource Viewer

The Visual Resource Viewer is a complementary app to the VJS. It is for those companies that use the resource planning module for jobs and/or service orders and/or assembly orders. As such, it provides a comprehensive overview in the form of a Gantt chart and takes into account resource allocations from all three functionality areas plus resources’ absences. The VRV is for viewing only and does not support drag and drop actions.

After the launch is before the launch

As much as we are proud of the Q2 hat trick, as disciplined we can resist the temptation of becoming complacent. We have much higher ambitions to support any kind of Business Central use case with proper visual scheduling.

Hence we commit to the following:

  • Provide a monthly update of the VPS – with enhanced functionality and fixed bugs
  • Provide a monthly update of the VJS  – with enhanced functionality and fixed bugs
  • Provide an update of the VRV to support all languages and countries that are supported by Business Central
  • Make the Visual Advanced Production Scheduler (VAPS) available for beta testing in July
  • Release the first version of the Visual Service Scheduler (VSS) at Directions EMEA

Learn more about NETRONIC’s Visual Scheduling Suite and how it can help manage your business. To chat with a consultant contact allonline365 on or  +27 (21) 205 3650. 

Resource Credit | NETRONIC

The restaurant experience revolution


Drive a more modern guest experience with technology

From automation to delivery disruption, to the meat-free movement and more, the restaurant industry has been going through times of utter change. It’s the ultimate all-you-can-eat buffet, and then some. Despite this ‘smorgasbord’ of influences, one key ingredient has been driving disruption above all others, accelerating change at unprecedented levels: technology.

Let’s take a look at some trends shaping the restaurant industry today and tomorrow.

1. Evolving the restaurant beyond four walls

In the US alone, three out of five consumers order delivery or takeout at least once a week, the National Restaurant Association reports.  Similarly, 50% of dinner meals purchased from a restaurant today are consumed at home. As consumers look for experiences that blend the excitement of eating out with the convenience of staying in, restaurants must evolve beyond their four walls to meet new demands. This means giving guests the freedom to get their favorite food from your restaurant whichever way they prefer: order ahead, show up to eat on the premises, order online and pick-up in the restaurant, or order online and pay for the delivery via a third party – it’s their choice.

In order to offer such possibilities to consumers, restaurants need to have technology in place that helps them deliver a seamless consumer experience. Ideally, that means a solution that provides a single, unified view of customers across channels, and is built to connect together with your back-office, kitchen, customers, HQ, and beyond.

2. Evolving the in-restaurant experience

From in-store designs and layouts that make restaurant spaces more ‘instagrammable’, to immersive experiences that take guests into the very essence of a brand, the in-restaurant experience has gone through a great transformation in the past few years. At the center is the desire to provide restaurant guests with an experience that is unique, unforgettable, and the highest quality possible.

But what does a great dining experience entail exactly? For some types of restaurants, this calls for knowing guests more closely, offering them their favorite free drink while they wait to be seated. For other establishments, the great guest experience is a quick and hassle-free one, delivered with self-serve kiosks or self-ordering devices at the table to help people in a hurry save precious time. Either way, the key is to understand your customers and know why they are in your restaurant. Then you can tailor the experience to cater to their needs (with a little bit of help from technology).

To do all this you need technology that brings together a customer’s order history (from all channels), dining preferences, loyalty level, and potentially even social media data. The tech that takes these different data sets unites them into a single view and provides you with actionable insights that can make the difference between average customer experience and an awesome one.  Plus, it might bring valuable reviews on social media.

3. Employees are your heart and soul

Employee turnover rates are notoriously high in the restaurant industry, with some estimates going as high as around 75%. Many factors play a role, from wage levels to a stressful environment, to limited opportunities for growth. No matter how you look at it, high employee turnover rates are simply not good for business.

So how can technology help? By making your employees more efficient and productive, and enabling them to do their job better. This can apply to your entire staff, al the way from the back office, to the kitchen team, to the front of house staff. Give your servers a mobile Point of Sale device, and they won’t just have a modern tool to take orders in their hands. They will also get a sense of empowerment from being able to answer customers’ questions easily, and the pride of knowing they are giving a top-class frictionless experience.

With more and more young, tech-savvy workers joining the industry, being known as a forward-thinking employer that empowers staff members with modern technology can be a major differentiator to your competition in the search for talent.

4. An Artificial Intelligence-infused restaurant business

Although restaurants have typically been quite slow to adopt technology, increasing pressure from consumers has forced them to update their systems, implementing tech such as mobile POS and self-service kiosks. At the same time, innovation keeps on moving. Artificial Intelligence (AI) powered systems are already being used to optimize staffing schedules, streamline supply chains, and providing better customer service through voice ordering and chatbots, just to make a few examples. Restaurants collect vast amounts of data, but this is often organized into disconnected sets stored in separate databases, which are difficult to analyze and use. Thankfully there is a solution. Uploading data to the cloud can give restaurants the extra storage capabilities and computing power they need. Cloud-based AI can be a cost-effective, powerful tool to analyze your data, helping you better serve your customers, cut costs, and even understand your strengths and weaknesses.

But where do you start? AI isn’t necessarily a fast-track ticket to success, and it should be approached with a planned approach. Start by identifying the areas of your business where AI could help you drive improvements – perhaps it could be your customer-facing mobile app or inventory management. Then you can define an AI roadmap that includes pilot projects where you can test the application and impact of AI on your business. Finally, take the learnings to other parts of the organization.

If you would like to learn more about how innovative technology can help you reach your business goals contact allonline365 on or  +27 (21) 205 3650.

Resource Credit | LS Retail

Call Now Button