Skip to Content
avatar image
Former Member

data services connection to s3 external tables

I am using data services 4.2 SP8.

I have defined external tables on S3 using athena. I need to use them in data services as sources/targets. I created a jdbc adapter for connection. Athena needs additional property called "s3_staging_dir" that i need add to my adapter. I do not see any way to add this property. Any help would be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 17, 2017 at 04:13 AM

    Did you try creating a JDBC Adapter instance in DS Management Console. You can add the properties in the adapter instance.

    I doubt you can use the S3 tables as target. Using JDBC adapters you can only use the tables as Source.

    https://blogs.sap.com/2015/10/08/how-to-connect-to-sql-server-2014-in-sap-data-services-using-jdbcadapter-adapter-type/

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded