Sellerdeck Community

Sellerdeck Community (http://community.sellerdeck.com/index.php)
-   Sellerdeck Enterprise (http://community.sellerdeck.com/forumdisplay.php?f=131)
-   -   Linking to an External SQL Database (http://community.sellerdeck.com/showthread.php?t=57453)

G.W.Green 04-Jan-2018 10:49 AM

Linking to an External SQL Database
 
3 Attachment(s)
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:

    http://community.sellerdeck.com/atta...1&d=1515062592

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

    http://community.sellerdeck.com/atta...1&d=1515062592

  6. Select the table to link to:

    http://community.sellerdeck.com/atta...1&d=1515062592

  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’).


All times are GMT. The time now is 12:51 PM.

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