Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Wednesday, October 31, 2007

SQL Quick tip - OpenQuery

Alright, it's been a while since I had to do this, but just in case. If you are in an implementation and you happen to be moving data from Oracle or and AS/400 and want to query the tables and views, first:

  • Take and create a linked Server, with the correct provider to the database.

  • Make sure to make use of the openquery syntax

The syntax for openquery goes: select * from openquery(Linked_Server,'Select Statement')

This will save a lot of pain, and allow the other server to handle servering up table attributes, data types and the likes that will cause issues if you try a standard linked server, FQN statement. :-)

Check back soon!

Find a job at: www.DynamicsAXJobs.com

Labels: , , ,


Post a Comment

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved