Tag: SQL Server
Which Versions of Windows Server and SQL are Compatible With Infor CRM v8.3.x and Above?
Are you looking to set up a server to run Infor CRM, but need to know which version of Windows you should use? Want to upgrade your SQL server, but want to make sure the new version will run your CRM database? If you are provisioning a server for Infor CRM, here are the versions of Windows and SQL...
Required Activity Attributes in the Infor CRM 8.4 Web Client
We recently ran into an issue with a client on 8.4 who was doing a back-end SQL data import into the Activity table. The were unable to see any of the Activities from the main Activity Manager page in the web client. The Activities could be seen under the Activity tabs under the Account, Contact, Lead, etc. pages, just...
Do not enable No Count on Infor CRM (Saleslogix) SQL server
Do not enable No Count on a SQL server running Infor CRM (Saleslogix).
Checking for URL values for IDN compatability
Yesterday, Kris posted about a new issue in 8.309 regarding URL controls. To check for this condition, I put together a quick SQL function that can be used to check url values to see if they would be affected by this bug.
Why is my Infor CRM (Saleslogix) so slow?
There are many possible reasons Infor CRM (Saleslogix) can be slow. Here are a few possible causes worth looking at.
Setting the Default Group/Default Layout Group for All Users in Infor CRM
In the Infor CRM web client, each user can define for each Entity level what the default group is, as well as the group used in the Lookups. This is normally set by each user from within the web client under the Tools...Options menu item, and then accessing the Groups tab.
If you want to globally set a default...
Finding References to A SQL Object within Views and Procedures
We recently had a customer who wanted to find out if there were any references to another SQL database within the SQL views and procedures that had been developed within their Infor CRM database. There is a way to do this by using the sql_modules. Objects of type Store Procedures, Replication Filter, View, Trigger, Scalar Function...
SQL for Infor CRM 8.3.x
When we are assisting clients with an upgrade or new installation of CRM, we are frequently asked what version of SQL should be used.
Executing a Business Rule via the Infor CRM SData API from T-SQL
I had the need to call a business rule in Infor CRM from a stored procedure in SQL. This turned out to be a relatively easy task, although you want to make sure you think through what you're doing for this to not introduce performance problems in SQL. Keep in mind, sometimes SData requests can take a bit to...
How to Import Data Into Infor CRM (Saleslogix) Using SQL Server Integration Services (SSIS) With Auto-Generated Table ID Values
Importing data into Infor CRM (Saleslogix) is a task that is typical for any system. However, sometimes the custom format table ID values are a roadblock in using standard, or widely used tools to do the job. In this article I will look at creating a simple data import using SQL Server Integration Services (SSIS) and have the Infor...
