Best Practice to Load File into IPA

The Data Iterator node is commonly used to loop through records but it can also read a file into IPA. (For more on the Data Iterator Node, visit:

Based on the responses of seasoned IPA developers on the Infor/Lawson forums, the best way to ‘load’ in a file to an IPA flow is to use a FileAccess node followed by a DataIterator node. This speeds up the flow considerably as the FileAccess node would read the file into memory and then the DataIterator node can use the data from the memory instead of reading and closing the file multiple times.

First ‘load’ or ‘read’ the file into IPA using the FileAccess node. Then set DataIterator to process the Data (and not File) and set the source to be the FileAccess_outputData. This should noticeably improve the performance of the flow as the data is just being loaded into memory once by the FileAccess.


Modify column data type without dropping table

“String or binary data would be truncated.”

This is a common error if you’re trying to update a field with more data than it allows, e.g. trying to update a char(30) field with a 50 character string.


If you try to modify the column data type you’ll get a new error:

“The changes you made require the following tables to be dropped and re-created”. This might be an inconvenience for you.

Easy fix:  Go to Tools >> Options >> Select Designer and Uncheck >> “Prevent saving changes that require table re-creation”


And you’re DONE!  Modify the data type and run your update query.

Is Data Socialization the Next Big Thing in Analytics?

Big Data has contributed greatly to today’s business revolution. With that, there has also been an attempt to tackle the continuous process of assuring that the approporiate decision makers have the right data. This is all a part of Data socialization. Rather than trying to use a top-down approach to impose data-directives, embedding data analytics throughout an organization and having measurable effects can be much more beneficial. “Liking” and “sharing” quality ideas can help the right people who’ll use them to make crucial decisions. This would ensure that updates and edits can be brought to their attention. It would also gives way to data stewardship which would make privacy and compliance  lot less stressful.

For Full Article Click Here

4 Ways to Leverage a CRM to Boost a Small Business

Customer Relationship Management (CRM) programs can leverage customer data to enhance overall productivity. Below are four ways businesses can utilize effective CRM for boosting your business.

1. Cleaner Database – CRM can save hours of manual data entry and maintenance of customer information by automatically updating records and filling in missing information.

2. Shared data – Data collected among members can be easily shared in a CRM program, resulting in better coordination and open communication in the work space.

3. Leverage productivity tools and apps – A CRM app that keeps you connected with real-time updates on the key deals that your team may be working on can improve productivity and drive operational excellence.

4. Maintain a full 360-degree view of the customer at all times – CRM can integrate data streams from various solutions to provide a comprehensive view of the customer, with a record of each touch point with them.


For Full Article, Click Here

How predictive analytics will revolutionize healthcare

An academic medical center in New Hampshire is working to revolutionize healthcare with predictive analytics, wearable devices and the cloud. “It’s important to think about healthcare being on the precipice of what I think of as an industrial revolution,” says Dr. Jim Weinstein, president and CEO of Dartmouth-Hitchcock Health System. Weinstein’s goal is to improve patient outcomes, reduce costs and deliver more personalized care. To get there, healthcare providers must implement technology in a more automated, systematic way.

Connected devices such as blood pressure cuffs, pulse oximeter devices and activity tracker would collect data to be transmitted to the Azure Cloud via smartphone, where it’s pulled into a Cortana Analytics Suite dashboard at a contact center, helping to prevent people from getting sick in the first place by providing physicians with actionable data that can help them provide personal, optimal care.


For Full Article, Click Here

Is the data in your CRM a ticking time bomb?

The maturing Customer Relationship Management (CRM) market is a desirable market for consumer data. However, over time, simply collecting this data gives organizations their first potential for a ticking time bomb. The CRM gets clogged up and polluted with dated and incomplete contact records. Decayed and dirty data in CRM systems and contact databases is costing businesses lots of money each year they do not clean it up, through penalties, brand damage and more. “Poor record keeping, poor security and a failure to comply with consumer requests are risks a business would be crazy to ignore,” says Ben Rossi, business and technology writer. “ The longer you ignore data quality, the worse it will get.”

For Full Article, Click Here

CRM Data is a Customer Satisfaction Goldmine

Customer Relationship Management (CRM) software has developed a bad rap in companies due to “waste” and “inefficiency”.

Gartner projects that through 2015, 85% of Fortune 500 companies will fail to utilize big data for competitive advantage. That’s because they feel gathering this data has caused concerns including: volume of data, dark data, duplicate data, and incorrect data. None of these obstacles come as a big surprise, but many large organizations lack the manpower to set time aside to work on these valuable information.

Yet companies who don’t rely on CRM are only seeing things one-sided. Granted, this work is time consuming, though your customers can suffer from poor data management when interacting with reps from your company. Such instances like service mistakes and unfulfilled request can hurt customer retention and referral.

CRM is about the customer-business relationship, and that means maintaining existing relationships as well as forming new ones. With the right strategy, CRM can help your company make the most out of the relationships you already have, using the data you already have, as well as creating new relationships with the help of the relationships your already have.

There are many tactics to go about data mining, entering, and up-keeping, and CRM, when done right, can keep customers satisfied for a very long time.

For the full article, click here

Healthcare’s next innovation will involve terabytes of Data

In the past, Data from patients and the medical industry has not been used efficiently. A patients various doctors had a tough time of getting their past medical records which led to slow diagnosis’. But now there is a plan to change that.  New enterprise-wide data warehouses are being created around the country that will have the analytic capability to provide a full view of healthcare operations. Some of these operations include: Patient visits, diagnoses, test results, prescriptions, referrals. Understanding the connections between these operations will make it possible to improve patient care and outcomes.

“By reducing the silos and bringing information together, you can start doing care coordination, best clinical practices, and personalized medicine. That’s really the promise of where we’re going,” says Marc Perlman, Global Vice President of Healthcare and Life Sciences with Oracle. “And all of that boils down to how you integrate the data.”

Providers of healthcare know that the potential of the data created by electronic healthcare represents a huge possibility of information that contains great potential for improving patient care and outcomes, lowering costs, and showing to the world what a priority healthcare is to the world.

To read the full article, click here