11/26/2024 8:26:09 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Saleslogix integration with the external web site
Posted: 31 Jul 07 1:13 PM
|
Dear All,
My company is building an external website to allow our clients to access certain information online. Certain data will be exported or synchronized from the Saleslogix database to the website's database so we know the clients' preference etc when they log on the site. We would like to reduce the manual work so we are thinking set up database level synchronization. We also like to synchornization happen almost close to real time.
To do so, we create indexed view, which allow easy synchronization setting. But we ran into many problems with indexed view. One of the problem is the conflict with SLX OLEDB provider. We will have to change the default database setting in order for the slx oledb provider to work properly.
I have two questions to the community:
a. What is the implication to change the default SQL database settings to the following? (I understand Sage would not recommend it but what is the real reason??) Any problem you may have seen during your development?
ANSI_NULLS == Set to be ON
ARITHABORT == Set to be ON
CONCAT_NULL_YIELDS_NULL == Set to be ON
QUOTED_IDENTIFIER == Set to be ON
ANSI_PADDING == Set to be ON
ANSI_WARNINGS == Set to be ON
NUMERIC_ROUNDABORT == Set to be OFF
b. Any suggestions on such web site implementation? Should we have a completed different opproach? I am very interested in learning how other integration their external web site with the Saleslogix CRM system.
We are running SQL 2000 (may upgrade to SQL 2005 next Summer) and SLX 6.2.4 for now.
Thank you so much in advance.
Erica |
|
|
|
Re: Saleslogix integration with the external web site
Posted: 01 Aug 07 12:24 AM
|
I'd take a different approach, but that does depend on your setup a bit. Is the SLX on the same SQL Server as the website's database? Or at least visible? Why do the synchronization at all? Just read the data you need from the SLX database (which could be done as a cross-database view in the website's database that reaches to tables in the SLX database - or just direct reads from that database). When writes are needed to SLX you would just write it back via the OLEDB provider (or skip that if you don't have remotes  ). For me, I just wrap up the calls to the SLX database in some nice & clean layer and use that from the website. |
|
|
|
Re: Saleslogix integration with the external web site
Posted: 01 Aug 07 1:13 PM
|
I agree with Ryan - if your web database is on the network, then create a dll that the website can use that can access the SalesLogix database. For my company, we have several websites that access the SalesLogix database for customer use, and we host those websites on remote servers, so they can't access the database directly. Instead, we build what we call the Data Access Layer, or DAL, that manages the communication between the SalesLogix database through the SalesLogix provider and the websites. The DAL server is hosted onsite, and then there are DAL clients (DLLs) that are registered on the web server that speak directly to the DAL server through .Net remoting. This is, of course, more complicated, but it still allows for real time access to our central SalesLogix database without synchronization. After dealing with syncing of remote offices and straight syncing of databases through other 3rd party tools, I've come upon the following opinion - I dislike database synchronization. I'm always paranoid now wondering if there are any data issues after a period of synchronization.
As for database settings, I have never attempted to change those at all, so I couldn't tell you anything about those. |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|