Accessing FM from SQL Server 2005

[yi01]

Hello,

I need to access data in FM from SQL Server 2005. For example, I can need to copy data from FM table to a SQL Server table.

Thanks in advance.

[Simon K]

Hope the following thoughts help:

SQL Server 2005 can connect to a variety of databases using SQL Server Integration Services (latter day DTS packages)

I am not sure whether you could use the ODBC FM ODBC driver DataDirects SequeLink as a DataSource

Even if you could I would be very wary of what fields you try and query - eg unstored calcs which are TO context sensitive may return meaningless data when accessed from a TP application.

So I would suggest that you are going to need to look at the data you want from FM, consider whether you can make it available dynamically or whether you will need to script an output (possibly an XML/XSLT construct) and then look at how best to use the SSIS wizards to automate data passage.

If you want business intelligence tools against FM alone (ie there is no additional data) then perhaps you could consider something like Omniscope but still beware the ODBC output.

No doubt others will have some real life experience and can fill in some more detail for you

HTH

Simon

Try this link: MS SSIS 2005