Small Business, Big Data

By | Business, Customer Success, IT and Engineering

I run a small software business, what do I do with Big Data?

Large volume of data streaming 0's and 1'sIt’s a buzz word that has spread across seemingly every industry, from healthcare to media analytics to education. Not only are leaders across industries still trying to wrap their heads around this concept, it seems like everyone is tripping over their competition to have “the most” — and the most advanced — big data first.

Read More

The Hunger Games Interactive Website: Cutting-edge Web Technology

By | For Developers, IT and Engineering, Microsoft

Internet Explorer hits the mark for web engagement with The Hunger Games Explorer. The film adaptation ofย Catching Fire, the second in theย Hunger Gamesย trilogy, doesn’t come out until November. But Internet Explorer partnered with theย Gamesย web team and RED Interactive Agency to give fans an edgy, interactive online portal that gives them everything they need to whet their appetite while they wait.

Hunger games website screen shotThe team built this site on some of the very latest web technologies, and it’s especially designed for the touch-screen, tablet experience. There’s all the regular stuff, like trailers and exclusive photos, but there is also content to keep users coming back. Fans can sign up and get their own District ID, and go behind the scenes on the making of the film via this futuristic online content portal.

The team took special pains to ensure the technology lives up to the demand for excellent user experience. This comes across in the responsive grid layout designed to be just as engaging no matter whether the user is on a mobile phone or tablet. “Taking a mobile-first approach [to back-end design] allowed us to ensure we used a single code base across multiple platforms and devices,” the behind-the-scenes website reveals. The grid was built using JavaScript.

Read More

Making the Enterprise Sexy

By | IT and Engineering, Izenda Reports

“The enterprise is sexy.”

That’s a debatable point, though the description has cropped up a lot recently.ย But what we are definitely seeing is anย increasinglyย sour taste among investors for consumer-focused companies like Zynga, Groupon, Color, and others, and a shift back toward the enterprise world as a more lucrative arena for investment dollars and business development.

This investor interest tends to run in cycles, the last of which for enterprise data came to an end with the demise of the 2000 dot-com era. We’ve been thinking it for awhile now: agile enterprise software companies are obviously well-equipped to adjust to market trends and aren’t locked into the old platforms that developers were tied to in the ’90s.

Read More

Microsoft Unveils a Superset of JavaScript Called TypeScript

By | IT and Engineering, Microsoft, Tips

At Izenda, we see many organizations shift fromย ASP.NETย and MVC to use pure JavaScript for their front end. The advantage is,ย the database developer can focus on creating a secure and scalable backend, while HTML designers can craft a slick UI.ย  We are focused on HTML5 being the front-technology for future versions of our ad-hoc reporting productsย while retaining a .NET backend that integrates with RESTful services. In this video,ย Anders Hejlsber, a developer at Microsoft, demonstrates a superset of JavaScriptย called TypeScript,ย which is designed to overcome the limits of JavaScript.

Embedded vs. Standalone Integration

By | For Developers, IT and Engineering, Izenda Reports

The Izenda platform can be deployed by integrating it directly into your application or on a separate standalone server.ย  While the majority of integrations are directly embedded, it is worth considering the standalone option in case of rapid deployments or situations where each tenant has an independent server or web site.

Embedded Integration

Methodology

  • Copy Starter Kit Into โ€œReportingโ€ folder of application
  • Use PostLogin() method to map user security

Advantages

  • A single, seamless deployment process for all application functionality
  • Better load balancing and performance across your entire infrastructure
  • Redundancy from being on multiple servers
  • Deep integration with multi-tenant, multi-role multi-user security models
  • Simple XCOPY deployment
  • Becomes a part of standard source control
  • Easy coordination between developers
  • Leverage existing security and compliance controls
  • Seamless user experience when navigating between application pages and reports
  • Supports easy publishing from dev, test or staging to production envionrments.
  • High performance transitions between reporting and application content

Disadvantages

  • Must be coordinated with the release cycle of other code
  • May require recompiling or republishing web application

For more details, download our Integration Overview

Stand-Alone Integration

Methodology

  • Install starter kit on independent server
  • Send secure user identifier on query string for single sign on or setup secondary login page
  • Look up user information from database inside PostLogin() method based on secure user identifer

Advantages

  • Can be deployed independent of a release cycle
  • Does not require recompiling or republishing base application

Disadvantages

  • Requires more code to integrate user security
  • May feel like a separate application to the user
  • Requires independent load balancing and redundancy
  • An additional web site and server to maintain
  • Additional windows licensing and hardware costs

Reporting on Salesforce.com Data with SQL Server

By | For Developers, IT and Engineering, Tips

A Simple Equation

In a dynamic business environment, it’s often unclear what type of marketing activities achieve results or what new experiments to try. In times when the stock market changes by double digits in a month, common wisdom doesn’t always apply.

Innovative companies experiment with new approaches, but need to be able to measure the results of small micro-campaigns or use historic trends to justify investment.ย We ran into a situation where we wanted to better understand how periodic follow up affected revenue.ย While this data was already in Saleforce.com, there was no way to rank and sort leads based on the number of tasks.ย The goal was to create a score to focus on the ones that had gotten the least attention.

Read More

SQL Server Denali to Accelerate Performance with Columnar Storage

By | For Developers, IT and Engineering

At PASS, Microsoft announced that SQL 11 (codenamed Denali) will support columnar storage. This announcement is incredible news for SQL developers wanting a simple solution to enabling rapid data analysis on their existing infrastructure. For some analytical workloads, columnar storage enables an order of magnitude faster performance.

Here is how it works (example from Wikipedia).

      1,Smith,Joe,40000;
      2,Jones,Mary,50000;
      3,Johnson,Cathy,44000;

A column-oriented database serializes all of the values of a column together, then the values of the next column, and so on.

      1,2,3;
      Smith,Jones,Johnson;
      Joe,Mary,Cathy;
      40000,50000,44000;

There are several advantages to this approach.

  • Only data in your report needs to be loaded and processed
  • Better compression
  • OLAP-like indexing, pre-aggregation and caching
  • More scalable data partitioning