Technosoft Insider | November 2015 by bluedward

technosoft

INSIDER A monthly publication by Technosoft Consulting http://www.technosoft.co.id

ISSUE No 09 | VOLUME VIII

NOVEMBER 2015

THE TECH ISSUE HEADLINE

INSIDE THIS ISSUE

MICROSOFT ANNOUNCES CLOUD DATA AUDITING MADE EASY

The Most Popular Technologies In the Life Sciences Field

PAGE 02

3 Steps to Maximize Your Mobile Email Marketing

Microsoft has announced on its Azure blog that you can now use database auditing with Axure SQL Data Warehouse.

Heading to the Future

Three Ways Big Data Help Manufacturers Think Bigger I Must at Least Try

HEADLINE

Microsoft Announces Cloud Data Auditing Made Easy Microsoft has announced on its Azure blog that you can now use database auditing with Azure SQL Data Warehouse. Matt Usher, senior program manager of SQL Engineering calls this "A key security enhancement that removes barriers from businesses wanting to manage their data warehouse in the cloud." Introduced with Azure SQL Database, database auditing increases an organization's ability to track events and changes that occur within a database (e.g., updates to and queries against the data). Usher promises that, using a simple and intuitive configuration interface. "You can now have auditing up and running on your database within minutes." Why do you need auditing? By enabling auditing on an Azure SQL database, you immediately have a repository of valuable data that can serve several objectives:

Streamline compliance related activities. Many regulations (e.g., PCI-DSS, SOX and HIPAA) require an audit trail on data-related activities against the underlying databases. Gain Insight about database activity. By retaining an audit trail, you know exactly what activity is taking place on your database, by whom and when. This data can help to identify business trends or potentially indicate business concerns (e.g., a drop in activity over time in a geographic-specific database). Identify suspected security violations. Analysis of audit data can expose discrepancies and anomalies in data related activities across the organization, which in turn can help identify security incidents. Usher emphasizes that auditing and other security features cannot guarantee regulatory compliance. It remains the organization's responsibility to ensure that application design and database practices are implemented to adhere to required corporate or

industry security and compliance standards. What data is being logged, and where is it stored? When configuring auditing, you must specify an Azure Storage account to which your audit logs will be written. (Note: Azure Storage rates apply.) Once auditing has been enabled, an Azure Table is automatically created on that designated storage account, and records for selected events (based on what you configured) are written to that table. The figure below details the auditing architecture. The audit entries must be written to conform to a schema with predefined fields. Since the audit logs are written directly to your Azure Storage account, you entirely control access to this data. To view the logs, you connect to the Azure Storage account using your tool of choice, for example, Azure Storage Explorer or Azure's Excel dashboard and reports template, which can retrieve the logs using PowerQuery. The Power Query for Excel add-in is available as a free download for Office 2013/2016 customers.

While there is no word yet on exactly how Dynamics ERP and CRM solutions hosted in Azure will benefit from these improved capabilities, with Azure SQL becoming an approved component of new and upcoming releases like NA V 2016 and AX 7, more and better auditing will presumably broaden the appeal of Azure-hosted solutions and improve the case for Azure-based data warehouse development. Microsoft offers a Getting Started with Data Auditing tutorial among its Azure SQL Data W arehouse documentation.

Dann Anthony Maurno Msdynamicsworld

HEADING TO THE FUTURE

“Microsoft Techday” one of largest annual event of Microsoft Indonesia.

Technosoft joined “Microsoft Techday” one of largest annual event of Microsoft Indonesia. This event was held in Balai Kartini on Wednesday, Thursday, 7th and 8th October 2015. This year Microsoft focuses on openness strategy. Through the annual event held for the third time, Microsoft introduced the latest technology solutions, which allow developers and information technology professionals to more easily integrate applications based on non- Microsoft technology with Microsoft technology . Microsoft openness concrete form, among others, with Microsoft's latest project which is able to convert Android and IOS applications into the Windows application.

