microsoft-teams-compliance.compressed-180x180 Blog

Reimagining Virtual Collaboration: Exciting Updates to Microsoft Teams

It’s strange to think that at the beginning of 2020, we had no idea of the turn the world was about to take. At the beginning, even the idea of quarantining and social distancing was confusing. Now, although it still isn’t ideal, most people have found innovative ways to connect. It’s incredible to see how […]

business-management-e1594933600340-180x180 Blog

How Digital Transformation is Changing the Face of Business Management

Cloudy with a Chance of Management Theory: How Digital Transformation is Changing the Face of Business Management What is business management? And how is it evolving as the world moves online? Along with overseeing operations, working face-to-face with customers, reviewing contracts, and pushing employees to their brightest performance, business management is also a key part of […]

work-from-home-180x180 Blog

Positive Aspects of Working from Home

Barely hanging in there while working from home, or has it been surprisingly easy? It’s been almost three months since the majority of the city, and the world went into lockdown mode, with every major industry grinding to a halt. From agriculture to the technology sector,  major losses have been experienced everywhere. The technology sector […]

Azure-synapse-01-180x180 Blog

Integrate Data Silos with Azure Synapse Analytics

The Roadblock for Digital Transformation It is clearly established that Digital Transformation is the key to success and even survival for organizations, even more so with the current global crisis due to COVID-19. 64% of executives believe that they have less than four years to complete digital transformation or they will go out of business. […]

Financial-analuze-powerbi-180x180 Blog

Why Implementing a Cloud Management Service is Crucial: The Benefits of CloudCheckr

Have you read extensively about digital transformation? And read all about how to take your business to the cloud, upping your game? We have, too. But we want to let you in on a secret weapon of sorts. Yes, you heard us right. It’s something that’s understated but will make a monumental difference in your […]

Digital-Transformation-Clooud-Adoption-180x180 Blog

Digital Transformation in a Nutshell: Understanding Microsoft’s Cloud Adoption Framework for Azure

What is digital transformation? We’re hearing a lot about it these days, and especially more in the seemingly strange “apocalyptic” era that’s taking place right now. There has never been a time in history that there has been such a need for the Cloud. As we navigate through this uncharted territory and wonder how on […]

Tech-Giants-Square-180x180 Blog

Keeping Up With the Times: The Technology Industry’s Response to COVID-19

In the whirlwind of the last few weeks, the world has turned to the digital side of things for solace. Working from home has only been possible through the use of technology such as video calls, data sharing, and the cloud. But how has the tech industry responded to help cope with COVID-19 and working […]

COVID-19-Support-180x180 Blog

Support For Our Community

Small businesses and individuals around the world are feeling the negative effect COVID-19 has had on the economy. Here at Optimus, the health and safety of our employees and community remain our priority. We have encouraged our employees to stay positive and give back to the community where they can. We started a donation program […]

tea-cup-laptop-apple-7360-scaled-e1585866114401-180x180 Blog

Playing Pretend: How to Keep Productivity Levels Up While Working From Home

When you are used to working from the office, staying home and trying to meet deadlines can prove to be a challenge sometimes. Various industries have been affected by COVID-19 in different ways, some more detrimental than others. We at Optimus are lucky to have the luxury of mobility; we can work from home. But […]

Microsoft-Green-Plan-180x180 Blog

The Greenest Cloud: Looking at Microsoft’s New Green Plan

With the material world being geared increasingly towards understanding climate change and carbon footprints, we often forget that the digital world contributes to fossil fuel emissions as well. Looking at the trends of today, we can predict that digital consumption will only increase over time, therefore adding to the carbon footprint of these companies. How […]

chart-close-up-data-desk-590022-e1583771218589-180x180 Blog

Starting a Data Project

It’s exciting to hear ‘Data is the new Oil’ or the ‘new Gold’ or the new ‘something valuable’. What I dread, though, is the day we hear ‘Data is the new fad and a complete waste of money’. I hope that day never comes! A lot will depend on how businesses approach data projects. Right […]

Intern-Focus-180x180 Blog

The Ultimate Guide to an Optimus Intern

Optimus Information offers an incredible internship program for software engineers unlike any other. Everybody at Optimus holds interns to the highest standard. There is no spoon-feeding or babysitting in the office. This 6-month program teaches interns the ins and outs of a variety of software and exposes them to experienced professionals. Along with technical skills, […]

