Xem giỏ hàng (0 sản phẩm)
Sản phẩm
Trang chủ >Extensis > Portfolio SQL Connect
Portfolio SQL Connect
Giá/List Price: Liên hệ

Số lượng:


Part number : please contact

Thông tin thêm

Looking for scalability and flexibility when managing your creative assets? You've found it with the Portfolio Software suite. Add our SQL Connect module to Portfolio Server and you have a creative assets management system that leverages the power and toolset of your existing SQL database.

A powerful module that allows Portfolio Server to store data in more robust databases (like Microsoft®, MySQL® or Oracle®), often one that is already in place at your company. It essentially allows you to leverage the advantages that both Portfolio Server and your SQL database can offer. SQL Server



Increased responsiveness under heavy demands
Ability to build customized workflow solutions
Enhanced stability for large catalogs*
Makes available SQL administration tools, such as auto-backup and reporting*

* Functionality will vary based on SQL database platform.


Supported SQL Databases

  • MySQL 4.1.21 or 5.0.37
  • Oracle 10gR2
  • Microsoft SQL Server 2000 SP4 or 2005 SP2

For a complete list of Portfolio SQL Connect system requirements, please see the system requirements page

  • System Requirements    
    Review the core system requirements to run Portfolio SQL Connect in your infrastructure.
  • Pricing Guidelines    
    General list prices for Portfolio SQL Connect.
  • Free Trial / Purchasing    
    Get a 30-day free trial of Portfolio SQL Connect or specific pricing information from your Extensis Sales Representative.
  • Documents and Resources    
    Check out our library of resources to help you better evaluate and use our Portfolio solutions.

For single-user and standard Portfolio Server installations, all of your catalog references are stored in an FDB catalog. These catalogs are very efficient and optimized for catalogs ranging in size of several hundred assets up to tens of thousands. But if your needs require managing more than a hundred thousand assets, then SQL Connect is better suited for the increased workload.

FDB catalogs are a relatively "flat" type of database. Information is stacked into a single file, like cards in a deck. Portfolio essentially, must flip through the entire catalog like a deck, identifying each card, returning the location in the deck. For example, a search can locate all of the Hearts, the red Kings or just the two of Diamonds.

But when using SQL Connect, all catalog information is stored in a separate SQL database. These databases have sophisticated indexes that allow records to be found without having to "flip through the entire deck." Because of this optimization, when you search for items stored in an SQL database, locating the information can be very efficient, even in extremely large databases. As a matter of fact, the benefits of SQL are much more apparent when you start hitting the larger number of items.

The speed of your database can be linked to the number of assets that you manage, as well as the type of database that you use. In some instances where you only have a small number of items, an FDB catalog may be the optimal solution. Where an SQL solution shines is when your databases grow to be very large.


Chân thành cảm ơn quý khách hàng