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.
I like my software simple. If it's too complex or... Read More
While I was preparing some personal background information for a... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
NOTE: Please take time to read on - it may... Read More
So, why should you use any O/R mapping tool? I... Read More
Words we choose to describe things and phenomena often show... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
The software giants don't do everything and don't always produce... Read More
For a windows user like me, just can watch with... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
When you double-click a layer in the Layer Palette, you... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
If you are in a business that passes documents around... Read More
Microsoft CRM is now on the scene and it is... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
If you've been using MySQL database to store your important... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Adware is a type of Spyware program that displays some... Read More
Around the same time Microsoft made its move with .Net... Read More
After almost two decades of existence, Quark has become the... Read More
The intentions of this short tutorial are not to teach... Read More
IntroductionPHP can be used for a lot of different things,... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
1. What determines the software price? Is it Per Seat... Read More
Itâ??s easy to understand why you might be drawn to... Read More
1. With mapping software you can create a report that... Read More
While I was in college, if you would have asked... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
We all take the computer for granted. I mean, all... Read More
While Adobe is the most known maker of PDF tools,... Read More
Remember old good days when your company probably had Great... Read More
XML Server can be a Web Server that stores the... Read More
The fact that a software tester is a most infamous... Read More
I like my software simple. If it's too complex or... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Imagine something that follows you home and sets itself up... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
People often ask me: What image file formats will Photoshop... Read More
If you copy something from a Web site or elsewhere...... Read More
Trying to figure out a stream in banning one email... Read More
The research in the field of Natural Language Processing usually... Read More
This short paper will expand on two key reasons to... Read More
Are you a database professional? Do you work with a... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Software |