monthly-budget01-180x180 Blog

4 Tips to Prevent “Run-Away” Azure Costs

Imagine you return to the office on Monday morning and discover a mysterious spike in your Azure consumption. You are now significantly over your monthly budget. As you feel a headache forming, you ask yourself: “Wasn’t moving to the cloud supposed to reduce spending?” Here are 4 easy and basic actions you can take to […]

IMG_20191114_150020-2-180x180 Blog

Corporate Social Responsibility at Optimus

What Community Service Means to Optimus: It’s undisputed that giving back is a core connector in large communities and companies. At Optimus, contributing time and funding to various causes in society is something that brings us all together, reigniting our humanity. Especially in a large company like ours, corporate social responsibility through is especially important […]

col-180x180 Blog

Technology and Collaboration in the Workplace

Collaboration is a top priority for many organizations and business leaders. At Optimus, collaboration is integral to office culture and how we evolve and stay flexible. Collaboration within the workplace elevates the group as a whole. We are better able to solve problems and serve our clients by incorporating technology into our collaborative practices.  Open […]

P2280470-180x180 Blog

The Optimus Family: Interning in Noida

From the moment we stepped on to the plane, there was always a looming fear of “will I fit in?” It was extremely intimidating to embark on a journey that we were both unfamiliar with. We knew that we would stand out and feel somewhat alone. However, what we thought we knew couldn’t be further […]

CanadianCloud-copy-180x180 Blog

Microsoft Makes a Significant Investment in Canadian Cloud

Microsoft Cloud Services has been a core contributor to the growth and development of numerous Canadian organizations and is steadily making more investments in Canadian Cloud. Recently announcing their first Canadian Azure Availability Zone in the Azure Canada Central region and an Azure ExpressRoute in Vancouver, this expansion will provide Canadian businesses greater access to […]

149-180x180 Blog

Technology is Becoming the Core to Every Business

By Goran Kimovski, SVP Global Customer Solutions (Onica) For many decades, technology businesses were considered a separate industry sector. These were typically companies whose revenue was dependant on developing technology-based products and selling those products to other businesses. The majority of other businesses were relegated to the role of technology consumers. Wanting to reduce their […]

ArtofLeadership-180x180 Blog

The Art of Leadership for Women

Jessalynn Tran is the Sales & Marketing Coordinator at Optimus Information Today, more women are moving up the corporate ladder and breaking glass ceilings. We are raising a generation of girl bosses and have even more available opportunities. However, women in leadership roles will face many challenges in this evolving world that will require them […]

Automated-Testing-Solution-on-Azure-2-e1554082144564-180x180 Blog

Automated Testing on Azure DevOps

If you are looking for automated testing for any of your applications and would like to integrate it with your Azure DevOps infrastructure, Optimus Information has a “ready to deploy” Test Automation solution for you. Our Azure DevOps based test automation solution uses the latest Azure CI/CD features and offers the following functionalities: 1. Configure […]

Optimus-Mobile-App-Security-180x180 Blog

Mobile App Security: In Search of the Silver Bullet

In October, 2016, the use of mobile devices to access the internet surpassedi that of desktop computers. Today, more than half of internet access is done with phones and tablets. What, Me Worry? Given this, you might assume that mobile apps would be designed with high levels of security or that security itself would be […]

Growth-500-Logo-2018-Blue-180x180 Blog

Optimus Information Makes the 2018 List of Fastest Growing Canadian Companies

Canadian Business unveils 30th annual list of Canada’s Fastest-Growing Companies Vancouver, BC (September 13, 2018) – For the second year in a row, Canadian Business and Maclean’s has ranked Optimus Information on the 30th annual Growth 500, the definitive ranking of Canada’s Fastest-Growing Companies. Produced by Canada’s premier business and current affairs media brands, the […]

iStock-607969272-180x180 Blog

DevOps: Embrace the Culture and Speed App Development and Deployment

The past decade has seen some tectonic shifts in how application software is developed and deployed. Traditional waterfall methods, which siloed teams and produced apps that mostly worked well (until they didn’t), gave birth to Agile, a fresh new way of including the various design, development and production teams in a holistic way while creating […]

mobilefutureforward-180x180 Blog

Connected Intelligence through Exponential Ecosystems — Mobile Future Forward

