Hi,
I am very new to Jet and i'm trying to use Jet Data Manager Server to pull information from two data sources (one is MS SQL, one is MySQL) into a staging database.
The fact tables in each data source are very large, so i want to add data selection rules to the tables so that only records from this month will be included.
With the MS SQL data source, the field i am filtering on is type datetime, if i use date is greater than or equal 11/01/2015, this works and i only get records from this month.
However on the MySQL data source, the field i need to filter on is type timestamp e.g. 2015-11-19 13:20:00 i can't find the right data selection rule to only include records from this month
Thanks,
Tommy
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Tommy,
Firstly, I want to mention that filtering your source database is typically only reserved for development work. If the overall size of the database is a concern, then you should address the system resources first. If active, the database will continue to grow; as time goes on your static date selection rule will be further and further out leading to larger amounts of data. Otherwise, filtering the source for the purposes of development can be helpful in limiting the overall time it takes to process certain tables early on. In this scenario, the data selection rule will be removed once development is finalized.
MySQL fields with 'TIMESTAMP' data types are treated much like a traditional datetime fields. In fact, the Jet Data Manager will probably read the field type in as 'System.DateTime'. To place a data selection rule against your 'TIMESTAMP' field, right-click on the TIMESTAMP field in your source connection and select 'Add Data Selection Rule', select the 'Greater Than' operator, and lastly input your selected date. In my testing, date data selection rules will work in the MM/DD/YYYY format or YYYY-MM-DD format against a MySQL source database.
Please sign in to leave a comment.