Software informational articles

Precious stone intelligence - geterogeneus databases: sql server, oracle, unidata, btrieve ? tips for developer - software


Crystal Intelligence is the most accommodating tool on the promote and it has advertise recognition. Many software vendors offer Gemstone Gossip as the main coverage tool: Microsoft, Best Software, Augur to name a few.

Sometimes developers try to use Precious stone at once to pull data from manifold folder platforms - we appreciate the need to give you further tips to add to Gemstone article flexibility. Also conventional case when Gemstone account be supposed to pull data from manifold file platforms. Presumptuous that you are creating Gemstone Hearsay on Windows platform - we advocate you to use Microsoft SQL Ma?tre d' as a list admittance tool.

1. Use Gem when you have your query tuned - anyhow how good Gemstone Hearsay is - it is treatment tool - not querying environment. Tune your query first and be sure that you are pulling the right data.

2. Use SQL Head waiter Coupled Servers. Use authority tool, such as Microsoft SQL Server, where you can conceive associated servers to Oracle, Ctree, Btrieve, MS Access, Unidata, DB2 and other platforms.

3. Use Scattered Queries - in the case of SQL Ma?tre d'h?tel - do research the promise with OPENQUERY, OPENROWSET clauses to fix to non-SQL Ma?tre d' coupled servers.

4. Create Stored Procedures - when you need parameters to be transferred to the SQL announcement - you need stored procedure. You need stored proc if temp tables are essential to do intermediate job in your SQL query.

5. Report Flexibility - when you have article based on the SQL view or stored proc - if you need to adapt the data query - you don't have to adjustment the arrive - you adjustment your SQL view/ stored procedure.

6. Create SQL Query to probe the data - again - we continually advocate tuning your query and see that you are being paid enough consequences - in any case - Gem Arrive is just a nice tool to show the outcome of your query.

Happy customizing, querying and designing! if you want us to do the job - give us a call.

About The Author

Andrew Karasev is Chief Know-how Executive in Alba Spectrum Technologies - USA generally Microsoft Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle, Canada, UK, Australia and having locations in compound states and globally (www. albaspectrum. com), he is Great Plains Dexterity, SQL, C#. Net, Precious stone Gossip and Microsoft CRM SDK developer.

akarasev@albaspectrum. com

1-866-528-0577! help@albaspectrum. com

Developed by:
home | site map © 2018