Connected Intelligence through Exponential Ecosystems That’s the theme of this year’s Mobile Future Forward gathering in Seattle this October. Visionaries, developers, CEOs of tech firms – essentially, “the best and the brightest” in mobile technology – will be attending, and so will Optimus Information. “We’re thrilled to be involved in this symposium because we’ll be […]

iStock-506999580-180x180 Blog

Two Reasons to Celebrate – The IAMCP Honours Optimus Information at Microsoft Inspire 2018

“I’m delighted to see Optimus Information recognized at Microsoft Inspire,” said Awards Chair and former IAMCP President, Gail Mercer-MacKay. “Not only is the company creating incredibly sophisticated and innovative solutions for their customers, but they are also transforming their own workplace to be more inclusive. It is a testament to the leadership at Optimus that […]

iStock-871030872-180x180 Blog

Evolution or Revolution? The Power of Microservices in Azure PaaS

Constant business pressures are demanding more and more from software developers, and they are responding with some remarkable new technologies. As always, necessity is the mother of invention. Developers are pioneering new architecture that can break down apps into small, independent components, allowing those individual parts to be updated when necessary with speed and reliability, […]

data-lakes-180x180 Blog

Data Lakes – Deep Diving into Data Like Never Before

As data analytics, machine learning and AI continue to rapidly evolve, so, too, does the need to acquire, access and catalogue large amounts of data required to power data analysis. This has given rise to something called a “data lake”. The standard model for data storage has been the data warehouse but in a traditional […]

iStock-870784968-180x180 Blog

API Testing: Do It Right and Automate

Software development in 2018 looks nothing like it did a decade ago. Developers have been driven to find faster and more efficient ways to produce a finished application. Customers demand better products, and market pressures mean get your apps out now or risk annihilation from competitors. This means abandoning the waterfall method of software development […]

iStock-660673442-180x180 Blog

Work/Life Balance: Stop Trying to Achieve It

Work/life balance: a concept that’s been drilled into our brains and pushed on us for years, yet a majority of people struggle to achieve it. In today’s fast-paced and ever-changing technology environment, the idea that someone can balance their work life and personal life with a perfect 50/50 split is a tough goal. Maybe it’s […]

Welcome-to-Optimus-1-180x180 Blog

Behind The Scenes at Optimus: My Experience as an Intern

Excited and afraid, I boarded a plane, leaving my family, friends and city life behind. I was about to embark on what would be the most challenging, educational and rewarding experience of my life: a four-month internship at one of Canada’s fastest growing IT firms, Optimus Information. The interesting part, however, was that my internship was not to take place […]

optimus-mark-qanda-blog-180x180 Blog

Q&A About Open Source and Azure with Mark Godfrey of Microsoft

Mark Godfrey is a TSP with Microsoft Canada. Recently he spent time presenting to an audience of more than 200 application developers about Open Source, Azure and Optimus Information at the Vancouver Microsoft Technology Summit Open Source is everywhere at Microsoft. Check out what’s running on Microsoft Azure today. Q: Welcome Mark, and thanks for […]

ryan-speaking-at-linux-on-azure-180x180 Blog

Microsoft Technology Summit – Open Source and Azure and the Optimus Test Harness

Ryan O’Connor presenting the Optimus Test Harness at Microsoft Tech Summit in Vancouver It was both a pleasure and a privilege to represent Optimus at the Vancouver Microsoft Technology Summit last week. The tech summit is one of my favourite events. It attracts a lot of people – especially those who are working individually or […]

opt-cs50-2-180x180 Blog

How a Global Puzzle Competition is Changing Software Application Development and QA Testing

Teams of people including students, interns, software application developers, QA testers and more from around the world competed recently in the third annual CS50 Puzzle Day, sponsored by Harvard University. CS50 is a Harvard-developed academic course that explores the theory of computer science, its purpose and intent and while the competition was originally created for […]

business-leaders-collaborate-boardroom-180x180 Blog

Digital Collaboration: Superhighway to Innovation and Economic Transformation

Federal and provincial governments in Canada along with the private sector are undertaking a major initiative to establish the nation as a global centre for digital transformation and innovation, generating 50 thousand jobs and boosting GDP by some 15 billion dollars over the next 10 years. 1.4 billion dollars is being committed in a collaboration […]

brain-thinking-about-design-180x180 Blog

Think Big: How Design Plus Data Will Change Your Business

Is design thinking catching your attention? It should. Data insights not available before now can transform your business models and allow you to lead in your industry when you incorporate elements such as predictive, mobile dashboards and machine learning. This wave of change is forcing data architects to re-think and re-design how programs and applications […]

