How To Create new DataSource for LBI in Websphere

,

Login and get to the main menu of websphere

Then go to Resources >> JDBC >> Data sources:

how-to-create-new-datasource-for-lbi-in-websphere-1
Select New to create a new DataSource:

how-to-create-new-datasource-for-lbi-in-websphere-2

Type in the name of your DataSource and your database name as so (place the jndi\ in jndi name field):

how-to-create-new-datasource-for-lbi-in-websphere-3

Select existing JDBC provider >> Microsoft SQL Server JDBC Driver (Most common)

how-to-create-new-datasource-for-lbi-in-websphere-4

Enter in your database name and the server your database sits on:

Select your Admin user for Component-managed authentication alias.

how-to-create-new-datasource-for-lbi-in-websphere-6

Review your setup and click Finish:

how-to-create-new-datasource-for-lbi-in-websphere-7

 

Go test your newly created DataSource in from a SmartNotification or LBI Report that uses that DataSource.

 

Enjoy!

PR160 ACH Output Format

,

If you upload the ACH file generated by PR160 to your bank, chances are you will need to fix the formatting after your upgrade to version 10. Some banks require the 94-character fixed width format, rather than the sequential format that is the Lawson default. Here are the steps to update your ACH file format.

  1. In LID, type in the command workdef
  2. Search for your product line and the File name TAPEpr160-ach-output-format-1
  1. File Media should be “Tape”
  2. The default “Value” for file name is PR160-ACHTAPE. If you need to drop the file under a custom name, you will enter it in the “Value”. If you want to keep the default, leave that field blank.pr160-ach-output-format-2
  1. Click enter twice to save your changes
  2. The PR160-ACHTAPE file is defaulted to save in the user’s print directory. If you want it saved somewhere else, you can supply the filename on the PR160 job. If you supply a file path on PR160, make sure the file name matches the “Value” field in workdef.pr160-ach-output-format-3
  1. In Lawson Security, make sure that your Batch role has access to the cnvexp development token

Infor Learning Optimization Now Available

Infor announced the availability of Infor Learning Optimization, a new addition to the Infor Talent Management suite. This tool is designed to match organizations and employees with personalized learning and coaching at the individual level, to help resolve behavioral opportunities. This individualized learning is meant to help employees feel more connected to their jobs and reduce attrition and flight risk. Charles Cagle, senior vice president, HCM Development, Strategy, & Operations at Infor states,”by providing managers with insights and tools to capitalize on employees’ behavioral strengths and characteristics, Infor Learning Optimization can help them directly impact success and influence business goals.”

 

For Full Article, Click Here

Purging Benefits Data

,

Every time an employee makes a benefits change, a new record is stored in the benefits table.  Additionally, a new record is stored in the employee’s deduction master table for each deduction related to that benefit.  If these records are allowed to accumulate unchecked, this can slow down payroll processing and even cause errors.  The larger the benefits and deductions table become, the slower payroll batch jobs will run.  These batch jobs, such as PR140, loop through each record in these benefits and deductions tables so that the correct deductions are applied.  Some of these batch jobs have a limit of the number of records allowed, so if an employee has deductions that exceed that limit, the job will error out.  Also, traversing through these records can greatly slow down processing.

To help alleviate these issues, we recommend running the BN430 benefits purge program periodically.  When you are processing payroll, if you see an error similar to “26 20591 PRDED-DED-TABLE must be increased; Cur size 0500”, chances are you have an employee with too many benefits changes, and need to run the BN430.  But, before you receive this error, you should make the benefits purge part of a normal maintenance process.  Ideally, payroll users would make this part of the payroll process each pay period, and choose a “Purge Through Date” corresponding to your company’s record retention period.Purging-Benefits-Data

Restaurant Execs Invest in Technology

Restaurant executives are turning to technology to improve overall efficiency. After being surveyed in hospitality technology, they have adopted many customer-facing technologies. Many have adopted loyalty programs, comprehensive mobile experiences , personalized offerings, and tableside ordering – all of which can help restaurants better reach customers and make their overall experience more satisfying. Restaurant execs are also turning to predicative analytics and Internet of Things (IoT). Though these technologies are still new, some have begun harnessing the power of them. Few also said they were focusing on other new types of technologies, such as augmented reality (AR) and wearables. Technology can help increase sales, and the use of it in a restaurant provides a competitive advantage.

 

For Full Article, Click Here

Companies see 5G technology as game changer

 

Next generation 5G technology is making its way through the digital age and almost every industry is ready for it.  “With 5G, industries will have connectivity that is customized for their requirements and the agility to move quickly to meet customer needs and be innovative,” said Rima Qureshi, Chief Strategy Officer, Ericsson in a statement. The auto industry’s ever growing “smart car” innovations will look to utilize enhanced GPS with instant traffic and map updates with 5G technology.  Public safety organizations expect 5G to provide added safety and security. Probably the most popular among the crowd is the media and gaming industry, expecting 5G to provide high quality experiences in gaming, video and other media. Our digital age is ready for the breakthrough of 5G technology.

 

For Full Article, Click Here

Get Creative with CRM

As technology has advanced, Customer Relationship Management (CRM) has evolved to assist businesses with the capability of targeting customers and vetting other potential opportunities. CRMs are capable of completing more tasks than most people may be aware of. Here are a few ways businesses can utilize CRM outside of sales and extract creative value for business:

  • Keeping Customers Happy
  • Assisting in Marketing
  • Bringing in New Talent

With the emerging digital world and the need for CRM to be ever present in business, we must think outside the box and utilize this tool to its full potential.

 

For Full Article, Click Here

4 Ways Procurement Has to Change in the Postmodern ERP Era

Brian Utley, Periscope Holdings, presents game-changing realizations about what government organizations expect from modern procurement functions and digital investments in this Enterprise Resource Planning (ERP) technological age.  Below are ways procurement has to change how we operate in today’s “postmodern ERP era”:

  1. We can no longer think tactically
  2. Cost savings can’t just come from the supplier side
  3. We’ve officially entered the postmodern ERP era, which means more concrete decision making
  4. Integration is the key to securing any return on investment for any technology implementations

Procurement technology modernization is necessary. It is expected to simplify the purchasing process, protect taxpayer dollars and ensure fair competition.

 

For Full Article, Click Here

5 Skills to Look for When You Hire a Data Scientist

Leigh Martin, Senior Director, Dynamic Science Labs, Infor discusses how big data analytics have gone mainstream, with the demand for people with the right skills to turn data into insights is scarce. Martin shares 5 skills that define a successful data scientist in any business setting.

  1. Great data scientists are good at applying the scientific method to business problems.
  2. Data scientists are engaged in earning the trust of the business throughout the life of the project and beyond.
  3. Great data scientists know how to translate the language of the business to the language of IT and the other way around.
  4. Successful data scientists know how to engage with business users.
  5. Great data scientists always push the envelope of the science of data analysis, and constantly learn, experiment and explore new information.

 

For Full Article, Click Here

Infor Completes Acquisition of Starmount

Infor announced the completion of their acquisition of Starmount, a modern store systems provider serving large and mid-market retailers with point-of-sale, mobile shopping assistant, and store inventory management products along with cross-channel customer interactions. The acquisition will be a great asset to accelerate delivery of Infor CloudSuite Retail. With the struggle to force outdated software to meet new retail industry demands, Infor’s CloudSuite Retail will address these issues by providing modern, cloud-based software services. Infor is heavily investing in products that achieve converged commerce for retailers, the next step after omni-channel in which retailers use a single selling system for all consumer interactions.

 

For Full Article, Click Here