matiasnino

Hi! Thanks for the response. The iNum column is unique within a report, but it appears to reset itself and repeat from report to report, thereby preventing the table from setting that column as a primary key. We may be able to circumvent this by creating a database VIEW that retrieves only the latest report and creates a concatenated column with unique values. Nevertheless there are maintenance considerations with this. We may consider it in the future. Thanks for the correspondence. We will definitely keep up with future versions of Aida64.

Hi! Thank you for your help. Aida64 is great software. However, we will probably not be purchasing Aida Business due to the fact that the SQL data model is inconvenient for connecting from Sharepoint due to the following issues 1) The Item table does not contain a unique identifier column. (Sharepoint requires this) 2) The report data is cummulative such that every update is an INSERT, thus there is no "refreshing" or UPDATE of currently existing reports. This in turn requires data transformating SQL code to pull the 'latest' report and it is expensive for us to produce this transformation code. We may consider this in the future if new versions support a way to create static reports in SQL that can be REFRESHED without creating new rows. That way all report rows are static and can be connected to Sharepoint/Visio/Excel. Thank you for all your efforts in creating such elegant software.

Thank you!

I'm evaluating Aida64 to use on a small business network and I'm trying to set up report output to a local SQL Server database. I am able to connect fine to a DB and specify a db instance in database preferences. However, when I try to add reports to the database I get an insert error because there are no tables to store the data. How do I go about making Aida create the needed tables? Thank you. MN.