My Sellerdeck Account | Free Trial

Sellerdeck Community and Knowledge Base

  #1  
Old 04-Jan-2018, 10:49 AM
G.W.Green G.W.Green is offline
Administrator
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 482
Thanks: 0
Thanked 66 Times in 42 Posts
Linking to an External SQL Database

Versions of Sellerdeck Enterprise since v16.0.4 RGVB will support linking to an external SQL database. This requires the external database to be on a SQL server linked to the one holding your Sellerdeck database.

Microsoft provides an overview of linked servers (https://docs.microsoft.com/en-us/sql...atabase-engine) and instructions for setting one up (https://docs.microsoft.com/en-us/sql...atabase-engine).

We recommend that you have this done by the person who set up the SQL database that you want to link to.

After linking the servers, proceed as follows:
  1. From the Sellerdeck Desktop ‘File’ menu, select ‘External Links’.
  2. Check the box ‘Link Products To Table in an External Database’.
  3. Click ‘Browse’.
  4. Select the linked server you want to use:



  5. Select the database containing the table you want to link to:



  6. Select the table to link to:



  7. Click ‘OK’.
You can now proceed with mapping the linked fields, as described in the Sellerdeck Desktop main help (the section ‘Mapping External File Fields’ in the chapter ‘Linking to an External File’).
Attached Images
File Type: png Linked-server-1-select-server.png (86.5 KB, 38 views)
File Type: png Linked-server-2-select-database.png (79.0 KB, 35 views)
File Type: png Linked-server-3-select-table.png (95.2 KB, 33 views)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 02:30 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.