iQoncept - Fotolia

Q
Manage Learn to apply best practices and optimize your operations.

What is your best advice for integrating software applications?

Ian Charles, CFO of Host Analytics, advises to invest time in scoping and consider future needs when integrating software applications.

What is your best advice for successfully integrating software applications?

Do it thoughtfully and carefully. Focus on what you want out first. Sometimes, people start with technical issues, such as data volumes or interfaces, but you have to remember that you're integrating systems to solve a business problem, so start there. What business questions are you trying to answer? What reports do you need to answer them? What are the cases from a user perspective that require you to push data from one system to another? My point is that the business requirements need to lead the technical conversation, not vice versa.

Ian Charles, CFO of Host AnalyticsIan Charles

As a CFO, my team faces some challenges that really raise the stakes for good integration. At Host Analytics Inc., we make some of the company's most important decisions using my team's reports and analysis. In public companies, finance has to report numbers to Wall Street. You can't afford to restate or revise based on an integration error.

Gaining visibility to your data sources

To achieve successful integration, you need to invest the necessary time into the scoping part of the project. You can't shortcut that. That avoids downstream errors in what you build and integrate. If you scope and execute the job properly, you should have clear visibility back to all of your data sources. For example, if you find an error in a cash flow statement, you can easily trace the error to the source.

The reality is that the less time we spend in finance worrying about technology and integrations, the more time we can spend helping the CEO and the executive team run the business. And the good news is that the cloud has dramatically simplified the integration challenge.

Cloud-based applications integration

For example, we use Salesforce for customer relationship management and NetSuite for ERP. We use our own product, Host Analytics, for forecasting, planning, consolidation and modeling. They're all cloud-based; and solid, flexible, reliable, low-cost connectors are widely available. We use Dell Boomi internally, which we offer with our product, but our customers are free to choose other alternatives and they often integrate with on-premises systems as well. The connection of these three systems is particularly powerful, seamless and automated in the cloud. We can easily configure the integrations to our needs, "set it and forget it," and get back to our day jobs. 

For more on cloud-based analytics:

Defining cloud analytics

Was 2012 the year of cloud analytics?

Cloud business analytics faces hurdles

Finally, I'd encourage people to consider future needs, as they evaluate integration approaches and technologies. I see some companies get so focused on solving a short-term integration headache that they end up with a system or an approach that won't solve tomorrow's problems.

In finance, we're constantly challenging ourselves to be more forward-looking and agile, and to minimize risk. Part of why we make choices is so they can evolve with us as our team grows, our application footprint evolves and our processes change. Host Analytics is growing incredibly fast, and we picked systems that we know will grow with us. We don't have time for pit stops.

About the author: Ian Charles is CFO of Host Analytics, a company in Redwood City, Calif., that sells cloud-based corporate performance management applications. Previously, he was CFO partner at the Brenner Group, Joyent and Skava.

News Writer Dan Ring assisted with this article.

Next Steps

Read a guide to ERP integration

Learn why CPM should integrate finance and operations

Understand Oracle ERP integration issues

This was last published in September 2015

Dig Deeper on Corporate Performance Management Software

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

3 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

What are the keys to a successful software integration project?
Cancel
I think scoping is important, but I also think it is good to break the plan up into small digestible chunks and try to deliver bits of it incrementally over time bring a stream of value.
Cancel
Considering long term maintenance is also important. What if the API keeps changing? What if data format keeps changing?
Cancel

-ADS BY GOOGLE

SearchManufacturingERP

SearchSAP

SearchOracle

SearchBusinessAnalytics

SearchContentManagement

SearchDataManagement

SearchCRM

Close