how to use external sql server database

how to use external sql server database

  
I would like to connect to my own sql server database to retrieve data for my dropdown box and save transaction data. I created the database connections in service center under adminstration/database connections, but how do i use the connection in service studio?
You have to import the tables via Integration studio.

That extension you have to import in service studio and you are ready to rock'n'roll!
Hi sql kris,

Joost answered correctly, but if you need a more detailed example, take a look at the following video, on integrating with an existing database.

Regards,

Paulo Tavares
I have connected to sql server database using integration studio. but, dont know how to import the extension in service studio. Not able to watch the video due to some error.
Hi Skris,

After publishing the extension in Integration Studio, you should go to Service Studio and click the "Add/Remove References" button



Then you should see a list of all things you can reference, and there should be your extension. You just have to select it, and the entity should show up for you to use it.

Regards,

Paulo Tavares