In line with our mission to be a world-class business technology partner, cooperation with Microsoft will continue to provide a plus for our customers, especially in cloud era, mobility and big data. In fact, as a cloud solution partners, we have started to provide cloud-based application services through the use of technology from Microsoft Azure. Therefore, there will be more individuals or organizations that are able to do many things and obtain the maximum usability of technology in various aspects of life. Amanda Erma Amanda.erma@technosoft.co.id

The Most Popular Technologies In the Life Sciences Field In the Life Sciences field the most popular technologies are as follows:

being adopted by medical device manufacturers in a big way.

Cloud technologies Medical device manufacturers are leveraging cloud solutions to gain greater business agility, faster deployments and even moving expenditure from CapEx to OpEx. Whether they are communication and collaboration tools or mission critical business systems such as enterprise resource planning (ERP), supply chain management (SCM) or customer relationship management (CRM) applications, every system is being considered for deployment in the cloud. Life Sciences manufacturers are also becoming more decentralised. Using cloud solutions to offload

Supply chain optimisation According to Gartner, the supply chain management software market grew 7.1 percent to reach $8.3 billion in 2012. While that’s solid growth, the real technology trend here is the continued morphing of manufacturing systems and supply chain management systems into single solutions. In fact, this trend is part of an even bigger trend in which best-of-breed business applications are being replaced by integrated business suite solutions. Manufacturers are increasingly turning to the supply chain to reduce cycle times, lower inventory (and related working capital), accelerate custom-

application installation, operation and support across locations can help to manage costs, improve services and rid a noncore competency. Lean manufacturing Since the 1990s, lean manufacturing has sought to eliminate waste and non-value added expenditures from anything in the production process that doesn’t create value. However, only in the last several years have the market leading manufacturing business systems fully enabled this production practice from a technology perspective. This technology enablement is now

er fulfillment and decrease distribution costs. ERP business applications are enabling these more strategic goals thanks to their strategic capabilities. Customer relationship management Manufacturing companies have a reputation of using CRM systems for the bare minimum. Essentially they are used as ‘systems of record’ for prospects and customers. However , in medical fields where patients are now more connect- ed with others in the same boat, are more informed and have more options than ever before, companies must rethink their CRM strategy, processes and software. For example, patients are now more

TECHNOLOGIES IN LIFE SCIENCES active in determining what medical equipment, surgical instruments and surgical appliances they believe are right for them. They are sharing their findings with other patients and entire online communities in social networks and internet forums. To meet these patients where they congregate, CRM software systems have evolved to include ‘social CRM’ tools that leverage social listening and collaboration apps to better identify and engage with patients where they digitally congregate.

Business intelligence Business intelligence (BI) solutions have evolved. Historical BI systems have fallen short of delivering (near) real-time information with easy–to-read analytics and actionable insights. But that’s changing. The scope of BI has advanced from simple dashboards on the frontend and sophisticated data warehouses on the backend to also include rapid and self- service BI. Like all technology trends, this advancement is heavily depend- ent

upon business process and, in this case, knowing what measures most impact business performance. Life Sciences manufacturers that can identify the most salient metrics, and deliver the right information to the right people at the right time, will empower those people to make better business decisions, and the company will improve its business performance.

continued from page 03 benefits of cloud, lean manufacturing, SCM, CRM and BI without needing to create and maintain complex system integration and software customisation.

Chandler Hutchisonin In ERP, ERP Applications

This change has led to increased adoption of packaged ERP systems because they are able to deliver the

IS EMAIL MARKETING DEAD?

3 Steps to Maximize Your Mobile Email Marketing The consensus among business leaders and socalled cuttingedge marketers who’ve gone all-in on social media, YouTube videos, podcasting, and other forms of digital communication would be, "Yes." However, that is not the case. In reality, the humble email hasn’ t gone anywhere. Quite the opposite in fact. Smartphone habits of consum- ers indicate that reading email comes second only to making phone calls. Moreover, email is still responsible for at least twice as many online conver- sions than social media. The confluence of email and mobile is especially noteworthy . As early as 2013, GetResponse discovered that "42 percent of subscribers delete emails that don’t display correctly on mobile phones." This means that to leverage the awesome power of email, you must get mobile. Here’s a simple three-step guide to get you started.

