tag:blogger.com,1999:blog-25205225.post4144761388675857451..comments2009-01-11T01:49:01.823-05:00Michael Imhoffhttp://www.blogger.com/profile/15438909513365135704noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-25205225.post-30599378650622175132007-01-06T18:18:00.000-05:002007-01-06T18:18:00.000-05:00Hi Jake,<br /><br />I appreciate you taking the time to leave your comments.<br /><br />When I spoke with support from Information Builders, I was told that there was no way to connect 'TO' a Focus database using ODBC. I was given the impression that you can only create and ODBC connector to an external datasource. Our client is still running WebFocus v5.1.<br /><br />We are replacing the Focus database with SQL Server and moving the application logic and presentation to ColdFusion.<br /><br />I look forward to hearing from you,<br />MichaelMichael Imhoffhttp://www.blogger.com/profile/15438909513365135704noreply@blogger.comtag:blogger.com,1999:blog-25205225.post-58905255729553157822007-01-05T19:58:00.000-05:002007-01-05T19:58:00.000-05:00Hi Michael,<br /><br />I picked up your blog from a Google Alert.<br /><br />I'm sorry it was hard to migrate off of the legacy FOCUS database you were using, but we do indeed offer <a href="http://www.informationbuilders.com/products/webfocus/data_access.html">ODBC and JDBC drivers for FOCUS</a> (along with about 75 other data sources, modern and legacy), and an <a href="http://www.informationbuilders.com/products/webfocus/data_warehousing.html">ETL tool (DataMigrator)</a> that can handle an end-to-end integration process. In fact, our subsidiary iWay Software is an integration company, and we gain a lot of capability from them. (I was on the iWay side of the fence just two months ago.)<br /><br />I'm not sure how complex your migration was, but I imagine we could have handled it. Sorry we didn't talk to you sooner.<br /><br />You might also point out to your readers that there are two aspects to the application you're talking about: the FOCUS <i>database</i>, which you migrated to SQL Server, and the WebFOCUS <i>Business Intelligence and Reporting tool</i>, which you didn't discuss in your post. You told us what you did with the data; what did you do with the application?<br /><br />Regards,<br /><a href="mailto:jake_freivald@iwaysoftware.com">Jake Freivald</a><br />Information Builders and<br />iWay SoftwareJakehttp://www.blogger.com/profile/01523638337057738776noreply@blogger.com