BusinessObjects Board

Palantir Foundry as source using ODBC in SAP BODS

dataservices administration
#1

Hello Team,

We have used ODBC to connect Palantir Foundry as a source successfully but we are unable to import tables because the table name is something like this.

“/ls/ls-use-case-erp-material-master-data-for-ecommerce/ERP Master Data/Emerald_MARA_MVKE_CN”

So, we have used SQL Transform and placed the below query but when we click on Update schema, it is throwing an error as below. Though it errored out, we manually added all column names in the SQL Transform structure and then run the job

Foundry Query :
SELECT * FROM “/Life Science/ls-use-case-erp-material-master-data-for-ecommerce/ERP Master Data/Emerald_MARA_MVKE_CN”

Update Schema Error in SQL Transform using Palantir Foundry ODBC
Update Schema Error in SQL Transform using Palantir Foundry ODBC724×895 174 KB

Please assist in how to resolve this ODBC issue.

Thank You,
Abdulrasheed.

#2

@shaikaba I am not sure this is possible but i’m curious, what if you were to use to use

SELECT * FROM '“/Life Science/ls-use-case-erp-material-master-data-for-ecommerce/ERP Master Data/Emerald_MARA_MVKE_CN”'

does it work?

#3

maybe a problem with your data/schema because of “duplicate key … found”