ericg Posted February 25, 2009 Share Posted February 25, 2009 I was wondering if anyone could tell me if you can connect to an ODBC datasource through Javascript using, say, the OnJobStart rule. My problem is that I am using a .csv file for my input file but it doesn't have all the data i need in it. And adding the data I need would be quite a pain because it would require numerous changes back up the line. Any help would be appreciated. Thanks Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted February 25, 2009 Share Posted February 25, 2009 Sorry, the answer is No. You can only connect to ODBC for your main input data source (and currently on Windows only). There's no ExternalDataFileEx-type functionality to access a secondary ODBC data source. Your best bet is probably to dump the data to a tab-delimited file and use ExternalDataFileEx. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted February 26, 2009 Share Posted February 26, 2009 Just to clarify, you can indeed access fields from an ODBC data source in JavaScript with the Field function, just as with any other primary data source type. However, the "secondary" data file functionality through ExternalDataFileEx only works for flat (delimited) text files. (Did that clarify or just confuse things?) Quote Link to comment Share on other sites More sharing options...
ericg Posted February 26, 2009 Author Share Posted February 26, 2009 That makes sense. Thanks for your quick reply. I guess i will have to modify my other processes to add the data back up the line. Quote Link to comment Share on other sites More sharing options...
vtutino Posted February 2, 2012 Share Posted February 2, 2012 Dan, Is the answer still the same in 2012 for connecting to ODBC data sources using JavaScript with the newer versions of FusionPro Server? Just checking. Thanks, Vince Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted February 7, 2012 Share Posted February 7, 2012 Is the answer still the same in 2012 for connecting to ODBC data sources using JavaScript with the newer versions of FusionPro Server? Yes. Nothing major has changed regarding OBDC in FusionPro 7 and 8. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.