cloud-cooking-change-180x180 Blog

How Cloud is Cooking Up Change in the Restaurant Industry

As more and more restaurant owners look for ways to cut costs, improve customer service and drive loyalty initiatives, application modernization including cloud applications, mobile apps and predictive data modelling are featuring at the top of their personal “must do” menus. Software companies and ISVs that serve the restaurant and hospitality industry are in a […]

Game-Changers-180x180 Blog

Game Changers: The Role of Big Data in the Future of Credit Unions

Discover how credit unions are embracing data analytics and machine learning to improve services and find new business opportunities.

performance_testing_wordcloud-180x180 Blog

Types of Performance Testing and the Best Tools for the Job

In the abstract, it’s easy to think of testing a piece of software as a single set of actions. Within the industry, however, it has become common practice to look upon performance testing as a multifaceted task. The process includes: Load testing Stress testing Endurance testing Scalability testing Volume testing Spike testing Each phase has […]

Software-as-a-Service-180x180 Blog

Test Automation for SaaS Products

Software as a service is a popular delivery model for various business application domains including content management, service desk applications, accounting, invoicing, human resource management, CRM and ERP. Versus long-term software licensing of client packages, cloud delivery of SaaS enterprise apps offers greater convenience, lower risk and the economic advantages of reduced capital and operational […]

Optimus_App-Development_on_Azure_Infographic-Avatar-180x180 Blog

Infographic – Why Move Your Application Development to Microsoft Azure?

At Optimus, we’re seeing more and more of our clients take advantage of the cloud. Applications once thought impossible to move to the cloud due to scale, complexity or simply because of their mission-critical nature are now being migrated successfully. Our most recent infographic walks you through why enterprises are moving to the cloud, and […]

Testing-in-an-Inerconnected-World-Recap-180x180 Blog

Optimus Breakfast Series: The Do’s and Don’ts of Software Outsourcing Recap

The most recent installment of the Optimus Breakfast Series took place yesterday morning, Oct. 5th, 2017. This event hosted an engaging discussion on when and how to outsource software projects effectively. If you missed it, stay tuned to the Optimus blog for the complete video recording! For those that attended, there were excellent networking opportunities […]

PROFIT-500-Logo-2017-BLUE-square-180x180 Blog

Optimus Information Ranks on the 2017 PROFIT 500!

Vancouver, BC (September 19, 2017)  Canadian Business and PROFIT has named Optimus Information Inc. to the 2017 PROFIT 500! The ranking of Canada’s fastest-growing companies is based on five year revenue growth. Optimus was ranked No. 336 on the 29th annual PROFIT 500, with five-year revenue growth of 168%. “It is never easy to earn […]

Dos-and-Donts-3-180x180 Blog

Azure Architect Wouter van Eck’s Do’s & Don’ts for Azure Cloud Application Development

The Azure Cloud is transforming application development as we know it. Applications that would have been too costly and time-consuming to develop on legacy infrastructure take a fraction of the resources on Azure. Azure also provides the ability to process big data, further expanding an organizations’ options for innovation in application development. However, developing applications […]

Graph-Bars-non-transparent-180x180 Blog

4 Ways Azure is Rising to Meet Data Warehouse Demands

In today’s data-first world, IT infrastructure is the foundation for strategic decision-making, with companies requiring larger quantities in shorter periods of time. This is putting the traditional data model – where data from systems like CRM, ERP and LOB applications are extracted, transformed and loaded (ETL) into the data warehouse – under pressure. The problem […]

Cloud-Computing-cap-180x180 Blog

Does Your Data Warehouse Belong in the Azure Cloud? Here are Some Things to Consider

It’s no secret: Microsoft Azure is hot right now. This is demonstrated by their 97% growth in Q2 2017. With more organizations migrating their data infrastructure to the cloud every day, some companies are asking themselves: does my data warehouse belong in Azure? While there’s no simple answer to this question, there are some ways […]

Inforgraphic-Avatar-180x180 Blog

Infographic – The Modern Data Warehouse Framework

Check our latest infographic, The Modern Data Warehouse Framework! As organizations are collecting and processing increasing amounts of data from a growing number data sources, data systems must evolve to keep up. In order to make the best data-driven decision possible, you need to reimagine the way you look at data warehousing. We took a […]