The Layout Mobile responsiveness isn’t just about changing the size and dimensions of your content to fit a smaller screen. It is also about reinforcing your brand strategy in order to enhance brand awareness. Mobile users are notorious for skimming emails, so utilize attention-grabbing images and copy. Don’t waste “mobile” Mobile users are notorious for skimming emails, so utilize attention-grabbing images and copy . Don’t waste valuable “mobile” real estate on pointless distractions. Naturally, your responsive email strategy must be executed with your audience in mind. However, here are some proven best practices that deliver effective results: Use single-column layouts that expand to multiple columns on desktops. Provide plenty of white space. Place your most important information above the scroll. Space out your links. Keep the header clean and avoid the first line of your email being something like, “Having trouble viewing this email. Click here to view in your browser.” Optimize for image blocking by

using compelling alt text and by testing plain text emails. Use web-safe fonts and a text size of at least 12 px Make your CTAs “clear, big and simple to click.” In other words, avoid what’s called “fat finger” syndrome. The Copy Balancing your gorgeous design layout with compelling copy is the second step in creating responsive emails. The keys here are brevity – keep it short – and paying very close attention to the “only three lines that matter”: the “from” field, the subject line, and the first line of text. Why? Because on a mobile device, those are the only three lines most subscribers will see. The Code If you already have an in-house IT team, good for you! If not, but you do have a basic under- standing of coding, you can take advantage of the numerous online templates to implement mobile email yourself. Litmus, for instance, outlines three core components of a responsive design that converts: Query: Defines which CSS Style to use based on screen size.

Styles: Based on the query above, a pre-determined style is activated. The HTML: Must mirror the elements specified in each CSS Style in order to take effect. However, if the mere mention of coding makes you break out in hives, fear not. Any email provider worth your time will allow you to create mobile- friendly emails without any technical hassles. Just be sure the provider’s “responsive templates” do more than simply resize your text. For instance, you should be able to preview your email across multiple devices before sending. More than half of emails ( 53 percent) are now opened on mobile devices, and that number is going nowhere but up. By combining the right layout, the right copy, and the right code, the benefits are impossible to ignore. Get mobile now.

Cynthia Johnson Entrepreneur

BIG DATA

Three Ways Big Data Helps Manufacturers Think Bigger Today, we talk about terabytes without blinking. And while Big Data isn’t anything new for manufacturers, leveraging it for competitive leadership is. Just ask Inteva Products, a major automotive component maker. The company stores thousands of audio files of these motor tests each day , gaining insights that enhance their future product development—insights their competitors lack. Leveraging Big Data allows manufacturers, like Inteva, to keep a much closer eye—or ear—on product quality, which is a true competitive advantage. Big Data is changing the way manufacturers operate and exe- cute on the shop floor . Let’ s look at just three of the ways it’s helping them think bigger than ever before.

Monitoring Product Quality Proactively In the recent State of Manufacturing T echnology Report, 31 percent of respondents reported they are either evaluating their Big Data needs and opportuni- ties, or plan to do so in the com- ing year. Manufacturers already provide incredible amounts of data on their products’ construction and testing, establishing up front that they’re producing high-quality products. Soon, they’ll be able to eliminate statistical process control from their quality control process. Instead, manufac-turers will use today’s increasingly affordable sensors to gather real-time data on every item that comes off the assembly line. Seeing the Future and Changing It Operational analytics are great at telling us what just happened and why. Manufacturers have been doing that kind of analysis for years. But they’re now using the predictive aspects of Big Data to monitor their operations against their quality

standards. Predic- tive analytics tell us what’s about to happen. Prescriptive analytics show us how to make machines do what we want. It’s one thing to look at the history of mainte- nance issues or failures on a specific machine. But today, manufacturers factor in so many other variables. They’re looking at a press and factoring in not only all the metrics around it—such as temperature and tonnage—but also who’s working on the machine, how long of a shift they’ve worked, what tools are in the press, and much more. Predic- tive analytics isn’t a new disci- pline. But until recently, its high cost made it practical for only very expensive products or equipment. New tools make predictive analytics a way of life for manufacturers of all sizes. And as the Internet of Things continues to mature, manufacturers are gathering more data automatically . Getting Customers into the Data-Collection Game For manufacturers, the data gather-

