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.
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
We were recently faced with a decision: either to let... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
You might think you don't need a firewall... Read More
Program Flow is what you think it is. How the... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
When Windows fails to boot it is normally caused by... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
If you look back to the history, you will see... Read More
A wiki is an editable text-based website. But you don't... Read More
Each Industry and market niche has business specific and unique... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Just when you thought you were Web savvy, one more... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Did you ever give a thought to the number of... Read More
Well, even if the combination might look very unusual, we... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
How do you run a program on a remote server... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Finding the best spyware removers to detect and remove spyware... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
The Windows registry is a huge database that ensures normal... Read More
When reading an article where some term is used often,... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Research bears that less than 70 percent of development projects... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
The adware and spyware definitions list is very long. But... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Looking at all the ads which promise to get rid... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
When Great Plains Software was designing and developing Great Plains... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Learning how to program software seems like a daunting task... Read More
Let us give you - developer some hints in the... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Software |