Page Comparison

This chapter describes the integration with Professional Advantage's Company Data Archive (PA-CDA) software using GP Dynamics/Dexterity and Microsoft SQL Server. (CIN-3792)
This chapter contains the following sections:

• Introduction
• Prerequisites
• Installation
• Data Archive Procedures

Anchor
Introduction Introduction

Anchor
_Toc85655382 _Toc85655382

Introduction
Data Archive – Phase I provides an easy way to move CINCH Sales (Bookings, Invoice, Prepay, Shipment Invoicing, Branch & Bulk Transfers) historical information from your 'live' company to an 'archive' company along with any necessary master tables. History records provide useful information for audit and analysis purposes and reduces the size of your live company database which then improves system performance.
Archiving is done by a cutoff date of historical data. All historical transaction with a date on or before the archive date will be moved to an archive company. Archived transaction will still be available to inquire and report on via the archive company as you would any other company.
Please refer to PA-CDA's Best Practices documentation and manual for more information on archiving.

Anchor
Prerequisites Prerequisites

Anchor
_Toc85655383 _Toc85655383

Prerequisites
The following is the list of prerequisites:

1. Microsoft Dynamics GP installed and setup. Minimum version 12.00.2038 KB 3102154.
2. Professional Advantage Company Data Archive – Plus installed and setup for each company you wish to archive data. Minimum version 12.0b45.

The PA-CDA version must support your Microsoft Dynamics GP version.

1. CINCH installed and setup. Minimum version 12.3 M43 (SP5).
   1. CINCH needs to be installed on both the LIVE and ARCHIVE database.
   2. Only the following SQL scripts need to be ran against the ARCHIVE database.
      1. SQLCompanyFunctionsRXXX.sql
      2. SQLCompanyViewsRXXX.sql
      3. SQLCompanyProceduresRXXX.sql

Anchor
_Hlk85546388 _Hlk85546388

DO NOT run the following CINCH SQL script against your ARCHIVE database; SQLCompanyTriggersRXXX.sql, Please contact customer support if this script was processed against the ARCHIVE database, reference CIN-5447.

Anchor
_Hlk85546449 _Hlk85546449

The following SQL scripts do not need to be ran against the ARCHIVE database but will not cause issues; SQLCompanyCinchXR1852 or SQLCinchXSystemProcs18.52.0.8 and SQLCompanyeConnectR1852.sql.

Anchor
Installation Installation

Anchor
_Toc85655384 _Toc85655384

Installation

Anchor
_Hlk85546730 _Hlk85546730

Data Archive is easy to install once all prerequisites have been completed. Simply run the following SQL script against your GP System database, which may or may not be DYNAMICS.

Anchor
_Hlk85546793 _Hlk85546793

IRArchive_System_Install_CINCH.sql

Anchor
_Hlk85546957 _Hlk85546957

DO NOT run this script against LIVE databases.

Anchor
DataArchiveProcedures DataArchiveProcedures

Anchor
_Toc85655385 _Toc85655385

Data Archive Procedures

Anchor
_Hlk85548173 _Hlk85548173

If this is your first-time using Data Archive and Professional Advantage's Company Data Archive (PA - CDA), you likely have many years of data you'll need to archive. However, attempting to archive all data, across all modules, all at one time, will very likely take days to accomplish. For example, you may have 10 years of data in your live company, but you determine it is only necessary to keep the most recent three years in your live company. It is our recommendation to split this initial archive into several pieces.

• • • • Anchor
        _Hlk85548380 _Hlk85548380

        Archive just Master Data
      • Archive one GP/CINCH/Intellego module for just your oldest fiscal year. You may even want to do half years or even quarter years depending on the size of the tables being archived.
      • Continue archiving by year, half year or quarter year until you have reached your desired cutoff.
      • Follow this process for all GP/CINCH/Intellego modules

...