BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
teresa_abbate
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
shill
SAS Employee

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.


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

View solution in original post

5 REPLIES 5
shill
SAS Employee

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?


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

teresa_abbate
Obsidian | Level 7

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

shill
SAS Employee
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.

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

teresa_abbate
Obsidian | Level 7

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.     

shill
SAS Employee

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.


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

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