Plan, execute, measure and optimize customer experiences

Create different db connection for each db partition

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

Create different db connection for each db partition

Our db has two different partition: One for Outbound campaign table and one for Inbound campaign table.

CI is configured for the outbound partition connection. It is possible create an other connection for sas Customer Intelligence that references the inbound partition? 

 

Thanks,

Teresa


Accepted Solutions
Solution
‎10-17-2016 11:04 AM
SAS Employee
Posts: 70

Re: Create different db connection for each db partition

For a data process during execution, yes - it only uses the JDBC connection resource's definition, so you should use that point to the database you'll be using for real-time (hopefully a different database than one used for batch applicaitons like MA!). It uses the SAS library that goes with that (connected by matching the name of the Library System Resource) when you're creating a definition - that's where it gets the metadata to define the criteria and retrieval variable names.

View solution in original post


All Replies
SAS Employee
Posts: 70

Re: Create different db connection for each db partition

Can you please clarify your situation a little for us? What database are you using, and when you say "partition" do you mean "schema" or a totally separate database instance?

Contributor
Posts: 24

Re: Create different db connection for each db partition

We work with an Oracle DB which has 3 istances and 3 differents service names.
It is possible specify differents service names for outbound campaign connection and inbound campaign connection?

 

thanks,

Teresa

SAS Employee
Posts: 70

Re: Create different db connection for each db partition

While all of your data sources for MA (outbound campaigns) should be using the same connection (in other words, even if you have multiple libraries included in one information map the only allowable difference between them is the "SCHEMA=" parameter), every data process used by RTDM (inbound campaigns) is executed separately, so the data can come from any (supported) connection.
Contributor
Posts: 24

Re: Create different db connection for each db partition

do you mean that RTDM connection uses only the jdbc connection resource configured on the decision services for reading db tables?

In this case, it' enough changing the service_name in the resource's server url.     

Solution
‎10-17-2016 11:04 AM
SAS Employee
Posts: 70

Re: Create different db connection for each db partition

For a data process during execution, yes - it only uses the JDBC connection resource's definition, so you should use that point to the database you'll be using for real-time (hopefully a different database than one used for batch applicaitons like MA!). It uses the SAS library that goes with that (connected by matching the name of the Library System Resource) when you're creating a definition - that's where it gets the metadata to define the criteria and retrieval variable names.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 332 views
  • 0 likes
  • 2 in conversation