| |
| |
|
|
Software Information |
|
|
|
SQL Administrator Skills Required to Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house ? Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales Commissions, Bill of Lading, Sales Order Status with Purchasing info, Regional Sales, etc.) - you need to deploy Crystal Reports or Crystal Enterprise. Crystal Report itself is usually based on the view or stored procedure. So - you should expect to be familiar with Great Plains tables architecture and be capable to create select statement with multiple joins and unions ? Data Repair. You should be ready to save GP table prior to data repair: select * into SOP10100_Copy from SOP10100 and then use update statement to fix incorrect values. If you need to load SOP10100 back from the backup table - first drop DEX_ROW_ID column and then use: insert into SOP10100 select * from SOP10100_Copy. ? Backup and Restore. Great Plains has DYNAMICS database which stores system info, such as users, security, companies, etc. and each company has its own database. You should be able to restore mostly company databases from the backup. This seems to be trivial routine. ? Technical Support. When you have issues with posting or need help from Microsoft Business Solutions Technical Support, you place case through customer source and you should expect the technician provide you with SQL scripts to fix your data. ? Some Useful Scripts. You need to be able to delete locked user: delete activity where userid='TOM', also very popular is batch recovery script, you need to unlock the batch in SY00500 table: Posting Definition Master ? Do not expect. Replications (except probably snapshot) - it adds GUID column and then Great Plains Dexterity runtime can not upgrade the modified tables. Referential Integrity is not used, Varchar or NVarchar are not used - the reason is - Dexterity architecture, which was initially designed with database independence in mind. Logins and access management - Great Plains uses its own security, which is translated into SQL logins with encrypted password. ? Moving Great Plains on the new SQL Server. It is often confusing for the DB Admin. Besides physical move through backups or detach/attach DB you need special scripts to transfer GP security and users logins, these scripts are available through MBS tech support or feel free to call you MBS partner. ? Advanced Techniques. If you need to notify your GP users on the specific event in GP - such as invoice was paid, you can deploy SQL emailing: xp_send_mail. This procedure could be called in the trigger for the apply payments table. ? Data Integration. XML inbound and outbound streams for the integration stored procedures is becoming defacto standard. Also you should be familiar with heterogeneous SQL queries: OPENROWSET and linked server conceptions. Happy implementing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.
MORE RESOURCES:
Software - Google News |
|
|
|
RELATED ARTICLES
Five Tips For A Great Software Demo Whether you need to close a sale, gather end-user feedback, show progress to your customer, or simply explain how your product works, sooner or later, you will need to demo your software product.Over the years, I've had the opportunity to perform hundreds of demos to audiences of various sizes. DB Integration - Software for Combine MS Access Databases Our company, Novaprof Inc., developed unique software - DB Integration. Introduction To ISDN, Part III: PAP Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN authentication schemes. The two methods Cisco certification candidates must be familiar with are PAP and CHAP. COSMIC: A Small Improvement on the Symons Method The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual system in use and internationally recognised, whereas MarkII, like other older systems, is not recognised anywhere, and, even in the UK is in decline if not actually dormant, so this debate is already over.Historically, from my limited understanding of the situation, it seems that originally there were upwards of 35 variants of function point style metrics until the ISO developed criteria for a acceptable solution, ISO 14143: Parts 1 to 5 (1995-2002):The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK. Cisco CCNA Certification: Becoming A Truly Valuable CCNA. I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates. The CCNA is an exciting beginning to your Cisco career, but just having the certification simply isn't enough. Microsoft Small Business Manager Customization Options - Overview Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based application and successor and small business market niche version of Microsoft Great Plains. Microsoft Great Plains itself has variety of customization and integration tools: Integration Manager, VBA/Modifier, Great Plains Dexterity, SQL Server stored procedures to name a few. Choose your Java Wisely Java has come along a long way. Many would agree with this. Microsoft Great Plains on Ctree or Pervasive SQL - What to Do - Tips for IT Manager As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence - via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. Microsoft CRM Data Import FAQ Microsoft CRM has built-in conversion tool, however you should probably first try third party conversion tool, such as Scribe. It is relatively expensive and has bunch of importing capabilities, that you might never use and need. What is Spyware? Are You Being Watched? Find out why Spyware Removal from computers is important and how adware infestations affect your computer, your privacy and your family.Internet users worldwide spend several hours to several days each week browsing or searching the net. Software Automation Helps Increase your Bottom Line When you own a small business, time is money. And every time a task that should be automated is handled manually, it wastes your time and your business loses money. Microsoft Great Plains: Customization Upgrade & Recovery - Visual Studio VB 6.0 Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th - the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6. ERP System of the Future: Database, Business Logic and Interface We will base our prognosis on our Microsoft Business Solutions ERP consulting practice: Microsoft Great Plains, Navision, Axapta, MS CRM. Also we've analyzed Oracle products: Oracle Financials, JD Edwards, PeopleSoft, and IBM Lotus Notes Domino. Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist Microsoft Great Plains is main Microsoft Business Solutions product, targeted to mid-size companies. Currently Microsoft is in progress of transforming several ERP products it has: Microsoft Great Plains, Solomon and Navision into several business suites - Microsoft Financial, Microsoft HR, Microsoft Manufacturing, Microsoft Logistics. Put Some Pizazz in Your Software Arsenal The software giants don't do everything and don't always produce the result that we want. At least if you're like me, and you're not where you would like to be (profitwise). Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon Bad News - the Threat is Bigger than it SeemedHow recently it was - when even many journalists thought that spyware gathers mostly information to be used for targeted advertising. Definitions like "spyware, a. Software Engineering: An Introduction Software Engineering is the Systematic Approach for analysis design implementation and maintenance of Software .It involve the use of Case tools. Microsoft Great Plains: exchange & brokerage - implementation notes If you company is small or mid-size special products or materials exchange broker, you probably have custom in-house made exchange application. Nowadays exchange is done over the internet, so you might have advanced web-based exchange application. International Support - Microsoft Great Plains VAR/Partner Selection - Overview for V.P. IT Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. It seems to be goof solution for mid-size and even large multinational corporation with Headquarters in US and branches Worldwide. Computer Based Language Development and Spell-checking Language development computer: Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inability to deal with erratic behaviour.
|
| home | site map |
| © 2006 |
