How to Load Informix DB2 Using SSIS

Can Microsoft SQL Server and Informix DB2 environments integrate together? The answer is YES!! I have received an increasing amount of questions concerning wanting to cross platform ETL development work between the two. Driven from these questions, I want to dig deeper into regards to manipulating data between Microsoft SQL Server and Informix DB2.

Continue reading How to Load Informix DB2 Using SSIS

For analytics users, in-memory databases may prove useful

Experts have lauded in-memory databases (IMDBs) for their ability to improve data mining and analysis endeavors. Database administration professionals have encountered IMDBs more often now than in recent years, primarily because big data analytics have become so popular with businesses.

Continue reading For analytics users, in-memory databases may prove useful

Retailers use business intelligence to optimize supply chain

Due to the prevalence of omnichannel retail, merchandisers are obligated to satisfy the inventory fulfillment requirements of brick-and-mortar stores and consumers. Instead of using human resources to scrutinize the distribution process, commodity-based companies are hiring database experts to implement business intelligence tools capable of providing actionable information regarding the supply chain.

Continue reading Retailers use business intelligence to optimize supply chain

College finds success with Oracle’s business intelligence tools

Professionals who believe that business intelligence is simply another buzz phrase thrown around by database experts are often left at the bottom of the totem pole of corporate production. These naysayers often perceive analytics tools to be an extraneous expense, but the technology is in fact becoming a necessity for corporations intent on surviving in an increasingly competitive market. 

Continue reading College finds success with Oracle’s business intelligence tools

Public sector may benefit from language analytics tools

Government entities have been expanding their network capabilities, consulting database experts and deploying new technologies in an effort to bring better services to constituents. As the United States consistently engages with foreign nations, agencies frequently encounter language barriers when opening communications with diplomats. Furthermore, immigrants new to communities may not be able to accurately express concerns to state, town or city officials. 

Continue reading Public sector may benefit from language analytics tools

Sports communities using data analytics

Professional sports franchises and even some members of the National Collegiate Athletic Association are turning to data analytics tools in order to better predict the outcome of competitions. Database administration services employed by these organizations often monitor programs capable of developing training programs and game plans based on algorithmic conclusions. 

Continue reading Sports communities using data analytics

Creating Dynamic Data Sources in SSRS

For my first blog post, I decided to write about a cool little project that came across my desk a few months ago. The request was to create a SSRS report that could be used to insert records to a database by supplying the user with dropdown parameter values from a list of tables. With a simple stored procedure, you can easily set up a report to insert records to a table, but there was an added requirement for the user to be able to select the site (database) that the values should come from. As the user needed to be able to select the site first, the rest of the parameters needed to be set up depending on which value they selected. You can set up the data sources dynamically using a couple different techniques, but I’ll explain how I approached it.

Continue reading Creating Dynamic Data Sources in SSRS