Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Can SuiteCRM Connect to Multiple Databases?

Can SuiteCRM Connect to Multiple Databases? 2 months 1 week ago #83002

  • michellegoldmandev
  • michellegoldmandev's Avatar
  • Offline
  • Senior Member
  • Posts: 60
  • Thank you received: 1
  • Karma: 1
Is it possible to connect SuiteCRM to multiple SQL databases?

Versions:
SuiteCRM 7.10.7
PHP 7.2
SQL Server 2014
Windows Server 2012 R2
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 2 months 1 day ago #83196

  • ashish@outrightcrm.com
  • ashish@outrightcrm.com's Avatar
  • Offline
  • SuiteCRM Is My Life
  • CTO at outright Systems
  • Posts: 328
  • Thank you received: 32
  • Karma: 4
Single instance to multiple database based upon mulitple URLs?
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 2 months 18 hours ago #83246

  • michellegoldmandev
  • michellegoldmandev's Avatar
  • Offline
  • Senior Member
  • Posts: 60
  • Thank you received: 1
  • Karma: 1
Yes, it would be 1 instance of SuiteCRM that would connect to multiple databases.
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 2 months 17 hours ago #83253

  • mtierno
  • mtierno's Avatar
  • Offline
  • Senior Member
  • Posts: 53
  • Thank you received: 5
  • Karma: 1
How would the instance to decide what database to use in each situation? Some tables in one DB, some tables in the other? Use diferente DBs depending on the user? What is your scenario?
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 2 months 15 hours ago #83259

  • michellegoldmandev
  • michellegoldmandev's Avatar
  • Offline
  • Senior Member
  • Posts: 60
  • Thank you received: 1
  • Karma: 1
We would want to connect to 2 different databases to populate data within SuiteCRM, not user/role specific. Perhaps having separate modules connect to each database.
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 2 months 9 hours ago #83266

  • mtierno
  • mtierno's Avatar
  • Offline
  • Senior Member
  • Posts: 53
  • Thank you received: 5
  • Karma: 1
Sorry, but... why do you want to do that?
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 1 month 2 weeks ago #85267

  • michellegoldmandev
  • michellegoldmandev's Avatar
  • Offline
  • Senior Member
  • Posts: 60
  • Thank you received: 1
  • Karma: 1
Because we have 2 existing databases that will remain in tact and are looking for a crm solution to build around them and be able to communicate with them both. So, is this possible?
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 1 month 2 weeks ago #85278

  • ashish@outrightcrm.com
  • ashish@outrightcrm.com's Avatar
  • Offline
  • SuiteCRM Is My Life
  • CTO at outright Systems
  • Posts: 328
  • Thank you received: 32
  • Karma: 4
Strange situation or you may need to just connect to another database for few situations?
The administrator has disabled public write access.

Can SuiteCRM Connect to Multiple Databases? 1 month 2 weeks ago #85281

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10450
  • Thank you received: 1558
  • Karma: 358
Yes, I think you just need to decide which database is your main SuiteCRM database, and then use the second one as an external system with which you are integrating.

Even if for the end-user the experience is seamless, this is what would make sense technically.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.034 seconds
Powered by Kunena Forum