How to output to teradata from excel table using Indatabase
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
How would I go about outputting to Teradata from an Excel file using In-database?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sonseeahray - Use Data Steam In: https://help.alteryx.com/current/designer/data-stream-tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ArtApa,
This is the test workflow to output from an Excel file to a Teradata table. It is failing with the error message that the user doesn't have CREATE TABLE access. Could this message indicate something else? I do have this access.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sonseeahray - Alteryx doesn't overcome your existing data government framework. It honours existing permission and access rights. If you don't have the rights to create tables you need to speak with your IT to see if you can be granted one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ArtApa, I mentioned that I do have the permissions to CREATE TABLEs in the Teradata database I am attempting to output to. This is why I asked "Could this message indicate something else? I do have this access"
