Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


SQL server crm integration

SQL server crm integration

SQL server crm integration

I have an on premises sql server. The sql server has all my business data and customer contact information. I would like to sync the sql server with a crm product that would allow me to send emails and letters based upon the data in the sql server. Does anyone have a good recommendation for a crm product that would work well with my sql server.

RE: SQL server crm integration

Sorry, I don't know a CRM adapting to any database design, it's typically vice versa, even CRMs open for extensibility and offering an API will require you to use their database directly or indirectly.

Just think about how things are coded, perhaps over the top of your head, if you never programmed something. Use of databases means queries, no matter if hand crafted or generated, they depend on a certain table structure, names of tables and fields, types and relations, maybe even triggers. You can't just attach any database, even though it has all necessary essential info for a CRM.

And there's another reason nobody being sane can give you a recommendation for a CRM: You don't tell anything about the size of your company and database. With just a couple of customers some systems are perhaps good enough, but with a rising customer base, you may need more sophisticated features. That's not just a problem of scaling well with the number of customers.

This is not like asking for a good hard drive or choice of Intel vs AMD CPU. This decision is not a merely technical one, it's a business decision and only you know your needs, so you canÄt delegate the decision for a CRM to anyone else.

What you will need, if your own applications process customer data, too, is either a full migration to let the CRM take over that part of your application features, too, then do away with your customer related tables and application features. Or you have to establish a two-way ETL process from your database to a CRM system database or API to keep CRM data of a CRM system and your database in sync. For that to be possible you need a CRM that is open about it's data, but it's not that kind of openness to let itself be adaptable to any database, in the first place it means to allow connections to its database in the first place. A system you rather use in the cloud as a service will likely not offer direct CRM database access, but access via web services or a Restful API, which would need to be used to write and read data to it. That'll be a costy module just to adapt your own data and CRM system data, but it may be worth it.

So you missed a past decision to look for a CRM system first and adapt your own development to the way the CRM needs its data. It's also a reason for the success of ERP systems like SAP, if a company is bigger. ERP systems don't just cover one topic like a CRM or a PLM or a Shop system, they cover the whole business.

Bye, Olaf.

RE: SQL server crm integration

OLAF thank you for the long response. What i think i want is a live sync of my current on site sql server with a CRM product. I currently have a view setup in the SQL server that has most of my important data. Currently, i run mail merges based upon the information in the view set up in the SQL server. Is there a CRM product that i can easily use the information in the SQL view to automate many of my processes.

RE: SQL server crm integration

I am not the expert of CRM systems. "Only" of database software development in general. This way is not the way it works. You never dictate where and how a system stores its data. You have to provide it in the way it needs it. In the worst case, a CRM system does not have an open interface for mass data input, many systems work closed in themselves. Of course CRM manufacturers know customers also are part of shop system and commercial or other campaigns, but that does not mean they are open to whatever you feed them.

To get an idea how you might attach to a online CRM, take a look at the API of insightly: https://api.insight.ly/v2.1/Help
Or Salesforce: https://developer.salesforce.com/page/Salesforce_A...
Or Sugar CRM: http://support.sugarcrm.com/Documentation/Sugar_De...

They don't work with views, they provide API calls to add data to their own databases.

Bye, Olaf.

RE: SQL server crm integration

What product did you use to put all your data into SQL Sever. It is not generally the product of choice for just basic data entry?


RE: SQL server crm integration

I use a program that was designed for me, it is built on 2014 SQL Server 2014 Management Studio. Would the Microsoft CRM allow me to use the database data to send emails and letters.

RE: SQL server crm integration

Every CRM has it's own database, you can't point any software, also not MS, to use your specific database, you have to transfer data in one or another way.

Microsoft Dynamics, are you talking about that? If that isn't used for your software already, it would mean a new SQL Server database (or a couple) would be generated, if you were to use that CRM and that would then need to be fed with your customer data.

In the end the bridge of your software and a CRM always will be porting data over, if only customer name and mail address. The CRM will generate it's own customer ID and all you need to map this to your data then will be your own systems ID and the CRM system ID. It's not impossible to do and once that bridging is established it may be synced even almost live, so each time your own software adds a new customer, it will also be made known to the CRM. That's what an ETL (export, transform, load) process does, though this terminology mainly is used for puling together data from multiple systems to a data mart or data warehouse for BI analysis.

Any CRM will have its own database. You exepct this to act like a hardware, like an oven, in which you can put whatever food you want. Software doesn't work that way.

Bye, Olaf.

RE: SQL server crm integration

Do you have any programming experience? The things you are wanting to do are pretty basic and could be accomplished any pretty much any language like Visual Basic or Python. Your fiends Google and Youtube would get you pretty far.


RE: SQL server crm integration

I agree with Simi, this is one of the possible choices, as you started off with software custom made for you, continue in that direction.
It also isn't impossible to export just the essential customer info and transform and load it into a CRM for making use of the whole feature set of that CRM, it does not end in mail merging for sure.

But the most plausible solution is to extend your custom software. If you see that custom software as a failure, if you don't cooperate with the vendor or developer anymore, the extension will be hard, then it would be advisable to migrate to a wholesome system anyway, not only CRM.

You can't stick together modules like CRM and PLM from different vendors easily, this is not a lego system. Either you go for individual custom made application landscape or a wholesome software suite like MS Dynamics. You can't pick just the Dynamics CRM module and combine that with anything else. The moment you opt for SaaS cloud solutions your major cost factor is finding developers for interfacing such a module landscape. And you also opt for not storing all data in a central single database, those systems will all keep their data in their places, you even don't keep them in house anymore. Both a burden and a relief. Backup and security needs go to the SaaS provider, responsibility for data privacy stays with you, though.

If you only aim for mail merge, well, then do you r own mail merge, a CRM offers much much more. Actually it is normally the system leading to customers, making contacts to leads to customers to recurring customers...

Bye, Olaf.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close