Cloud-Development-180x180 Blog

Three Trends Influencing the Rise of Application Development on Microsoft Azure

In today’s always-on, data driven world, organizations will either disrupt, or be disrupted. For those that choose the former, a fast application development cycle is critical for success. This is why companies are turning to Azure for application development. Azure can help cut costs and reduce development wait and integration time. Additionally, the flexibility of […]

Screen-Shot-2017-07-11-at-3.45.40-PM-180x180 Blog

Optimus Breakfast Series: Testing in an Interconnected World – Video

How to Test Applications as They Become Increasingly Universal In case you couldn’t make it to Testing in an Interconnected World on June 13th, 2017, you can watch the entire panel discussion here. Be sure to sign up for our newsletter and follow our events page to register for the next event. Panelists: Steve Whitfield – […]

Testing-in-an-Inerconnected-World-Recap-180x180 Blog

Testing in an Interconnected World: Event Recap

How to test applications as they become increasingly universal In case you missed it, the latest instalment of the Optimus Breakfast Series went off Tuesday morning, June 13th, 2017. The event brought together three of the top software testing executives from Vancouver’s leading companies to talk software testing and the complexities they face in our […]

Power-BI-for-Mobile-1-180x180 Blog

Power BI for Mobile: Take Your Data on the Road

One area where the Power BI software stack really shines is the mobile space. The Power BI product line includes three apps: one for iOS, Windows Phone and Android. These apps allow you to take anything you can generate in Power BI and make it readily available to any stakeholder with a mobile phone or […]

Cloud-180x180 Blog

Data Analytics in the Cloud: Where to Start?

An enterprise-wide data analytics system pulling data from multiple sources, correlating and presenting results in relevant, insightful visualizations to enable prompt, informed decisions is the dream of many organizations. Those in the lead already reap the benefits of faster, high-accuracy, proactive decisions that data analytics provides. Getting to that point requires exquisite planning and execution by stakeholders […]

azure-sql-cloud-copy-180x180 Blog

Cloud Data Warehousing with Azure SQL

If you are running an on-premise data analytics stack on Microsoft’s SQL Server, but running into maintenance, cost and scaling issues, you can consider moving your data system to a cloud-based database service such as Azure SQL Database. Especially for your first data analytics stack, Azure SQL Database provides low startup costs with the ability to easily expand […]

iStock_000011998528_Large-v4-180x180 Blog

Announcing Transform 2016 – A data analytics breakfast event

Optimus is excited to bring you Transform 2016 on Oct. 20th 2016! Transform 2016 will bring three executives from leading Vancouver organizations to talk about how they are using data analytics to grow and transform their business. Learn how they used analytics to uncover the story their data is telling, the problems that it uncovered and how […]

Bar-Chart-copy-180x180 Blog

SSIS Best Practices

SSIS represents a complete rewrite of its early predecessor Data Transformation Services. Usability, parallelism and performance have all been vastly improved over the years resulting in an SQL Server component aimed at high-volume, high-performance ETL applications. Here are several additional tuning steps that can further increase SSIS performance for your particular jobs. Managing Parallel Execution […]

Monitor-Graph-180x180 Blog

Power BI vs QlikView

In the world of business intelligence, putting the right tools in the hands of the right people is critical to success. Two of the most popular tools in the industry today are Microsoft Power BI and QlikView. Both provide modeling capabilities and allow you to generate visualizations and dashboards, but there are key differences between […]

static1.squarespace-copy-180x180 Blog

Power BI for Office 365

If you’re like many folks in today’s business world, there’s a good chance you’re already using Microsoft’s Office 365 software suite. You may even already feel like you have a fairly data-centric approach to using Office, especially if your company is a heavy Excel user. Putting all that information to use, however, requires powerful data […]

graph-icon-180x180 Blog

Steps to Getting Good BI Requirements

Half the battle for many projects is getting started. BI projects are no different in that respect. A critical phase in realizing your BI project vision is developing thorough project requirements in clear, crisp, implementable and measurable terms. The temptation is to rush this phase, which often produces excessive churn or even failure as unguided […]

system_integration-copy-180x180 Blog

How SSIS Fits into an ETL Process

MicrosoftSQL Server Integration Services – SSIS – is a common solution for many organizations’ data management requirements with regard to their Business Intelligence systems. Specifically, SSIS and SQL Server together streamline Extract, Transform and Load – ETL – operations on data warehouses. The process is essential to providing efficient, accessible data flows to BI system […]

