Hi
I'm trying to adjust an existing custom DIXF entity to map from from an ODBC data source which connects to an SQL Server database
I have followed these steps to set it up: community.dynamics.com/.../ax-2012-import-data-from-an-odbc-through-dixf
The ODBC connection works and I can query the external database successfully using the preview button to return most of the columns
However, when I try to map a column which is of the type datetime in the external database to a column in the Ax staging table which is of the type TransDateTime, I receive a warning "Invalid data type" and the mapping cannot be saved
When I debug this process I can see a method being called DMFSourceXMLToEntityMap.EntityField:Validate and the following check being failed:
select firstonly dmfDataTypeMapping
where dmfDataTypeMapping.Source == sourceFields.FieldType (this is detected as a string, not a datetime)
&& dmfDataTypeMapping.Target == enum2str(types); (this is picked up as UtcDateTime)
if (!dmfDataTypeMapping)
{
ret = checkFailed("@DMF843");
}
I don't see an easy way around this other than just change my staging table field from TransDateTime to string
It's odd because when trying to do something similar in DIXF using a CSV file as the source I don't have any issue
Any ideas if I'm doing something wrong or if using DIXF and ODBC is flaky in Ax 2012 R2 CU7 ?
