Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: running an ETL job from ATE

running an ETL job from ATE 5 years 5 months ago #9116

  • hanisultan
  • hanisultan's Avatar Topic Author
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 674
  • Karma: 1
  • Thank you received: 2
Is there a way that I can run an ETL job created in Advance ETL from ATE? Sometimes I might want to give access to an ETL job to an ATE user like reloading a table or processing a file and so on, without giving the user access to AETL. Hope this makes sense.

Please Log in or Create an account to join the conversation.

running an ETL job from ATE 5 years 5 months ago #9117

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
Are you using agent for the execution?

Peter
Mike

Please Log in or Create an account to join the conversation.

running an ETL job from ATE 5 years 5 months ago #9118

  • hanisultan
  • hanisultan's Avatar Topic Author
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 674
  • Karma: 1
  • Thank you received: 2
Yes I'm using agent.

Please Log in or Create an account to join the conversation.

running an ETL job from ATE 5 years 5 months ago #9120

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
In this case what you can do is to insert a record into QUEUE table

Agent than will pick it up and execute

I suggest using negative values for QUEUE_ID field to avoid conflicts

Mike
Mike

Please Log in or Create an account to join the conversation.

running an ETL job from ATE 5 years 5 months ago #9122

  • hanisultan
  • hanisultan's Avatar Topic Author
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 674
  • Karma: 1
  • Thank you received: 2
I will try that and let you know the result

Please Log in or Create an account to join the conversation.

running an ETL job from ATE 5 years 5 months ago #9123

  • hanisultan
  • hanisultan's Avatar Topic Author
  • Offline
  • Platinum Boarder
  • Platinum Boarder
  • Posts: 674
  • Karma: 1
  • Thank you received: 2
There are so many fields to fill and don't know what to enter , so I wanted to execute a transformer called T1 how would I enter a record of that into the table? There is object_parameter and Object_date fields that I'm not sure what enter there and also the log_file, there is a sequence but I guess I can put something and it would be fine. Please advise, thank you

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 369 guests and one member online