cloud-computing-circuit-180x180 Blog

BI: Cloud vs On-premise

The model for how companies acquire and field software for business intelligence purposes has changed dramatically in the last five years. One major factor driving this change has been the emergence of cloud-based computing options and software as a service. Modern operations are increasingly comfortable having large amounts of their data, processing capacities and even […]

Product-Comparison-1-180x180 Blog

Product comparison: Power BI, Tableau, QlikView and SAP

Few topics that come up during a business meeting are at once as simple and as challenging to address as the question of how the company is doing. It wasn’t long ago that someone involved in the process would toss around printouts of a few Excel sheets and declare the discussion over. In recent years, […]

HiRes-180x180 Blog

Best Practices for Successful Business Intelligence

Few, if any, companies doubt BI’s value to their internal and customer-facing operations and the crucial role it plays in making accurate, lightning-fast tactical and strategic decisions that affect the business’ competitive position. The difficult bit is ensuring that BI’s deployment in your company is fetching the best data, crunching it in a timely fashion […]

Computer-chip-square-180x180 Blog

What is Business Intelligence?

Modern companies are compiling a huge amount of data on a daily basis. Answering the question of what to do with all this information is the domain of business intelligence. BI covers a large range of functions within a firm, including everything from database compilation to the creation of presentation materials. BI tasks typically center […]

dos-and-donts-180x180 Blog

Dos and Don’ts of Software Outsourcing

Outsourcing software development can be a great way to save your company or organization time and money. However, if done haphazardly, it can also become a source of great headaches. It’s easy to make common mistakes, such as not clearly defining goals or expecting the process to magically produce results. It’s much harder to manage […]

online-project-management Blog

Tactical Outsourcing vs Strategic Outsourcing

The term outsourcing scares people for various reasons, but there is no reason that it should. Outsourcing is very effective for certain situations, especially when developing software solutions. For a company to grow its internal IT department, it must search for a qualified candidate and go through the long process of interviewing, hiring, and training […]

World-Map-Square-180x180 Blog

Pros and Cons of Pure Onshore, Pure Offshore and Hybrid Model Outsourcing

North American companies contemplating outsourcing some or all of their software development have more options than ever before. They can choose from among onshore outsourcers close to home, offshore services halfway across the globe or a blend of these in unique combinations. In a few situations, which model to choose may seem straightforward, however, each […]

36950622_thumbnail-180x180 Blog

What to Look for in an Outsourcing Partner

Bad experiences with outsourcing providers are often traceable to badly designed selection processes or the use of deficient selection criteria. Whereas, you can find ample guidance online on how to build a robust selection framework, we will share the most important vendor attributes for comparing and contrasting outsourcing companies to ensure you select one right […]

Trends-1-180x180 Blog

Top Ten Software Development Outsourcing Trends for 2016

Originally, the primary motivation to outsource software development was to achieve lower labor costs, but continuing and emerging business and technology trends in 2016 are leading to new client requirements on outsourcers. When choosing an outsourcing partner, more and more businesses are looking for closer alignment to their business goals, flexibility demands and quality requirements. […]

protecting-intellectual-property-in-a-global-rd-marketplace-180x180 Blog

Tips on Keeping Your Intellectual Property Secure When Outsourcing

Security has been and continues to be one of the top concerns for enterprises considering outsourcing some or all of their software development or IT functions. Within the sphere of security concerns, one risk especially stands out, which is the potential to lose control over your enterprise’s intellectual property. Reputable outsourcing vendors would not remain […]

cloud-based-test-automation-tools-and-benefits-180x180 Blog

Cloud-Based Test Automation Tools and Benefits

Acquiring and maintaining in-house testing platforms for even small-market software applications is expensive and time-consuming. If your software products include mobile applications that support thousands or millions of users, then the sheer scale of testing can overwhelm even well-stocked IT departments. Fortunately, with the availability of a multitude of cloud-based testing environments, there is a […]

oracle Blog

Include more than 1000 Values in Oracle IN Clause

In Oracle we can’t include more than 1000 values in the “IN” clause. To get around this limitation, you divide the string of comma delimited values to be included into two or more parts using SUBSTR or through any similar other function and then these new strings should be placed in the IN clause of different SQL statements that are later combined using the UNION operator. Sample Code First create two hidden parameter that include the initial first and second half of the selected values of the parameter. For this write a custom code can be used. Sample code to break the parameter into two hidden parameter of half the original length. Sample Query New we use two SQL queries including the two hidden parameters joined by the UNION operator Obviously, this example breaks when you get to 2000 values, but it is presented here as a sample approach that can be easily modified to suit more advanced situations.

