Hi all,
In Framework Manger while importing data from database i am unable to import the relations from the data base(data base is OLTP).
i checked Use Primary Key and Foreign key relations.
Please advise how to import the default relations from database.
Thanks,
Karthee
Quote from: karthik12345 on 31 Mar 2016 04:39:18 AM
Hi all,
In Framework Manger while importing data from database i am unable to import the relations from the data base(data base is OLTP).
i checked Use Primary Key and Foreign key relations.
Please advise how to import the default relations from database.
Thanks,
Karthee
Hi,
What database are you using? How are you connecting to it? Do the tables you are importing have primary/foreign keys defined?
MF.
Hi,
Data base is MS SQL Server,
I Created DSN connection for connect the data source
tables which are in the data base are defined Primary and foreign relation.
Thanks,
Karthee
Quote from: karthik12345 on 31 Mar 2016 06:03:57 AM
Hi,
Data base is MS SQL Server,
I Created DSN connection for connect the data source
tables which are in the data base are defined Primary and foreign relation.
Thanks,
Karthee
Hi,
What do you mean by "DSN connection"? Are you connecting via ODBC, via the SQL Server native client or via JDBC? If you are using ODBC, I'd suspect the ODBC driver isn't intelligent enough to surface the key definitions. Try either Native Client or JDBC...
Cheers!
MF.
Thanks MFGF,
Yes, i am using ODBC driver, actually when i imported sample IBM data source(go sales) , i can see the relation here, but when i imported
some other OLTP data source i couldn't find the relations.
Thanks,
Karthee
Quote from: karthik12345 on 31 Mar 2016 09:53:28 AM
Thanks MFGF,
Yes, i am using ODBC driver, actually when i imported sample IBM data source(go sales) , i can see the relation here, but when i imported
some other OLTP data source i couldn't find the relations.
Thanks,
Karthee
Are the keys defined in the same way in both data sources? How are you connecting to the sample go sales data source? ODBC or via native client?
MF.
thanks MFGF,
I used ODBC to connect sample Go sales data source, i followed same procedure for both data sources.
Regards,
Karthee
Quote from: karthik12345 on 01 Apr 2016 07:00:14 AM
thanks MFGF,
I used ODBC to connect sample Go sales data source, i followed same procedure for both data sources.
Regards,
Karthee
Ok. Are the keys defined in the same way in your database as in the sample gosales database?
MF.
If you are connecting to an OLTP and not a Datawarehouse (with a cuddly star schema structure) I would not recommend importing the relationships. You will need to do some metadata modelling in FM otherwise you are likely to end up with unnecessary, not desirable or ambiguous joins...