DatabaseAnalyticsExport Help
Learn how to effectively export and analyze data from a database to uncover trends and draw insights.
Use the Database Analytics Export screen to:
- Schedule an initial Full export of your data from RecTrac to InteliTrac's ElastiCube database.
- Schedule Incremental data exports containing any changes since your last from RecTrac to InteliTrac. This keeps InteliTrac's ElastiCube up-to-date with the very latest information from RecTrac.
Click the Schedule button to launch the standard Schedule Generator screen which enables you to specify the frequency in which the export runs (i.e., daily at midnight).
InteliTrac MUST be configured in your License Profile before accessing the Database Analytics Export procedure.
You must know where the export will be sent, VSI Hosted or a specific FTP site. For FTP, you must know the necessary URL and credentials.
DatabaseAnalyticsExport_Tab1
Tables To Include (DatabaseAnalyticsExport_TablesToInclude)
Click the Combo box icon to select the tables from the RecTrac database to include in this export. Multiple selection is allowed. The tables selected are sent from your RecTrac database to update the InteliTrac ElastiCube. Typically, all tables are selected.
DeleteExport Option (DatabaseAnalyticsExport_ExportOption)
Expand the Drop-down list and select whether to schedule a Full or Incremental export. Your first export should be a Full export of your data from RecTrac to InteliTrac's ElastiCube database. Subsequent exports are scheduled as Incremental data exports containing all changes since your last from RecTrac to InteliTrac. This keeps InteliTrac's ElastiCube up-to-date with the very latest information from RecTrac.
DeleteBegin Date (DatabaseAnalyticsExport_BeginDate)
This field is applicable only if you selected a Full export.
For data that is date dependent determines what is sent from RecTrac to InteliTrac's ElastiCube. Use the date controls to specify the starting date for enrollments and other date-specific data to send. For Example: You might send section enrollments from the start of this year or beginning on another date you specify. The data always includes current and future activities and other similar date-based data.
DeleteTransfer Option (DatabaseAnalyticsExport_TransferOption)
Expand the Drop-down list and select the desired Transfer Option. You can choose from several levels of FTP security or VSI hosted.
DeletesFTP Server / FTP URL (DatabaseAnalyticsExport_URLServer)
This field is applicable only if you selected a FTP Transfer Option.
Enter the URL address to the FTP server in which to upload the export file.
DeletesFTP Host Key (DatabaseAnalyticsExport_sFtpHostKey)
This field is applicable only if you selected the sFTP Transfer Option.
Enter the Public (Host) Key necessary to authenticate on the specified FTP server. This is provided by the IT administrator of this sFTP site.
DeleteUsername (DatabaseAnalyticsExport_UserName)
This field is applicable only if you selected a FTP Transfer Option.
Enter credentials with sufficient permissions to access and write to the specified FTP server. This is provided by the IT administrator of this FTP site.
DeletePassword (DatabaseAnalyticsExport_UserPassword)
This field is applicable only if you selected a FTP Transfer Option.
Enter credentials with sufficient permissions to access and write to the specified FTP server. This is provided by the IT administrator of this FTP site.
Delete