The post Include more than 1000 Values in Oracle IN Clause appeared first on OptimusBI.

windows-azure Blog

Guide to Migrating a .NET Site to Azure

Microsoft generally does a good job of integrating its products and that is mostly true for .NET and Azure. Migrating a .NET site to Azure is relatively easy with a few details that need to be looked after. Here is a step by step guide to migrating to Azure. Open the web site project Before you […]

pos-testing Blog

Test Scenarios for Credit Card Payment Through a POS Application

Point of sale applications need to handle a wide variety of transactions like cash, debit cards, credit cards, gift cards and loyalty cards. Credit cards play an important role in payment for anything purchased. Below are some of the most important scenarios which should be tested with any credit card payment solution when integrated with a POS application. Prerequisites Credit Card Configuration: Includes configuration of card length, card range and card type (VISA, AMEX, MASTER etc) Merchant Configuration: A merchant needs to be configured who is authorized to accept card type payments Credit Card Processor Configuration: Credit card processor needs to be configured to process credit card payment (e.g. Mercury Payment System or Lynk, etc.) Test Scenarios Capturing Card Details: Following areas should be tested while capturing card details. Credit card number : Test card numbers using the correct length and range and card numbers that are outside the correct length and range. Expiry date: Test valid expiry dates, invalid expiry dates and invalid date formats. CVV number: Test valid CVV numbers , mismatched CVV numbers and blank CVV numbers. AVS code: Entering AVS details for configured numeric or alphanumeric formats. Card reader to capture card details: Test swiping of cards from both sides and chips. Encryption: Verify that captured card numbers are properly encrypted and decrypted. Authorization: Once card details are captured, they are sent to processor to be authorized. Following areas need to be tested during authorization. Authorized amount: Test that the correct amount is being authorized. Receipt printing: Test that merchant and customer copies of the receipts and any vouchers print properly. Receipt details: Check that the receipts are printing the proper date, time, card details, authorized amount etc… Response code: Test that the correct response codes are being returned for approved, declined, on hold and all other transactions. Settlement: Once the payment is done following things should be tested: Reprinting receipt: Test that you can reprint the receipt for a closed transaction. Void credit card’s payment: Check that you can void a payment before posting it and that after posting a payment voiding is not allowed. Verifying report: All information regarding each credit card transaction should be reflected in reports. Any adjustments made in closed checks should be reflected in the report.

The post Test Scenarios for Credit Card Payment Through a POS Application appeared first on OptimusQA.

performance-testing Blog

Report Performance Optimization: Data Quality

Query optimization is the first place everyone looks when doing performance optimization on reports, but there is more to performance optimization than just optimizing queries. Proper use of tables, joins conditions and wide data ranges are all solid techniques for optimizing queries. However, data quality is another factor in report performance. Let me share an example from an organization we were working. The company was using the project management module of an ERP system to track hours, billing and expenses. They had more than 500 projects in the system and ran a weekly report that is configured to run on the database of active projects to provide detailed information on hours consumed, capacity, project status and resources breakdown. The problem is that it takes one hour to run the report and requires a lot of computing power even after query optimization. The report is developed to show the information for only active projects in the week. There is no process of closing and archiving the completed projects on regular basis. As a result, the query had to run through all the projects that are marked active, even though these are actually completed. The solution to this performance optimization challenge was not query optimization in this case. Improving the process of changing the status of projects and archiving them resulted in the performance improvements that they needed. This resulted in better data available in the database and less time and computing resources to produce the query output. After implementation of the process, the organization has seen significant decrease in the query run time. The lesson learned here is that report performance optimization isn’t always about query optimization.  The people that touch data at any point can also have an effect on performance.

The post Report Performance Optimization: Data Quality appeared first on OptimusBI.

calabash1-180x180 Blog

Writing and Coding Calabash-Android Test Cases

Building on my calabash-android setup post, I want to explain how to start writing calabash-android test cases in the ‘feature’ files and their respective code in ‘step definition’ files. After you install the Calabash-Android gem then a directory structure is saved at the following path: [code language=”text”]C:Ruby193librubygems1.9.1gemscalabash-android-0.4.3[/code] In this folder: “C:Ruby193librubygems1.9.1gemscalabash-android-0.4.3libcalabash-androidsteps” you should find various […]

