Skip to Content
0
Former Member
May 26, 2011 at 04:48 PM

XLSQL for using Excel (XLS) as datasource in VC

231 Views

Hi Benjamin,

Hope you are having a good day. I know its been a while since you worked on this piece ([url] DATE issues when using BI JDBC Excel datasource in VC;url] ) but we are trying to do the same thing you had done. Use xlSQL to connect to an excel file as a datasource for VC modeling.

We want to use the BI Java connector. I have loaded the JAR files and when we get to the Manage Connections, not sure what we enter for the Driver, URL, Schema, username and Password.

What I now see if that the Connection Test (for the BI JDBC system) works fine with the following:

Driver: com.nilostep.xlsql.jdbc.xlDriver

Connection URL (Unix box): jdbc:nilostep:excel:/reports/spec (this is the folder where I have the xls file)

FixedSchema: (should my excel file name go in here?)

FixedCatalog: (should my excel sheet name go in here?)

Username: none used

Password: none used

When I do all of this and search for TABLES in VC on that system, it says None found. Any light shed on this would be very helpful.

Thanks,

BR