SQL Server on Linux!? – Meet SQL Server 2017

Over the last decade, DATA is the NEW OIL. While the increasing amount of digitization has led to data exploding exponentially, several other factors have also contributed. The cost of data storage has dropped substantially; enterprises are unwilling to delete any of their data. DATA is now a Corporate Asset and archived NOT deleted.
In the “Always On-Line” world all the systems accumulate huge amounts of data in real time. Analysts & experts want to analyze these mountains of data, popularly known as “Big Data”. The world today believes that in order to prosper and grow, they have to have the ability to “spot” emerging trends and patterns before they become mainstream.
This has led to a spectacular increase in the use of the Apache Hadoop Linux platform for Analytics. Data scientists across the world have been using this platform to manage and analyze “Big Data” since traditional SQL databases were not suitable in this environment.In the past, Microsoft provided interfaces to these technologies. To aid its own expansion and grab a market share in the emerging technologies Microsoft released R server for Hadoop & Linux and included R services starting with SQL 2016. They are further fortifying this position with the launch of SQL 2017 RC1.
Microsoft has introduced SQL Server 2017 RC1 which supports Linux. Interestingly Microsoft has chosen to support Red Hat Server & Desktop, Suse Linux & Ubuntu Linux flavors which cover most of the current installations. SQL server 2017 supports Linux and Active Directory services authentication for both Windows & Linux domain clients, allowing authentication of users across different platforms.
SQL server 2017 includes analytics using built-in Python & R services! Microsoft has always focussed on security. SQL server 2017 has TLS support so the data between SQL Server & clients can be always encrypted!
Some the features are not supported in this release of SQL server as yet. You can find details of the Microsoft release notes here.
MetaSys Software has been delivering high performance and secure database solutions using legacy SQL server version and recent undertakings are on SQL server 2016. If you are looking for web or database solutions, then please connect with us.

MetaBiz – A FileMaker based Custom App

Small and Medium Businesses have to deal with the several challenges

How to automate repetitive processes and become more efficient?

How to have the overall picture and know what needs attention and when?

How do we grow the business?

How to have all customer contact information distributed among employees in one place?

How do we keep track of all customer initiatives?

How can we grow revenue per customer? Grow revenue per employee?

Workflow Management Software and CRM Software helps to manage these. There are several products available. The challenge is that while packaged software is affordable they are expensive to customize. The average Small business finds the development of customized software expensive and time-consuming.

If you are struggling with these issues then choose MetaBiz as your CRM platform as it offers cost effective and easy to customize solutions.

‘MetaBiz’ a Multi-platform business management software has all the core functionalities required by small and medium businesses. It can be quickly customized to suit different business processes! MetaBiz is a business & workflow management software built using FileMaker Pro making it highly accessible across multiple devices like desktop, iPad, and iPhone. Web access is possible as much as is natively supported by the WebDirect feature within FileMaker.

Some of the business processes where MetaBiz can add value:

  1. Contact Management:

    This module offers more than just contact information. MetaBiz offers a solution through which you can organize all the details about a particular lead like contact details, communication History, invoices, project details, action details etc.

  2. Inventory planning and management:

    Entrepreneurs should have a deep understanding of demand and supply equation across all products. A business software can help in lowering costs, prevent errors in demand and supply of stock and speed up fulfilling client orders. MetaBiz can play an important role here. The software stores product catalog along with specifications and pricing details in the system. The inventory log gets automatically updated whenever an invoice is generated. This helps in proper inventory planning and management.

  3. Workflow Management:

    MetaBiz lets you streamline your workflow processes by setting up multiple actions. You can create alert for those who need to take a particular action, prioritize actions and mark them completed when it’s done, set deadlines and keep the process moving as per the timeline. This helps in effective workflow management. You can also view the ‘Actions’ in the calendar by checking on ‘Show on calendar’ settings.

  4. Business analytics:

    A business needs to take sound commercial decisions by effectively interpreting the available data to provide actionable insights. MetaBiz just does that. It helps in determining accurate project cost on the basis of billable hours and product costs.  Predefined reports based on timesheet, invoices, and actions can be generated to get a detailed perspective. Also, invoices within a specific date range can be accessed easily. Additional reports can be created as needed.

  5. User & Application Management:

    User management is important for setting up a secure system. MetaBiz User management system offers much more than just security. The software allows the Administrator to manage users and user roles, track their timesheets, set up and manage Company Info, Company logo, currency, Invoice templates and much more.

  6. Mail management:

    MetaBiz can be configured to send emails via Email Client or SMTP server or Outlook account. The Outlook Manipulator plug-in in the software allows all the Outlook data – Mails, contacts, calendar to be accessed from within the application. All critical client related information is available at one place and not residing in individual mailboxes. Data resides centrally and accessible to authenticated users of the system. This is an Add-On feature offered by MetaBiz.

