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 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. 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?) 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. 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 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.