Accord Data Integration Management
PublishedArticle Content
--- id: KB-ACCORD-001 module: accord sub_module: accord title: Accord Data Integration Management category: how-to applies_to: - user_type: admin - role: system_administrator products: - IFANOW Platform platform_area: backoffice related_workflows: - data_synchronization - mutual_fund_data_updates depends_on: - KB-MF-001 - KB-NAV-001 - KB-PORTFOLIO-001 access_level: admin source: code_extraction source_files: - repo: ifanow-futurewise files: - AccordController.java - AccordDumpService.java - AccordSchemeClassMasterService.java - AccordSchemeMasterService.java - AccordService.java - AccordSchemeMasterDao.java - AccordDumpDao.java last_extracted: '2026-02-17' confidence: high version: 1 tags: - data_sync - mutual_fund_data - scheme_details - nav_updates - portfolio_data - data_integration - accord_provider --- ``` ## Overview The Accord Data Integration system automatically synchronizes mutual fund data from the Accord data provider into your IFANOW platform. This system ensures your platform has the latest mutual fund schemes, NAV prices, portfolio holdings, fund manager details, and performance metrics. It processes over 50 different types of mutual fund data including scheme master data, current NAVs, historical performance, portfolio compositions, dividend details, and fund house information. The system runs scheduled updates and provides manual override capabilities for immediate data refreshes. It maintains audit trails of all data synchronization activities and provides status monitoring for data update operations. ## Prerequisites and Access You need system administrator privileges to access Accord data integration features. Navigate to **System Administration** → **Data Management** → **Accord Integration** in the main menu. Your platform must have an active Accord data subscription and valid authentication credentials configured. The system requires appropriate storage permissions for data file management and database update privileges for mutual fund data tables. ## How-To Steps ### How to View Data Synchronization Status Check the current status of Accord data updates and monitor recent synchronization activities. 1. Navigate to **Data Management** → **Accord Status Monitor** 2. Select your date range using the **Start Date** and **End Date** fields 3. Click **View Status Report** 4. Review the summary showing successful updates, failed operations, and pending processes 5. Click on any individual entry to see detailed logs and error messages if applicable The system displays real-time counts of successful and failed operations, along with detailed logs for troubleshooting any issues. ### How to Manually Trigger Data Updates Force an immediate update of specific mutual fund data categories outside the normal schedule. 1. Go to **Data Management** → **Manual Data Sync** 2. Choose the **Data Category** from the dropdown (Schemes, NAV, Portfolio, Returns, etc.) 3. Select the **Date Range** for historical data updates 4. Enter the **Section** (typically "MutualFund") and **Sub-section** (NAV, PORTFOLIO, etc.) 5. Provide your Accord **Authentication Token** 6. Click **Start Manual Sync** 7. Monitor the progress in the status window that appears The system will process your request immediately and show real-time progress updates. Large data sets may take several minutes to complete. ### How to Download Raw Data Files Access the original data files received from Accord before processing. 1. Navigate to **Data Management** → **Raw Data Access** 2. Enter the specific **Filename** you want to retrieve 3. Specify the **Date** for the data file 4. Select appropriate **Section** and **Sub-section** parameters 5. Click **Download Raw File** 6. The system will retrieve and display the unprocessed data This feature is useful for data validation and troubleshooting synchronization issues. ### How to Process Batch Data Updates Handle large-scale data updates using pre-stored data files. 1. Go to **Data Management** → **Batch Processing** 2. Select **Process Dump Files** from the options 3. Choose the data categories to include in the batch 4. Review the file list showing available data for processing 5. Click **Start Batch Processing** 6. Monitor the audit log for completion status of each data category The system processes multiple data types in sequence, updating scheme details, NAV data, portfolio information, and performance metrics. ## Rules and Limits • Data updates can only be performed by users with system administrator privileges • Manual synchronization requires valid Accord authentication tokens that are not expired • The system automatically creates backup files before processing any data updates • Failed data updates are automatically logged with error details for troubleshooting • Portfolio data processing may be queued during high-traffic periods to maintain system performance • Date ranges for manual updates cannot exceed 90 days for performance reasons • The system maintains a 30-day history of all data synchronization activities • Duplicate data entries are automatically handled using upsert operations • Data marked for deletion in Accord feeds will be removed from your platform • Real-time NAV updates take precedence over batch historical data for the same dates ## Common Questions **Can I update only specific mutual fund schemes instead of all data?** The system processes data by category (NAV, Portfolio, Schemes) rather than individual schemes. You cannot selectively update single schemes, but you can choose which data categories to synchronize. **What happens if a data update fails partway through?** Failed updates are logged with specific error details, and the system maintains the previous data state. You can retry the update after resolving any authentication or connectivity issues. **How often does the system automatically sync data from Accord?** Automatic synchronization schedules vary by data type - NAV data typically updates daily, while scheme master data updates less frequently. Check with your system administrator for your specific schedule. **Can I see what data changed during an update?** The audit logs show counts of records added, updated, and deleted for each data category, but detailed change tracking requires accessing the individual data modules. **Why do some updates take longer than others?** Portfolio data and historical performance data contain much larger datasets than basic scheme information, so processing times vary significantly based on the data type and date range selected. ## Troubleshooting **Problem:** Data sync shows "No Response From Accord" error **Cause:** Authentication token is invalid or network connectivity issues **Fix:** Verify your Accord authentication token is current and test network connectivity to Accord services **Problem:** Update process shows successful but data appears unchanged **Cause:** The Accord feed may not contain new data for the requested date range **Fix:** Check the Accord data availability for your requested dates and verify the data category parameters **Problem:** Batch processing stops with database connection errors **Cause:** Database connection timeout during large data processing operations **Fix:** Process smaller date ranges or contact your database administrator to adjust connection timeout settings **Problem:** Raw data download returns empty or corrupted files **Cause:** Incorrect filename format or date parameters in the request **Fix:** Verify the exact filename format expected by Accord and ensure date parameters match Accord's date format requirements **Problem:** Status monitor shows operations stuck in "Processing" state **Cause:** Background processing queue may be overwhelmed or stuck **Fix:** Check system resources and restart the data processing service if necessary, or contact technical support ## Related Features This system integrates closely with the **Mutual Fund Data Management** module for scheme information updates, **NAV Management** for price updates, and **Portfolio Analytics** for holdings data. It depends on the **File Management System** for storing raw data files and connects to **Audit Logging** for tracking all synchronization activities. The data synchronized through Accord feeds into **Performance Analytics**, **Fund Comparison Tools**, and **Client Reporting** systems throughout the platform.
Edit Article
Changes from Previous Version
--- +++ @@ -2,132 +2,118 @@ ## Overview -The Accord Data Synchronization feature automatically retrieves and updates mutual fund data from external Accord systems into your IFANOW platform. This ensures your advisors always have access to the latest NAV prices, scheme details, portfolio allocations, and other critical mutual fund information needed for client advisory services. - -• Automatically synchronize mutual fund NAV data, scheme details, and portfolio information -• Process bulk data updates from Accord's comprehensive mutual fund database -• Track synchronization status and monitor data update success rates -• Handle manual data synchronization for specific date ranges or data types -• Maintain audit trails of all data synchronization activities +The Accord Data Integration system automatically synchronizes mutual fund data from the Accord data provider into your IFANOW platform. This system ensures your platform has the latest mutual fund schemes, NAV prices, portfolio holdings, fund manager details, and performance metrics. It processes over 50 different types of mutual fund data including scheme master data, current NAVs, historical performance, portfolio compositions, dividend details, and fund house information. The system runs scheduled updates and provides manual override capabilities for immediate data refreshes. It maintains audit trails of all data synchronization activities and provides status monitoring for data update operations. ## Prerequisites and Access -You need system administrator privileges to access data synchronization features. Navigate to **System Administration > Data Management > Accord Synchronization** in the main menu. This feature requires an active Accord data subscription and proper API authentication tokens configured in your system settings. +You need system administrator privileges to access Accord data integration features. Navigate to **System Administration** → **Data Management** → **Accord Integration** in the main menu. Your platform must have an active Accord data subscription and valid authentication credentials configured. The system requires appropriate storage permissions for data file management and database update privileges for mutual fund data tables. ## How-To Steps -### How to Run Automatic Data Synchronization +### How to View Data Synchronization Status -This process retrieves the latest mutual fund data and updates your platform's database automatically. +Check the current status of Accord data updates and monitor recent synchronization activities. -1. Go to **Data Management > Accord Synchronization** -2. Select the data type from the dropdown (NAV History, Scheme Details, Portfolio Data, etc.) -3. Choose the date for data retrieval -4. Select the data section (Mutual Fund, Portfolio, NAV) -5. Pick the sub-category based on your selection -6. Click **Start Synchronization** +1. Navigate to **Data Management** → **Accord Status Monitor** +2. Select your date range using the **Start Date** and **End Date** fields +3. Click **View Status Report** +4. Review the summary showing successful updates, failed operations, and pending processes +5. Click on any individual entry to see detailed logs and error messages if applicable -The system will retrieve data from Accord, store it in your database, and upload backup files to secure storage. You'll see a status indicator showing progress, and the system will automatically update the synchronization status upon completion. +The system displays real-time counts of successful and failed operations, along with detailed logs for troubleshooting any issues. -### How to View Data Only Without Database Updates +### How to Manually Trigger Data Updates -Use this when you want to preview Accord data before committing it to your system. +Force an immediate update of specific mutual fund data categories outside the normal schedule. -1. Navigate to **Data Management > Accord Synchronization** -2. Select **Preview Mode** toggle -3. Choose your data parameters (file type, date, section, sub-category) -4. Click **Retrieve Data** +1. Go to **Data Management** → **Manual Data Sync** +2. Choose the **Data Category** from the dropdown (Schemes, NAV, Portfolio, Returns, etc.) +3. Select the **Date Range** for historical data updates +4. Enter the **Section** (typically "MutualFund") and **Sub-section** (NAV, PORTFOLIO, etc.) +5. Provide your Accord **Authentication Token** +6. Click **Start Manual Sync** +7. Monitor the progress in the status window that appears -The system displays the raw data from Accord without making any changes to your database. This helps verify data quality before running full synchronization. +The system will process your request immediately and show real-time progress updates. Large data sets may take several minutes to complete. -### How to Process Bulk Data Updates +### How to Download Raw Data Files -This handles large-scale data updates from stored data files. +Access the original data files received from Accord before processing. -1. Access **Data Management > Bulk Processing** -2. Select the data files you want to process from the available list -3. Review the file contents and record counts -4. Click **Process Bulk Update** +1. Navigate to **Data Management** → **Raw Data Access** +2. Enter the specific **Filename** you want to retrieve +3. Specify the **Date** for the data file +4. Select appropriate **Section** and **Sub-section** parameters +5. Click **Download Raw File** +6. The system will retrieve and display the unprocessed data -The system processes multiple data types simultaneously, including scheme masters, NAV history, portfolio allocations, and fund manager information. Processing time varies based on data volume. +This feature is useful for data validation and troubleshooting synchronization issues. -### How to Check Synchronization Status +### How to Process Batch Data Updates -Monitor the success and failure rates of your data synchronization activities. +Handle large-scale data updates using pre-stored data files. -1. Go to **Data Management > Synchronization Reports** -2. Set your date range using the start and end date fields -3. Click **Generate Status Report** +1. Go to **Data Management** → **Batch Processing** +2. Select **Process Dump Files** from the options +3. Choose the data categories to include in the batch +4. Review the file list showing available data for processing +5. Click **Start Batch Processing** +6. Monitor the audit log for completion status of each data category -You'll see a summary showing successful synchronizations, failed attempts, and detailed logs for each data update session. Failed synchronizations include error messages to help identify issues. - -### How to Run Manual Data Synchronization - -Use this for specific date ranges or when automatic synchronization needs adjustment. - -1. Navigate to **Data Management > Manual Sync** -2. Enter your start date and end date for the data range -3. Select the specific data categories you need -4. Provide the required authentication token -5. Click **Execute Manual Sync** - -The system processes data for your specified date range across multiple data types in the correct sequence to maintain data integrity. +The system processes multiple data types in sequence, updating scheme details, NAV data, portfolio information, and performance metrics. ## Rules and Limits -• Data synchronization requires valid authentication tokens that must be refreshed periodically -• Portfolio data processing uses different handling methods for live versus test environments -• Large data files are automatically queued for background processing to prevent system overload -• Synchronization status updates are tracked with timestamps for audit purposes -• Failed synchronizations automatically log error details for troubleshooting -• Data files are backed up to secure cloud storage during processing -• Bulk operations process data in a specific sequence to maintain referential integrity -• Some data types like mutual fund portfolios have special processing rules for different environments +• Data updates can only be performed by users with system administrator privileges +• Manual synchronization requires valid Accord authentication tokens that are not expired +• The system automatically creates backup files before processing any data updates +• Failed data updates are automatically logged with error details for troubleshooting +• Portfolio data processing may be queued during high-traffic periods to maintain system performance +• Date ranges for manual updates cannot exceed 90 days for performance reasons +• The system maintains a 30-day history of all data synchronization activities +• Duplicate data entries are automatically handled using upsert operations +• Data marked for deletion in Accord feeds will be removed from your platform +• Real-time NAV updates take precedence over batch historical data for the same dates ## Common Questions -**Q: Why did my synchronization show "No Content" status?** -A: This typically means Accord had no new data available for your requested parameters. Try different date ranges or verify your data subscription includes the requested information types. +**Can I update only specific mutual fund schemes instead of all data?** +The system processes data by category (NAV, Portfolio, Schemes) rather than individual schemes. You cannot selectively update single schemes, but you can choose which data categories to synchronize. -**Q: Can I synchronize data for multiple date ranges at once?** -A: Yes, use the manual synchronization feature where you can specify start and end dates to process data across multiple days in a single operation. +**What happens if a data update fails partway through?** +Failed updates are logged with specific error details, and the system maintains the previous data state. You can retry the update after resolving any authentication or connectivity issues. -**Q: What happens if a synchronization fails partway through?** -A: The system logs the failure point and error details in the status tracking system. You can review these logs and re-run synchronization for the affected data types. +**How often does the system automatically sync data from Accord?** +Automatic synchronization schedules vary by data type - NAV data typically updates daily, while scheme master data updates less frequently. Check with your system administrator for your specific schedule. -**Q: How do I know which data types are available for synchronization?** -A: The system supports over 50 data types including NAV history, scheme details, portfolio allocations, fund manager information, dividend details, and various master data tables. +**Can I see what data changed during an update?** +The audit logs show counts of records added, updated, and deleted for each data category, but detailed change tracking requires accessing the individual data modules. -**Q: Can I schedule automatic synchronization to run at specific times?** -A: While the interface shows manual triggers, the system includes scheduling capabilities that your system administrator can configure for regular automatic updates. +**Why do some updates take longer than others?** +Portfolio data and historical performance data contain much larger datasets than basic scheme information, so processing times vary significantly based on the data type and date range selected. ## Troubleshooting -**Problem:** Synchronization fails with authentication error -**Cause:** Your Accord API token has expired or is invalid -**Fix:** Contact your system administrator to refresh the authentication token in system settings +**Problem:** Data sync shows "No Response From Accord" error +**Cause:** Authentication token is invalid or network connectivity issues +**Fix:** Verify your Accord authentication token is current and test network connectivity to Accord services -**Problem:** Data processing shows successful but no updates appear in reports -**Cause:** The retrieved data may contain only deletion flags or no new information -**Fix:** Check the synchronization logs for record counts and verify the date range includes periods with expected data changes +**Problem:** Update process shows successful but data appears unchanged +**Cause:** The Accord feed may not contain new data for the requested date range +**Fix:** Check the Accord data availability for your requested dates and verify the data category parameters -**Problem:** Bulk processing gets stuck on specific data files -**Cause:** Large portfolio data files may exceed processing limits or contain formatting issues -**Fix:** Use the preview mode to examine the problematic file content, or process smaller date ranges to isolate the issue +**Problem:** Batch processing stops with database connection errors +**Cause:** Database connection timeout during large data processing operations +**Fix:** Process smaller date ranges or contact your database administrator to adjust connection timeout settings -**Problem:** Manual synchronization shows connection timeout -**Cause:** Network connectivity issues or Accord system maintenance -**Fix:** Verify internet connectivity and try again later, or check Accord system status notifications +**Problem:** Raw data download returns empty or corrupted files +**Cause:** Incorrect filename format or date parameters in the request +**Fix:** Verify the exact filename format expected by Accord and ensure date parameters match Accord's date format requirements -**Problem:** Status reports show high failure rates for specific data types -**Cause:** Changes in Accord data format or missing dependencies between data types -**Fix:** Process master data types (like scheme masters and AMC data) before transactional data (like NAV and portfolio information) +**Problem:** Status monitor shows operations stuck in "Processing" state +**Cause:** Background processing queue may be overwhelmed or stuck +**Fix:** Check system resources and restart the data processing service if necessary, or contact technical support ## Related Features -This feature integrates with several other IFANOW modules: -- **Mutual Fund Management** - Updates scheme information, NAV prices, and fund performance data -- **Portfolio Analytics** - Provides current holdings data and asset allocation information -- **Client Reporting** - Ensures reports contain the most recent fund performance and valuation data -- **Risk Management** - Updates fund categorization and risk metrics used in portfolio analysis -- **Transaction Processing** - Maintains current NAV prices needed for mutual fund transaction calculations +This system integrates closely with the **Mutual Fund Data Management** module for scheme information updates, **NAV Management** for price updates, and **Portfolio Analytics** for holdings data. It depends on the **File Management System** for storing raw data files and connects to **Audit Logging** for tracking all synchronization activities. The data synchronized through Accord feeds into **Performance Analytics**, **Fund Comparison Tools**, and **Client Reporting** systems throughout the platform.