MetaBiz can be customized according to the business requirement of the client. For more information get in touch with us or download the trial version.

How FileMaker 15 is transforming the business of building custom apps?

FileMaker provides custom apps across devices and platforms like iPad, iPhone, Windows, Mac and the web. The latest version of FileMaker has got enhanced features in terms of mobility, security, automation, ease of use and performance. These new features are simplifying the development of custom apps which can work across different platforms.

FileMaker’s core idea is to facilitate developers to create custom software solutions that are required by small and medium businesses. It provides an extensive array of ready-made templates. This reduces time to get started with the development and leaves more time to work on a more complex design and development. The enhanced features in FileMaker 15 will transform the business of building custom apps.

FileMaker Pro 15 is carrying forward the direction of the company to increase mobility with the help of some enhanced features. Some of these are:

  • An additional security feature i.e. the Concealed Box will help users to be more careful with the content. The Concealed Edit Box feature does not reveal the content typed in the field to the onlookers as they just see some dots.
  • Solutions which are frequently used can be added to the Quick Actions thus enabling a quicker way to access FileMaker solution.
  • The Portal In-Line Progress Bar, one of FileMaker 15’s new performance-based features, brings with it the separation of a layout’s non-portal and portal rendering tasks. This means users are no longer forced to wait for cumbersome portals to load before being able to interact with a window’s content.
  • FileMaker Pro 15 sends notifications for any kind of software updates. One can easily download and install the update within FileMaker Pro 15. This was not possible in the earlier version.
  • A Lot of improvements have been made in the Script Workspace. Script Errors are highlighted in red colour. So one can rectify the scripts immediately. There is an Unlimited Undo option which will give the users more freedom in creating something new and unique.

New features introduced in FileMaker Go 15 will give rich user experience for iOS users. Some of them are as follows:

  • Touch ID adds an extra layer of security to the existing features in your application. This will allow the users to login into the application using the fingerprint. For phones without the Touch ID sensors, there will be a device passcode.
  • The FileMaker app can be integrated with iBeacons. FileMaker Go 15 can associate data like text, image, video etc.  to the specific locations where iBeacons are present.

Your custom app can be further extended/linked to web using FileMaker/PHP API thus providing more opportunities.

MetaSys has a dedicated team of FileMaker developers, with experience in FileMaker 15. In case you have any queries related to FileMaker or looking for a quick solution catering to your business feel free to contact us.

PHP MYSQL: Web application development

Two decades ago, ‘PHP’ started out as a small open source project and today has evolved into a major scripting language. ‘PHP MySQL’ is now widely used for developing complex web applications. Here are some of the major advantages of using the PHP platform:

  • Easy to develop websites with interactive dynamic content.
  • PHP is fairly easy to learn
  • PHP Model View Controller (MVC) framework is now available to develop, manage and maintain complex web applications.
  • LAMP, XAMPP are some of the better options to deploy the applications quickly & cost-effectively.
  • PHP is compatible with all major web server platforms and web browsers.
  • PHP website development software can be easily embedded into an HTML file.

MetaSys Software has experienced PHP, MySQL developers who can help you with your requirements. Customers expect speed and often bounce rate goes up when websites load slowly. This can be effectively handled by experienced PHP developers at MetaSys. Our developers also use the  CakePHP Framework which speeds up the development process.

At MetaSys we offer PHP based web application development using MySQL and/or FileMaker as the backend for multi-tier architectural solution. With FileMaker PHP API it is quick to extend existing FileMaker solution to the web. A PHP MySQL being completely open source is a cost-effective combination and allows you to develop a solution customized to your business needs.

If you are looking to outsource PHP development projects then please feel free to contact us.