pos-testing1-180x180 Blog

Testing a Point of Sales Application

Testing point of sales (POS) systems is something that we have done a lot of here and I wanted to share an overview of what POS testing entails. A POS is a computer that is used instead of an old fashioned cash register. It’s more like a personal computer connected to a receipt printer, cash […]

test-automation1-180x135 Blog

Four Common Pitfalls of Test Automation Projects

After helping out with test automation projects for a number of different organizations, I have identified several common pitfalls of test automation projects that I often see. Avoiding making these common mistakes will certainly accelerate the project momentum and make the automation experience more rewarding. The first two suggestions address the managerial pitfalls while the […]

windows-azure-460x180-180x180 Blog

Using Azure as the Back-end of your Mobile App

When building a mobile app chances are you’ll need some sort of server in the back-end to manage security, data, and likely to integrate with another system. We see a lot of potential in using Windows Azure for this purpose. What is Windows Azure? Azure is Microsoft’s answer to the cloud. It’s a scalable, pay-as-you-go […]

traceability-matrix-210x135-180x135 Blog

What to Include in a Software Testing Traceability Matrix

A traceability matrix is an essential tool for any thorough software tester. It should be referenced throughout the entire software development life cycle to bring transparency and completeness to software testing efforts. Testing Requirements Traceability Matrix In simple words, a testing requirements traceability matrix is a document that traces and maps user requirements, usually requirement […]

global-outsourcing Blog

Questions to ask when outsourcing technology services

In almost two decades of dealing with clients in the IT outsourcing industry, I have answered almost every hard question imaginable for prospects worried about finding the right IT outsourcing partner. Based on my experience, I would like to share the top five questions you should ask outsourcing vendors like us before making a decision. […]

Technical-Debt-Dont-Go-Bankrupt Blog

Technical Debt Questions and Answers with Philippe Kruchten

The following are questions and answers following the Technical Debt: Don’t Go Bankrupt breakfast session with Philippe Kruchten put on by Optimus Information Inc. There is a 52 minute video of the presentation. You can also download the presentation slides on Prof. Kruchten’s site including the substantial reference list. The November 2012 issue of IEEE […]

Technical-Debt-Dont-Go-Bankrupt Blog

Technical Debt: Don’t Go Bankrupt

Technical debt is simply defined as software engineering issues that affect future decisions and total cost of ownership. Technical debt ranges from such things as poor code, which is easily detected and fixed, to structural and architectural choices as well as technological gaps. As with regular debt, the cost of technical debt compounds over time; […]

cloud-testing-180x180 Blog

Testing Infrastructure in the Cloud: Is it Right for Your Business?

Many clients are now asking about leveraging cloud-based testing infrastructure. Here are some of the key benefits to this approach.

MS-Gold-BI-460x180-180x180 Blog

Benefits of Working with a Microsoft BI Gold Partner

Recently we were certified as a Microsoft Business Intelligence Gold Partner in Vancouver, British Columbia. This new partnership provides many benefits for our clients, which include: Access to Microsoft software and in-depth product information that helps to guides clients to the right tool and strategy for their Business Intelligence initiative. Various training materials, which help […]

Redmine-180x180 Blog

Scrum-y Tools

As a QA Professional, I’m always looking to be in the know about tools and techniques companies use to deliver software.  I’ve worked in companies that have used Waterfall, Agile, and a mix and match of everything in between. With that, I’ve been exposed to a variety of tools to track testing and Scrum project […]

Windows-Azure Blog

Windows Azure: Move your applications to the cloud

Many clients have been asking us about the Windows Azure platform so we’d like to take this opportunity to give a brief overview and let you know what we’ve been working on. The Windows Azure platform is a platform-as-a-service offering from Microsoft that competes with Rackspace, Amazon Web Services, and Salesforce. It is everything you […]

data_center Blog

Benefits of Cloud Computing: Where are the Opportunities

Amazon, Google, Microsoft, and now Apple are battling for market dominance in cloud computing. This fast-emerging segment has companies of all sizes measuring the benefits of cloud computing. The big players are offering services ranging from software-as-a-service (ie: hosted email), to platform-as-a-service (ie: virtual desktops), to storage and computing as a service. Companies large and […]