ing doesn’ t stop at the boundaries of the organization— it includes information collected at customer sites. Sensors come into play here, too. It’s becoming highly costeffective for manufacturers to embed sensors into the products they deliver to customers—and the data they’re getting back is worth the small investment in hardware. By extending the quality control process beyond purchase and throughout the life of their products, manufacturers can gather information that cata- pults their products to higher levels of performance, better design, and longer lifespan. This kind of innovation relies on a delivery agent that can put vast amounts of data at the fingertips of every stakeholder

Plex Manufacturing Success Stories

I MUST AT LEAST TRY In June 1985, two British mountaineers Joe Simpson and Simon Y ates made the first- ever climb of the West Face of the 21,000 foot snow-covered Siula Grande mountain in Peru. It was an exceptionally tough assault - but nothing compared to what was to come. Early in the descent, Simpson fell and smashed his right knee. Yates could have abandoned him but managed to find a way of

low- ering him down the mountain in a series of difficult drops blinded by snow and cold. Then Simpson fell into a crevasse and Yates eventually had no choice but to cut the rope, utterly convinced that his friend was now dead. In his subsequent book on the climb entitled "Touching The Void", Joe Simpson wrote: "As I gazed at the distant mo- raines, I knew that I must at least try. I would probably die out there amid those boulders. The thought didn't alarm me. It seemed reasonable, matter-of- fact. That was how it was. I could aim for something. If I died, well, that wasn't so sur- prising, but I wouldn't have just waited for it to

happen. The horror of dying no longer af- fected me as it had in the crevasse. I now had the chance to confront it and struggle against it. It wasn't a bleak dark terror any more, just fact, like my broken leg and frostbitten fingers, and I couldn't be afraid of things like that. My leg would hurt when I fell and when I couldn't get up I would die." The survival of Y ates himself was extraordinary. That Simp- son somehow found a way of climbing out of the crevasse after 12 hours and then literally crawled and dragged himself six miles back to camp, going three days and nights without food or drink, losing three

stone, and contracting ketoaci- dosis in the process, would be the stuff of heroic fiction if it was not so true. Indeed, six operations and two years later, he was even back climbing. All because, against all the odds, he tried …

“The secret of getting ahead is getting started” -Mark Twain

MIND BENDER : VISION A HEAD Lets get a vision ahead. Which Number Replace The Question Mark?

Submit the answer, your name and company to Technosoft Fax at +62-21-563-2078 or email to insider@technosoft.com.sg

SEPTEMBER 2015 Which car goes into which road?

Quiz Answer : Car 1 goes into road B, because 17 goes into 136 Car 2 goes into road C, because 81 goes into 567

Answer will need to be submitted by Nov 30th, 2015 by Technosoft Customer Only

Car 3 goes into road A, because 27 goes into 243

A Lucky participant who submits the correct answer will be granted either shopping voucher. Winner will be announced on the following month of Technosoft Insider Edition.

Congratulations to Mr Charles for answering it correctly. We will contact you soon by email or by phone.

TECHNOSOFT CONSULTING Address Graha Elok Mas Jakarta, 11510 Jalan Panjang 83 F-G Indonesia - Jakarta, 11510 Phone: +6221 565 8566 Fax: +6221 563 2078 Email: info@technosoft.co.id technosoft.co.id

Established in 1996, Technosoft is the leading cloud business solution provider for small & medium business. We have delivered over 18 years successful business solutions for more than 120 clients in more than 20 industries and 12 countries, by designing, implementing and managing technology solution that power and empower their business. With our business experience, combined with strong product and technical knowledge, our consul-

tants will analyze your needs and requirements and design and develop a business solution that is reliable, efficient and works for your business. Our commitment has always been to establish long term partnership with our clients to assist in increasing their efficiency, productivity and profitability through comprehensive IT solutions and services and business critical applications.