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.
elite cleaning services Mundelein ..What is a Web Database?A web database is a database... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
Should one use Windows Update?This topic has good and valid... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
In the real world a "fire wall" is a fireproof... Read More
After seeing many people complain about their weak Internet security... Read More
Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
You turn on your computer, and it doesn't look quite... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Most people understand that the "hardware" part of their computer... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Viruses and spyware usually show up on your computer one... Read More
Airbnb cleaning service Mundelein ..Around the same time Microsoft made its move with .Net... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
It is really interesting that a bug can create problem... Read More
The purpose of one of our projects was MS Exchange... Read More
Anti-virus software is used to find, remove or fix files... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
There are many commands that are used in linux on... Read More
This is the tutorial where we really get into programming.... Read More
Are you one of those people that keeps track of... Read More
CD and DVD replication is a process that works by... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
When Windows fails to boot it is normally caused by... Read More
In the previous ISDN article, we looked at how and... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
User interfaces and accessibility are some of the most important... Read More
The first thing that you will notice about Linux Red... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Words we choose to describe things and phenomena often show... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Software |