PICA Australia / Software / Design

Portfolio SQL Connect

 

 

 

 

Visual Catalogs at Warp Speed
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.



What is SQL Connect?
A powerful module that allows Portfolio Server to store data in more robust databases (like Microsoft® SQL Server™, 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.



Benefits of SQL

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
System Requirements
Windows
1GB RAM
1 GHz Pentium 4 or equivalent
MySQL 4.1.21 or 5.0.37 with MyODBC Connector 3.51.12
or Oracle 10gR2 with Oracle ODBC driver v10.02.00.01
or Microsoft SQL Server 2000 SP4 with SQL Server ODBC driver v2000-8.00.2039
or Microsoft SQL Server 2005 SP2 with SQL Server ODBC driver v2005-9.00.1399.06 (Use newer ODBC drivers at your own risk.)
TCP/IP Services Installed

Macintosh
1GB RAM
1 GHz or faster G4, G5
or Intel Core processor(s)
MySQL 4.1.21 or 5.0.37
MySQL 5 offers tremendous improvements in overall catalog performance, and is recommended as the preferred choice over MySQL 4. For a complete list of Portfolio SQL Connect system requirements, please see the detailed chart in the Portfolio User Guide Update PDF.
MyODBC 3.51.14 (Use newer or alternate ODBC drivers at your own risk.)