Resources

Article

The Partitioning Paradox Solved

There is rarely a dull moment for IBM i administrators, as their operating environments continuously absorb and distribute new data. While this trend certainly keeps teams engaged, it also triggers fears that current protocols may not be enough to meet the challenges of tomorrow. First and foremost, there is often some doubt as to whether storage plans will be able to scale to manage the sheer...
Article

Easily Accessing Data on Remote Databases with SEQUEL

With SEQUEL you can retrieve information not just from your local IBM i, but also on other IBM i’s, SQL servers, Oracle, MySQL, and other remote databases. Once you have the remote host definition defined you are ready to convert data on other platforms into meaningful information right from your local IBM i. The ability to design views with SEQUEL SQL and translate them on the fly to native SQL...
Article

Get Started with Remote Database Access

Many organizations are expanding to use multiple platforms in their IT environments. There are many reasons for this: it can be due to company acquisitions or application vendor platform shifts, or when a department requires a certain software package with features that require a different platform. For example, many Customer Relationship Management (CRM) tools employed by sales teams reside on a...
Blog

Document Management: Security, Sanity and Plenty of Green

If you’ve been left waiting at the station when it comes to getting on board with an electronic document management system, now may be the time to catch your train. There are more reasons than ever to think about implementing document management in your business – not the least of which is more green.
Blog

Moving Documents Between IFS Folders

Because Webdocs maintains a separation between its internal file structure and the operating system’s, you can organize documents for your users in one manner, while organizing them on the IFS in an entirely different manner. This article takes you through the steps of reorganizing the folder structure on the IFS.
Article

Considerations For Securing NFS Shares For Use With Webdocs iSeries

NFS has long had a tentative relationship to security. As with its cousin, CIFS/SMB (more commonly know as Windows File Sharing), security was not an area of primary focus. The elements of security that exist are significant, but they are nontrivial to implement, particularly across operating systems and with third-party applications.
Article

How-To: Slice and Dice Your Data with Client Tables

In the era of big data users need to view their data in a way that makes sense and lets them dive deeper. SEQUEL’s Client Tables are an interactive solution, much like pivot tables, which allow users to reorganize and summarize columns and rows of data in a spreadsheet-like format both on a PC and on a mobile device or tablet. With Client Tables on the go, you can access data from your office, in...
Article

HANDS OFF! Saying Goodbye to Manual Data Access

Organizations today face an ever-expanding volume of information that must be analyzed and delivered to the right people. While the resulting business intelligence offers us insight into processes and customers, many companies still rely on practices and technology that aren’t suited for managing data on a large scale. As a December 2012 Financial Director article highlighted, 60 percent of those...
Article

Robot Best Practices

Wondering about best practices for automating your IBM i processes with Robot systems management solutions? Take a look at this list and get off to a good start.
Article

Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level

In an earlier article , we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use...
Blog

The 9 Server Sprawl Questions You Need to Ask

For budding companies, server sprawl may be just one of many growing pains—a temporary inconvenience for a greater good. But if you’re struggling to complete processes on time, stalling with the auditors, and jumping from server to server whenever an error occurs, it’s time to ask the tough questions.
Article

Staying on IBM i Sounds Like Money in the Bank

As the end of 2013 draws near, many businesses have budgets on their minds. Most companies will run year-end numbers to determine the full scope of their investments, and analyze what sort of changes can be made to cut costs and increase profit margins. As the number crunching begins, it’s time to consider numerous variables, including those that fall under the IT department. Decisions made within...
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

Data security has been a prominent feature in recent technology headlines as the costs associated with data breaches continue to escalate . Business and IT leaders alike have become all too aware of the need to protect valuable information, but questions of how - and to what extent protection is needed- are common sticking points. The rule of least privilege has been a long-held strategy that...
Article

SEQUEL Works with your Growing (BIG) Data

As you collect more information, your relational database files continue to grow and you’re faced with a challenging issue: how to handle all of that information efficiently and accurately, and how to overcome the obstacle of mining and delivering useful information without bogging down the system. Partition files are the solution to BIG DATA on IBM i because of: Improved manageability for large...