Excel Import via JDBC

[Former Member]

Hi all,

i implemented the Hxtt driver but I still get "Connection fails" in the system landscape.

I did following steps:

In Visual Administrator:

1) JDBC Connector -> Drivers -> New Driver Excel_JDBC30 with Test_JDBC30.jar

2) Connector Container -> sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc -> New clone of SDK-JDBC -> Resource Adapter -> library:Excel_JDBC30 was added

In Portal:

3) New System Excel_JDBC

4) Connection URL: jdbc:excel:/C:test_csv_jdbc.xls

5) Driver Class Name: com.hxtt.sql.excel.ExcelDriver

6) BI Directory Provider: yes

7) Factory Class: Excel_JDBC

😎 User Mapping Type: admin,user

9) I created an alias: Excel_JDBC

10) Made user mapping for this system. Is it necessary?

Connection fails!!

Thank you for any help, best regards

Frank

[Former Member]

Hi,

i now get the Excel imported.

But I only see the header and not the values.

Did anyone have the same problem?

Thanks in advance, best regards

Frank

[Former Member]

Hi Frank,

I remeber... a collegeau had the same issue. This is a bug of the JDBC drvier as I know. I think his solution was to use another driver. I will contact him for the correct solution will update the thread.

Best Regards,

Marcel

[Former Member]

Hi Frank,

did you check the [WIKI|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbcConnectionSetup&]?

User mapping is ok, so that you have access to the file, therefore you should use e.g. a certain ADS user for accessing the file system and your excel/csv file.

Best Regards,

Marcel