How to upload data from Database to queue?

[HeartCatcher (Naveenkumar.S)]

Hi All,

I have data in Database, I need to upload the data into a queue can someone help me on thus??

@ushu
@Palaniyappan
@ppr
@Nithinkrishna
@lakshman
@geetishree.rao
@Gokul001

[ppr (Peter Preuss)]

Bulk Add Queue Items

[jpbelchote (João Pedro Oliveira Belchote)]

Hey, I think this topic might help you:

SQL Data to Queue

HI @san.nagane , Thanks a lot for your response. I executed the query on my DB and there is one row. But here if my steps are correct, the row must be added to the queue rite? Could you also tell me the steps to check the count. i know we have to use Datatable.Rows.Count, but not sure where. Regards, Sidhartha Ranganathan.

[geetishree.rao]

Add Database Package in your Project
Connect to DB by passing the connection String
Use the output of this activity Connection object and pass it to execute query activity along with the query
Pass the datatable output if it is not nothing to the Bulk Add Queue Item activity.
Disconnect the connection

[HeartCatcher (Naveenkumar.S)]

[ushu (Usha kiranmai)]

@HeartCatcher

• First get the data from the data base using the execute query activity

Select * from your table name

• The output of this activity will be data table
• Now, use bulk add queue items activity to load the data table to the Orchestrator queue
• or you can loop through the data table and load the each row of data to the orchestrator queue

How to query data from a SQL database

[HeartCatcher (Naveenkumar.S)]

[HeartCatcher (Naveenkumar.S)]

I am getting error like that

[ushu (Usha kiranmai)]

@HeartCatcher Print the data table rows count just to make sure it has data. Also, print the config variable to make sure it is getting the exact queue name