Mari
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
MS-Access Connection
I am trying to access the MS-access file from S3 location. But when i am trying to access i am getting the below error message. i suspect there is something wrong only on the JDBC URL from the Generic Database Account connection. Below is my URL. JDBC URL : jdbc:access:///S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb Note: i am able to access flat file through the same S3 location. Please advise Failed to validate account: Failed to retrieve a database connection. Cause: S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb doesn’t exist or can’t be accessed. If you’re using mapped drives to access database files, you may need to check the security permissions. (Reason: S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb doesn’t exist or can’t be accessed. If you’re using mapped drives to access database files, you may need to check the security permissions.; Resolution: Address the reported issue.)2.2KViews0likes1CommentUnzip and read the file
My input file is zipped. Inside the zip file, there are 3 fixed width file. I have to unzip the file and read each file(one at a time) and load into table. The input file will be in S3. Can someone advise to handle this scenario Earlier when there was only one input file, i was able to successfully unzip and load the file. But this is not working when there are multiple files. Below snaps i have used when there is only one pipeline and it worked successfully. Directory Browser -->S3 File Reader–>Decompress–>Transcoder–>Fixed Width Parser–> Mapper–> Target4.9KViews0likes2Comments