Skip to Content
0

data services connection to s3 external tables

Nov 16, 2017 at 08:38 PM

45

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Nov 17, 2017 at 04:13 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded