Pentaho Connection to MultiSubnet SQL Server environmentHow can I prevent SQL injection in PHP?How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerInserting multiple rows in a single SQL query?How do I UPDATE from a SELECT in SQL Server?How to Delete using INNER JOIN with SQL Server?
Why did MS-DOS applications built using Turbo Pascal fail to start with a division by zero error on faster systems?
How can I watch the 17th (or last, if less) line in files of a folder?
grade 5 bolts not marked if galvanized?
How would one country purchase another?
Would it be possible to have a GMO that produces chocolate?
Why did this happen to Thanos's ships at the end of "Avengers: Endgame"?
Can I switch to third-person while not in 'town' in Destiny 2?
Church Booleans
Fried gnocchi with spinach, bacon, cream sauce in a single pan
Avoiding racist tropes in fantasy
Does the length of a Scientific report imply anything about credibility or thoroughness?
Why does my house heat up, even when it's cool outside?
What does it mean to have a subnet mask /32?
confused about grep and the * wildcard
Why don't electrons take the shorter path in coils
Most practical knots for hitching a line to an object while keeping the bitter end as tight as possible, without sag?
How should I face my manager if I make a mistake because a senior coworker explained something incorrectly to me?
In what ways can a Non-paladin access Paladin spells?
Potential new partner angry about first collaboration - how to answer email to close up this encounter in a graceful manner
Why doesn't the Falcon-9 first stage use three legs to land?
Was Switzerland really impossible to invade during WW2?
Justifying the use of directed energy weapons
Defense against attacks using dictionaries
If the first law of thermodynamics ensures conservation of energy, why does it allow systems to lose energy?
Pentaho Connection to MultiSubnet SQL Server environment
How can I prevent SQL injection in PHP?How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerInserting multiple rows in a single SQL query?How do I UPDATE from a SELECT in SQL Server?How to Delete using INNER JOIN with SQL Server?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
In Hitachi Pentaho 8.2 Data Integration (Spoon) we are trying to configure "MultisubnetFailover=True" for a SQL Server database connection.
For database connections we are using "MS-SQL Server(Native)/Native JDBC". The problem is that I can't find where to set this property in the Database Connection component, and it doesn't look like I can specify the complete connection string for the driver to use. Where can I set this property?
It doesn't look like the Options tab is the correct place for setting this property, and I don't see a way to just specify the entire connection string myself. Also, ODBC can't work for us because the ETL changes the server and database dynamically (we use Pentaho variables to vary those) and ODBC is only one hardcoded connection.
Any help will be appreciate it.
sql
sql-server etl pentaho pentaho-data-integration asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
add a comment |
In Hitachi Pentaho 8.2 Data Integration (Spoon) we are trying to configure "MultisubnetFailover=True" for a SQL Server database connection.
For database connections we are using "MS-SQL Server(Native)/Native JDBC". The problem is that I can't find where to set this property in the Database Connection component, and it doesn't look like I can specify the complete connection string for the driver to use. Where can I set this property?
It doesn't look like the Options tab is the correct place for setting this property, and I don't see a way to just specify the entire connection string myself. Also, ODBC can't work for us because the ETL changes the server and database dynamically (we use Pentaho variables to vary those) and ODBC is only one hardcoded connection.
Any help will be appreciate it.
sql
sql-server etl pentaho pentaho-data-integration asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21
add a comment |
In Hitachi Pentaho 8.2 Data Integration (Spoon) we are trying to configure "MultisubnetFailover=True" for a SQL Server database connection.
For database connections we are using "MS-SQL Server(Native)/Native JDBC". The problem is that I can't find where to set this property in the Database Connection component, and it doesn't look like I can specify the complete connection string for the driver to use. Where can I set this property?
It doesn't look like the Options tab is the correct place for setting this property, and I don't see a way to just specify the entire connection string myself. Also, ODBC can't work for us because the ETL changes the server and database dynamically (we use Pentaho variables to vary those) and ODBC is only one hardcoded connection.
Any help will be appreciate it.
sql
sql-server etl pentaho pentaho-data-integration asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
In Hitachi Pentaho 8.2 Data Integration (Spoon) we are trying to configure "MultisubnetFailover=True" for a SQL Server database connection.
For database connections we are using "MS-SQL Server(Native)/Native JDBC". The problem is that I can't find where to set this property in the Database Connection component, and it doesn't look like I can specify the complete connection string for the driver to use. Where can I set this property?
It doesn't look like the Options tab is the correct place for setting this property, and I don't see a way to just specify the entire connection string myself. Also, ODBC can't work for us because the ETL changes the server and database dynamically (we use Pentaho variables to vary those) and ODBC is only one hardcoded connection.
Any help will be appreciate it.
sql
sql-server etl pentaho pentaho-data-integration sql
sql-server etl pentaho pentaho-data-integration asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
edited Mar 27 at 16:38
ArbiBaghdanian
asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
asked Mar 27 at 16:26
ArbiBaghdanianArbiBaghdanian
62 bronze badges
62 bronze badges
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21
add a comment |
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55382105%2fpentaho-connection-to-multisubnet-sql-server-environment%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55382105%2fpentaho-connection-to-multisubnet-sql-server-environment%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you tried the "Generic database" connection type? You can specify the exact JDBC connection URL you want with that with that. It might allow you to workaround the issue if the Options tab isn't giving you the desired outcome using the regular "MS SQL Server" connection type.
– eicherjc
Mar 28 at 21:21