Replicator

Aligni Replicator is a Windows application that rests in your system tray and periodically synchronizes a local Microsoft Jet database with the parts in your online Aligni account. Potential uses for this local database include interfacing to CAD applications such as Altium Designer to place parts directly from your part database.

Download

AligniReplicator-1.1.4-Setup.exe

Requirements

  • Aligni Medium or better account (API access required)
  • Windows 7, Windows 10
  • .NET framework
In order for users to retrieve data via Replicator, they need to have the following permissions:

  • View Suppliers

Installation

Replicator-SystemTrayAfter installation, Replicator is setup to start automatically when you login. It will appear in your system tray as shown below. You can click on the tray icon to see Replicator status, change settings, or initiate a synchronization.

Setup

Replicator-PreferencesSettings for Replicator are available by clicking on the tray icon and selecting “Preferences” from the drop down menu. In the settings dialog, setup should be straightforward:

  • Local Database – This is the full path and filename where Replicator will store your Jet database.
  • Aligni URL – This is the address for your Aligni site. You can enter either the subdomain (mycompany) or the full site URL (https://mycompany.aligni.com)
  • API Key – This is the API key to access your account. Your site administrator can provide this for you. Please see the Aligni API Documentation for more information about the API key.

Once these parameters are set, Replicator will test them using your network connection. If successful, you can accept the changes and Aligni will create and synchronize your database.

Sync Helper

The installation includes a small command-line executable called AligniReplicatorSync.exe. This executable can be used to initiate the replication process at any time from a script or other automated task.

Example: Altium Designer

Altium Designer can work with a local database to allow schematic placement of components from your database. Doing so provides a vital linkage from your CAD design and components in your database. Later, when you export the bill of materials (BOM) from Altium, it will readily import and match parts so that costing and material resource planning (MRP) activities can take place immediately.

There are a number of ways to configure Altium symbol and footprint databases. Please consult the Altium Designer documentation for more details than we present here.

Creating the Database Link

Altium uses a Database Link project to store details about the link to your database. You create a new database link project by selecting File → New → Library → Database Library in Designer.

  • Select Microsoft Access as the database type and enter the name of the file you created with Replicator.
  • Select Single Key Lookup under Field Settings and choose the partnumber database field to map to part parameter Partnumber. This option tells Altium how to find the part’s database entry from the part parameters.

AltiumDBLib

Design Parameter Mapping

Altium-DesignParametersWhen Altium associates a part with a database row, it pulls certain information from that row to define design parameters.

By configuring the database link, you tell Altium the specific behavior you want for each database column. For example, you can specify which design parameters to add, update, or remove when you perform a database update. You also specify which design parameters should be visible on the schematic sheet when added to your design.

In the example shown to the right, we’ve extracted the Manufacturer, Manufacture P/N, partnumber, Tolerance, Value, and ValueFloat from the database. We display the Value since it is the more human-readable format for value.

Altium has some special design parameters that serve a more functional role in your Altium project. A few of these are explained below. The Altium documentation has a more in-depth discussion of these parameters. The Altium Database Column is the column name we’ve provided in our example. If preceded by “x_”, it means that this represents custom parameter defined for the site.

Aligni Database Column Altium Design Parameter Description
x_schematic_symbol [Library Ref] A custom parameter to define the schematic symbol for a part. Altium will use this to select the schematic symbol from your library.
x_pcb_footprint_1 [Footprint Ref] A custom parameter to define footprint #1 used for a part. Altium will use this to provide this footprint as an option for the part.
x_pcb_footprint_2 [Footprint Ref 2] A custom parameter to define footprint #2 used for a part. Altium will use this to provide this footprint as an option for the part. Any number can be specified, but you’ll want to map your custom parameters to the Altium footprint references in the same order.
value_text Value This is a basic Aligni parameter for the value of parts such as resistors and capacitors. We’ve instructed Altium to add to the design and also make visible. A Deesign Parameter will be added and that parameter will be displayed on the schematic sheet.
x_min_operating_temp x_min_operating_temp This is custom Aligni parameter that we’ve chosen not to translate to the Altium design parameters.

Altium-FieldMapper

Selecting Parts

Altium-LibraryPanelOnce your database link is setup, you can pick parts directly from your replicated database within the Altium Library panel.

Altium allows you to sort or group based on columns you’ve chosen, so finding a part is usually pretty straightforward. When a part is selected, the schematic symbol and available footprints are populated and displayed. Altium knows which symbol to reference based on the [Library Ref] linkage. Altium knows which footprints to list based on the [Footprint Ref] linkage(s).

Search

Altium-LibrarySearchThe Altium library search also works with database parts and allows you to search by any of the available database columns. In the example on the right, a search is being performed on the “value_text” field.